View previous topic :: View next topic
|
Author |
Message |
raghuraman Currently Banned New User
Joined: 07 Aug 2008 Posts: 6 Location: chennai
|
|
|
|
how to declare include cond statement for VB recformat?
Code: |
SORT FIELDS=COPY
INCLUDE COND=(17,07,CH,EQ,C'H190072')
OUTREC FIELDS=(17,30)
|
its working for fb..can you give the equivalent declaration for VB. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
For a VB file the field position is incremented by 4 to allow for the RDW. |
|
Back to top |
|
|
raghuraman Currently Banned New User
Joined: 07 Aug 2008 Posts: 6 Location: chennai
|
|
|
|
thanx expat...as per your suggesion i incremented by 4 now i am getting
this below error.
ICE201I 0 RECORD TYPE IS V - DATA STARTS IN POSITION 5 |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
That is not an error message, the last charachter of the message id is I - Information.
If you think that there is an error, please post the whole SYSOUT DD output.
Topic moved to DFSORT/ICETOOL where it belongs. |
|
Back to top |
|
|
raghuraman Currently Banned New User
Joined: 07 Aug 2008 Posts: 6 Location: chennai
|
|
|
|
i am getting return code 16.
SYSOUT DD output:
Code: |
BLOCKSET COPY TECHNIQUE SELECTED
VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AND MORE
- CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 12:28 ON WED OCT 15, 200
SORT FIELDS=COPY
INCLUDE COND=(6,07,CH,EQ,C'NONVSAM')
OUTREC FIELDS=(23,30)
RECORD TYPE IS V - DATA STARTS IN POSITION 5
INCONSISTENT *OUTREC IFTHEN 0 REFORMATTING FIELD FOUND
C5-K05352 C6-Q95214 C7-K90000 C8-K05352 E9-K06751 E7-K90000
END OF DFSORT
|
|
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Try
Code: |
OUTREC BUILD=(1,4,23,30)
|
because the input and output are VB you need to specify the RDW in the output. If you convert the output to FB then you do not need to do this. |
|
Back to top |
|
|
raghuraman Currently Banned New User
Joined: 07 Aug 2008 Posts: 6 Location: chennai
|
|
|
|
Its working..thanx a lot. |
|
Back to top |
|
|
|