Posted: Wed May 16, 2007 4:26 pm Post subject: variable length to Fxed length
Hi,
I am trying to convert a variable length file to a fixed file format using SYNCSORT(I have to use this only and thats my restriction). Here is the sort card which does that but with some problems
Problems:
WER250A SORTOUT INCLUDE/OMIT FIELD BEYOND RECORD
The problem is obviously because of some recoerd which has length smaller than 142 or may be smaller than 29.
I would like to have a single sort step which does the filtering using INCLUDE statement above and which would convert the vb file to a fb file. I think if we can find out a way in which the record is converted to a fixed length record of 286 padded with spaces by using INREC, the INCLUDE statement wouldnt face this problem. Pls let me know if there is a way to do this.
There is a parameter that lets you decide that if the include condition is beyond the current lrecl, to make it true or false or ignore it...
Do you have a manual?
If your site (email address) is licensed for Syncsort, email their support at:
SyncSort Mainframe Support
201.930.8260
zos_tech@syncsort.com
and ask for the manual.
At this point, I am half asleep, in the morn, I'll look up the parameter and post it...If somebody does not first...
Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
Posted: Wed May 16, 2007 6:18 pm Post subject:
chandrasekhar.a,
You are getting WER250A error because your input file is a variable block file and it may some shor records , so the validation of the include/omit condition fails.
Add this parm to your job
Code:
//STEP0100 EXEC PGM=SORT,PARM='VLTESTI=1'
VLTESTI specifies to SyncSort how to process variable-length records that do not contain all specified INCLUDE or OMIT fields. VLTESTI applies to both regular and OUTFIL INCLUDE/OMIT processing.
The delivered default of 0 instructs SyncSort to terminate if a record does not completely contain all INCLUDE or OMIT fields. A WER250A critical error message is generated to indicate this condition.
When VLTESTI=1 is specified, a record that does not completely contain all INCLUDE/ OMIT fields is treated as having failed the comparison. SyncSort will omit the record if INCLUDE is being used or include the record if OMIT has been specified.
When VLTESTI=2 is specified, SyncSort will treat comparisons to fields not completely contained within the record as false and decide a record's status for inclusion or omission from fields that are available. If all fields are not present, the record will be processed as having failed the comparison. SyncSort will omit the record if INCLUDE is being used or include the record if OMIT has been specified.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
