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

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

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

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

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

/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

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

enrico-sorichetti · Posted: Tue Feb 09, 2010 12:17 pm

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 ???

expat · Posted: Tue Feb 09, 2010 12:23 pm

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

My input file is a SAS log file from a production system. I need to validate the messages and errors in it using a job since i get 22 such files a day.
When i tried checking for the errors and messages using the positions that i found in the log file - they dint match. Thats why i thought it would be better to convert the log file to a FB file.
Please suggest if there is any appropriate way to validate the errors and messages present in the log file

enrico-sorichetti · Posted: Tue Feb 09, 2010 1:46 pm

please reread my previous post !

gcicchet · Posted: Tue Feb 09, 2010 1:52 pm

Hi,

the data is from DDNAME SASLOG and is a VB file with an LRECL of 137.

How is the dataset created ? ie. What does the JCL for //SASLOG DD look like ?

Gerry

William Thompson · Posted: Tue Feb 09, 2010 2:03 pm

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

Hi William,
I had already tried that but that din't work.

Gerry:
I wasn't able to understand your question.
The SASLOG file is from a third party production system.

William Thompson · Posted: Tue Feb 09, 2010 2:14 pm

enrico-sorichetti · Posted: Tue Feb 09, 2010 2:16 pm

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

!) The input file is a SAS log file with length 255 and RECFM is FBA. I had already given some content from the input file. Its not a content from SYSprint or SYSout. Its a log file sent by a production system and hence looks similar to SYSPRINT.

2) Ouput is an Error file with RECFM as FB, containing only critical errors from the SAS log file

3) The process as mentioned earlier is to validate the errors and messages present in the SAS log file and send required notifications.

Eg: Input file

enrico-sorichetti · Posted: Tue Feb 09, 2010 2:41 pm

are You sure about the FB ??? looks more like a VB thing to me

ISPF edit/view/browse hides quite a few details!