Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Conversion from FBA to FB
Goto page Previous  1, 2, 3  Next
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Prasanya

New User


Joined: 04 Jun 2007
Posts: 34
Location: Chennai

PostPosted: Tue Feb 09, 2010 2:12 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Tue Feb 09, 2010 2:14 pm    Post subject:
Reply with quote

Prasanya wrote:
I had already tried that but that din't work.
Please explain "did not work"......
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10701
Location: italy

PostPosted: Tue Feb 09, 2010 2:16 pm    Post subject: Reply to: Conversion from FBA to FB
Reply with quote

Quote:
but that din't work.
(*)
that' awful, we hope You can fix it soon.

do You realize that You did not post yet anything useful to get an answer..

please reply/post to the following...
1) input file layout and content
2) output file layout and content
3) description of the process

what is the relation of the input and output files in Your second post ?
Back to top
View user's profile Send private message
Prasanya

New User


Joined: 04 Jun 2007
Posts: 34
Location: Chennai

PostPosted: Tue Feb 09, 2010 2:37 pm    Post subject:
Reply with quote

!) 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

Code:

NOTE: This session is executing on the z/OS   V01R10M00 platform.     
                                                                       
NOTE: Running on IBM Model 2097 Serial Number 014A32,                 
                 IBM Model 2097 Serial Number 014A32,                 
+ERROR: Teradata execute: Object 'AAAAAAAAAAAAAAAAAAA',             
+ERROR: Teradata execute: Object 'BBBBBBBBBBBBBBBBBBB'           
 


This error field is shown in position 2 but when i search for 'ERROR:' string from position 2 its not found.
So wen i tried writing the entire input log file to an output FB file these records were displayed as follows:


Code:

¡NOTE: This session is executing on the  z/OS kV01R10M00 platform.̯ÌÚ ©NOTE: Running on IBM Model 2097 Serial Number 014A32,ÌH tIBM Model 2097 Serial Number 014A32,}ERROR: Teradata execute: Object 'AAAAAAAAAAAAAAAAAAA' ,}ERROR: Teradata execute: Object 'BBBBBBBBBBBBBBBBBBB'
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10701
Location: italy

PostPosted: Tue Feb 09, 2010 2:41 pm    Post subject: Reply to: Conversion from FBA to FB
Reply with quote

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

ISPF edit/view/browse hides quite a few details!
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Tue Feb 09, 2010 2:44 pm    Post subject:
Reply with quote

Quote:
So wen i tried writing the entire input log file to an output FB file these records were displayed as follows
Just what did you use to write "the entire input log file to an output FB file"?
Back to top
View user's profile Send private message
Prasanya

New User


Joined: 04 Jun 2007
Posts: 34
Location: Chennai

PostPosted: Tue Feb 09, 2010 2:45 pm    Post subject:
Reply with quote

Ya am sure about that
Back to top
View user's profile Send private message
Prasanya

New User


Joined: 04 Jun 2007
Posts: 34
Location: Chennai

PostPosted: Tue Feb 09, 2010 2:47 pm    Post subject:
Reply with quote

I tried to copy the input log file to the output FB file using IEBGENER as well as SORT. I have given the job details earlier for this post.
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10701
Location: italy

PostPosted: Tue Feb 09, 2010 2:49 pm    Post subject: Reply to: Conversion from FBA to FB
Reply with quote

Quote:
Ya am sure about that
ridiculous remark

the crippled output is the result of processing a VB dataset as a FB dataset...
do You realize it or not ?
all the data is junked up!

browse the output dataset with hex on and You will see that before the readable data there will be four bytes containing the length of the data itself up to the next 4
Back to top
View user's profile Send private message
Prasanya

New User


Joined: 04 Jun 2007
Posts: 34
Location: Chennai

PostPosted: Tue Feb 09, 2010 2:59 pm    Post subject:
Reply with quote

I have checked the file as u said, the 1st four bytes contain the log data and not the length.
I have checked it properly and thats why i said am sure that its not a VB file
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10701
Location: italy

PostPosted: Tue Feb 09, 2010 3:02 pm    Post subject: Reply to: Conversion from FBA to FB
Reply with quote

if You are sure then everything should work
and You have no reason at all to complain
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Tue Feb 09, 2010 3:11 pm    Post subject:
Reply with quote

How about posting the HEX ON display of a display of
Code:
NOTE: This session is executing on the z/OS   V01R10M00 platform.
?
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10701
Location: italy

