Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
Posted: Mon Jul 23, 2007 6:39 am Post subject:
Quote:
TERMINATED WITH ABENDU0126
ICE126A 9 INCONSISTENT SORTOUT IFTHEN 1 REFORMATTING FIELD FOUND
raveendra_ibm,
You are only checking for a single value in the IFTHEN condition.Your include condition picks all the records which have a '5' or '9' at pos 12. You only coded an IFTHEN statement for '5' , what about '9'? . That is exactly why the SORT failed here.
You either need to code another IFTHEN statement for '9' or Use another include/omit condition to strip them off. Also your Input is VB you need to consider the RDW when sorting and if you want an FB file you need to use FTOV or convert feature
The first field was not 1,n where n is equal to or greater than 4, for variable-length input records, that is, the first field did not contain the record descriptor word (RDW).
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
Posted: Mon Jul 23, 2007 9:11 am Post subject:
raveendra_ibm,
The OUTFIL BUILD is processed before OUTFIL VTOF. For variable-length records, the first entry in the OUTREC, BUILD or IFTHEN BUILD parameter must specify or include the unedited 4-byte record descriptor word (RDW), that is, the first field must be 1,4 or 1,m with m greater than 4. DFSORT sets the length of the reformatted record in the RDW.
So I used the OUTREC to process the RDW and on OUTFIL I removed the RDW
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Mon Jul 23, 2007 10:47 am Post subject:
Quote:
For variable-length records, the first entry in the OUTREC, BUILD or IFTHEN BUILD parameter must specify or include the unedited 4-byte record descriptor word (RDW), that is, the first field must be 1,4 or 1,m with m greater than 4. DFSORT sets the length of the reformatted record in the RDW.
Actually, that's NOT true when VTOF is used. With VTOF, you specify the fixed length fields to be used for output. You would not specify the RDW unless you want it included in the FB output records. The fact that OUTFIL VTOF,BUILD=(5,80) works shows that the RDW is not needed with VTOF.
Here's an analysis of what really went on here:
raveendra's first job - trying to convert from VB to FB, but missing VTOF. Without VTOF, the RDW must be specified in the BUILD operand. It wasn't, so the error message was issued.
raveendra's second job - VTOF specified. IFTHEN is NOT allowed with VTOF. That's the reason for the error message. It has nothing to do with not having the RDW in the BUILD operand.
Kolusu's job - works because it avoids using IFTHEN with VTOF. Has the RDW in the OUTREC BUILD as required. Has OUTFIL VTOF and BUILD without the RDW which is fine. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
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