cheetz007
New User
Joined: 10 Aug 2006 Posts: 23
|
|
|
|
I am trying to extract some fields from a VSAM input file and produce a CSV output file. I have the following:
Code: |
//SORTIN DD DISP=SHR,DSN=NVM.V.BATCH.BCC <-- VSAM FILE
//SORTOUT DD DISP=SHR,DSN=XQDV.SPF.SORTOUT <-- SEQUENTIAL FILE
//SYSIN DD *
SORT FIELDS=COPY
INREC FIELDS=(1,4,C',',5,2,C',',7,3,C',',10,3,C',',13,6,C',',92,6)
INCLUDE COND=(1,4,EQ,C'BC02')
/*
|
All the fields are alphanumeric.
When I run the above I get the following:
Code: |
ICE805I 1 JOBNAME: XQDV0001 , STEPNAME: JS10
ICE802I 0 BLOCKSET TECHNIQUE IN CONTROL
ICE201I 0 RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE018A 3 INVALID OR MISSING FORMAT
ICE143I 0 BLOCKSET COPY TECHNIQUE SELECTED
ICE000I 1 - CONTROL STATEMENTS FOR 5740-SM1, DFSORT REL 14.0 - 10:01 ON FRI SEP 15, 2006 -
SORT FIELDS=COPY
INREC FIELDS=(1,4,C',',5,2,C',',7,3,C',',10,3,C',',13,6,C',',92,6)
INCLUDE COND=(1,4,EQ,C'BC02')
ICE201I 0 RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE018A 3 INVALID OR MISSING FORMAT
ICE052I 3 END OF DFSORT
ICE185A 0 DFSORT TERMINATED WITH S322 ABEND DURING PHASE C 0
|
I'm sure it's something blindingly obvious, but wood and trees??
Help!
Thanks! |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
cheetz007,
As the ICE018A says, you're missing the format in the INCLUDE statement. It should be:
Code: |
INCLUDE COND=(1,4,CH,EQ,C'BC02')
|
Quote: |
I think you have to use the RECORD statement, because you have a VSAM dataset to be sorted. |
ICE201I 0 RECORD TYPE IS F - DATA STARTS IN POSITION 1
indicates that DFSORT defaulted the VSAM record type to F. If the VSAM records are not all the same length, then you would need to specify:
and adjust the starting positions in the control statements accordingly.
For more information on using VSAM data sets with DFSORT, see:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/1.8.3.4?SHELF=&DT=20060615185603&CASE= |
|