|
|
View previous topic :: :: View next topic
|
| Author |
Message |
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! |
|
| Back to top |
|
 |
|
|
UmeySan
Active Member
Joined: 22 Aug 2006
Posts: 755
Location: Germany
|
|
|
|
Hi !
I think you have to use the RECORD statement, because you have a VSAM
dataset to be sorted.
Regards, UmeySan |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005
Posts: 7130
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:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/1.8.3.4?SHELF=&DT=20060615185603&CASE= |
|
| Back to top |
|
|
cheetz007
New User
Joined: 10 Aug 2006
Posts: 23
|
|
|
|
Once again Frank - you are the man! Like I said, I knew it was something stupidly obvious!
Thanks for your help, and especially thanks for the link - I have been searching around the online manuals on and off for days trying to find this info!! |
|
| Back to top |
|
|
|
|