PostPosted: Tue Feb 09, 2010 3:17 pm    Post subject: Reply to: Conversion from FBA to FB
Reply with quote

it would be more interesting an hex display of the output !

in the fist post there is a clear indication of many unprintable chars spread
around
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Tue Feb 09, 2010 3:23 pm    Post subject:
Reply with quote

Quote:
This error field is shown in position 2 but when i search for 'ERROR:' string from position 2 its not found.
Prasanya,

Did you try searching "ERROR:" at pos-3 given that you have an FBA input ?
omg, this thread has gone too far w/o making any progress. icon_eek.gif
Back to top
View user's profile Send private message
VVRAVINDRA

New User


Joined: 04 Aug 2008
Posts: 46
Location: Chennai

PostPosted: Tue Feb 09, 2010 9:16 pm    Post subject:
Reply with quote

I'm sure my answer would look absurd compared to the master choices that you all have mentioned but I just wanted to try my luck out....

Please ignore/delete this post if it doesn't meet the standards....

Firstly, I copied the 4 lines of data from the input file provided by the Prasanya to a FBA 80 byte file (for testing)

Here are the contents of the i/p file:

Code:
***************************** Top of Data ******************************
----+----1----+----2----+----3----+----4----+----5----+----6----+----7--
1                                                          THE SAS     
SYSTEM                            01:00 TUESDAY, FEBRUARY 2, 2010       
                                                                       
NOTE: COPYRIGHT (C) 2002-2003 BY SAS INSTITUTE INC., CARY, NC, USA.     
NOTE: SAS (R) 9.1 (TS1M3)                                               


And then I had a O/P file with length 79 and DCB=FB.

I tried the SORT option and here goes my sort card
Code:
SORT FIELDS=COPY       
OUTFIL OUTREC=(1:1,79) 


Then i executed the job, and the output file looked the same as the input file...I did a SUPERC and found that the records were matching..

Once again my sincere apoligies if my answer is looking hasty or imappropriate.


Thanks,
Ravi
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10701
Location: italy

PostPosted: Tue Feb 09, 2010 9:39 pm    Post subject: Reply to: Conversion from FBA to FB
Reply with quote

Ravi!
Your test is ok!

it might be biased that You did run it from data cut and pasted from the topic
and of a good/certain/sure origin

what we are still puzzling about is the goodness of the data in the TS environment
or at least of the understanding by the TS of its organization

the thing we are debating also is the ****ing icon_biggrin.gif <output> dataset with all the data junked up!
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Tue Feb 09, 2010 10:30 pm    Post subject:
Reply with quote

I wonder if the original file was FBA or VBA?
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Member


Joined: 14 Mar 2007
Posts: 10701
Location: italy

PostPosted: Tue Feb 09, 2010 10:34 pm    Post subject: Reply to: Conversion from FBA to FB
Reply with quote

Quote:
I wonder if the original file was FBA or VBA?


how could You icon_biggrin.gif
I had told the TS to check, especially after having seen the <output> dataset
but the TS said he was sure and confirmed
Back to top
View user's profile Send private message
Prasanya

New User


Joined: 04 Jun 2007
Posts: 34
Location: Chennai

PostPosted: Wed Feb 10, 2010 1:57 pm    Post subject:
Reply with quote

I have already mentioned its a FBA file and am sure about this. I do have a proper understanding if the system that am working in. Please keep in mind that its a log file created by SAS.

Do you need some kind of proof to be sure that its an FBA file?

Hi Arun,
I have already tried using position 3 but i dint get a match for 'ERROR:'
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales

PostPosted: Wed Feb 10, 2010 2:02 pm    Post subject:
Reply with quote

Does SYNCSORT have SS capabilities
INCLUDE COND=(1,99,SS,EQ,C'ERROR')
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Goto page Previous  1, 2, 3  Next
Page 2 of 3

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts EBCDIC to ASCII conversion help t_bt2 All Other Mainframe Topics 1 Wed Sep 23, 2020 6:34 pm
No new posts Bad arithmetic conversion when assign... Ajay Baghel CLIST & REXX 4 Tue Nov 26, 2019 11:29 am
No new posts String to ASCII conversion JPLMARTINS COBOL Programming 4 Sun Sep 29, 2019 12:00 am
No new posts Pack to Unpack conversion for sending... A_programmers COBOL Programming 13 Wed Sep 11, 2019 10:46 pm
No new posts Alphanumeric to Packed Decimal Conver... Vijay_Sirisha COBOL Programming 2 Mon May 27, 2019 2:52 am

Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us