I am facing another problem with csv input file..
My input file is CSV from one of the reports i do run to get
it's details are
DCB=(RECFM=VB,LRECL=4092,BLKSIZE=4096,DSORG=PS),
I am planing to write out put in FBA file..
DCB=(RECFM=FBA,LRECL=133,BLKSIZE=2660,DSORG=PS),
Input data :
"test id","test NAME","test NAME1","test NAME2","test ID",
"0","sri","srini","srinivas","7",
Out put should be like..
Test ID TESTNAME TEST NAME1 TEST NAME2 TEST ID
0 SRI SRINI SRINIVAS 7
error message i am facing as shown below..
ICE201I E RECORD TYPE IS V - DATA STARTS IN POSITION 5
ICE126A 9 INCONSISTENT SORTOUT IFTHEN 0 REFORMATTING FIELD FOUND
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
You can use a DFSORT job like the following to do what you want. However, your FIXLEN values and c: values are inconsistent with the fields you are trying to extract. For example, for %01 you have FIXLEN=3 and 5:%01,10: but since "Test ID" is 9 bytes long, that's too small for it. And if you're trying to remove the quotes, you need the correct PARSE operands to do that (e.g.
Frank,
Thanks for your info..
I tried using same card same you given as example..
got below error
Code:
OPTION TRUNC=RC0,COPY
OUTFIL VTOF,PARSE=(%00=(STARTAFT=C'"',ENDBEFR=C'"',FIXLEN=10),
%01=(STARTAFT=C'"',ENDBEFR=C'"',FIXLEN=10),
%02=(STARTAFT=C'"',ENDBEFR=C'"',FIXLEN=10),
%03=(FIXLEN=10)),
BUILD=(1,4,5:%00,20:%01,35:%02,50:%03)
ICE201I E RECORD TYPE IS V - DATA STARTS IN POSITION 5
ICE222A 0 59 BYTE FIXED RECORD LENGTH IS NOT EQUAL TO 133 BYTE LRECL FOR SORTOUT
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Sigh.
Quote:
I tried using same card same you given as example..
No, you didn't! If you look at my BUILD operand, you'll see it has 133:X at the end - that causes it to build the 133 byte record you said you wanted. Your BUILD operand does not have 133:X at the end so it builds a 59 byte record which conflicts with the LRECL=133 for SORTOUT. That's what the error message is telling you. You need 133:X.
PARSE is supported in SyncSort for z/OS 1.3.0.0 and later. I suspect you are running an earlier release of SyncSort on this system, causing the syntax error.