Conversion from FBA to FB

Prasanya · New User Joined: 04 Jun 2007 Posts: 34 Location: Chennai

Hi
I need to convert a FBA file to FB file. My FBA file is a log file. I have tried converting using synsort, IEBGENER and FILEAID but the target file is not having the same positions as in the input file.
Example, My input FBA file has the 3rd record from position 2 to 55 like,
NOTE: Running on IBM Model 2097 Serial Number 014A32,

But in my output file it is in the 2nd record itself from position 32 to 85 as
�NOTE: Running on IBM Model 2097 Serial Number 014A32

Please let me know how do i handle this without changing the positions except for the 1 byte for FBA

expat · Posted: Mon Feb 08, 2010 4:40 pm Post subject:

Unless you post the code and output from the batch job that you submit there is very little anyone can really do to help you.

Prasanya · New User Joined: 04 Jun 2007 Posts: 34 Location: Chennai

My conversion code using IEBGENER is

expat · Posted: Mon Feb 08, 2010 5:04 pm Post subject:

I think that using your SORT product would be easiest

Prasanya · New User Joined: 04 Jun 2007 Posts: 34 Location: Chennai

i got the same out put when i used the following job

PeterHolland · Posted: Mon Feb 08, 2010 5:33 pm Post subject:

Why would someone want to reformat SAS log output?

And if there is a SAS log, i guess SAS is installed.
So use SAS to get rid of the print control character.

Prasanya · New User Joined: 04 Jun 2007 Posts: 34 Location: Chennai

Can you please tell me how to do it with SAS?
I need to validate some data and thats why i need the positions.

Prasanya · New User Joined: 04 Jun 2007 Posts: 34 Location: Chennai

Isn't there a way to do this using SORT?

expat · Posted: Mon Feb 08, 2010 5:45 pm Post subject:

What are the file attributes for the input, and what do you want them to be for the output.

Prasanya · New User Joined: 04 Jun 2007 Posts: 34 Location: Chennai

File attributes for Input file:
Organization . . . : PS
Record format . . . : FBA
Record length . . . : 255
Block size . . . . : 27795

File attributes for Output file:
Organization . . . : PS
Record format . . . : FB
Record length . . . : 254
Block size . . . . : 25400

expat · Posted: Mon Feb 08, 2010 6:39 pm Post subject:

/Good mood ON

I use DFSORT here, but for such a simple task as this I can not see that the control statements would vary very much, if at all, but if they do I'm sure that one of the SYNCSORT users / support will be better able to help you.

dick scherrer · Posted: Mon Feb 08, 2010 8:42 pm Post subject:

Hello,

I also wonder about the need to make an entire copy of the file when all of the needed data is in the original?

Is there some reason to not process the existing file?

Prasanya · New User Joined: 04 Jun 2007 Posts: 34 Location: Chennai

While processing the existing file, am having mismatch in the positions that i give in my sort control cards.. Please help me with this. I need to check for the presence of certain data in the existing file.

Arun Raj · Posted: Tue Feb 09, 2010 12:10 pm Post subject:

enrico-sorichetti

You have not explained yet what You want to achieve,
clarity when asking for help is a prerequisite for good answers...

You posted two files samples...
the first one is, looks like, a sysout/sysprint dataset

the second one even if contains the same info, is formatted in some SASish way
and does not look at all like a FBsomething dataset, more likely like a variable length one.

so, please explain again, in a better way what You want to do,
and no confusion in the file description please.

if You simply want to process the sysprint file, why post the misleading output file ???