View previous topic :: View next topic
|
Author |
Message |
varalakshmi.G
New User
Joined: 04 Jun 2007 Posts: 55 Location: Hyderabad
|
|
|
|
Hi,
Could u tell me that,if I want to retrieve only particular fields from a VB file and To sort that file What is the syntax of INREC fields.
Thanks in advance,
Varalakshmi.G |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
Have you looked at a sort manual? |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi Varalakshmi,
Would u please provide us the sample i/p & o/p so that we can provide u sort card. |
|
Back to top |
|
|
Aaru
Senior Member
Joined: 03 Jul 2007 Posts: 1287 Location: Chennai, India
|
|
|
|
As requested please provide us more details on your requirement.
One thing that has to be kept in mind while writing SORT card for VB datasets is to include the 4 bytes for RDW.
Please do a search on this forum as we have discussed this before. |
|
Back to top |
|
|
varalakshmi.G
New User
Joined: 04 Jun 2007 Posts: 55 Location: Hyderabad
|
|
|
|
Hi,
I have an input file of VB format and i want only some particular fields of this i/p file and i want to do sorting on this file.I have added 4bytes to the length of the field while declaring the control card and i declared as
INREC FIELDS=(39,18)
SORT FIELDS=(39,18,CH,A) but it is giving U016 error.
Could u tell me abt this error.
Thanks.
Varalakshmi |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
varalakshmi.G wrote: |
I have an input file of VB format and i want only some particular fields of this i/p file and i want to do sorting on this file.I have added 4bytes to the length of the field while declaring the control card and i declared as
INREC FIELDS=(39,18)
SORT FIELDS=(39,18,CH,A) but it is giving U016 error.
Could u tell me abt this error. |
Wouldn't the inrec need the 1,4 for the llbb also?
What is the message number and text for the error? |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Varalakshmi.G,
Assuming that you've accounted for the RDW in the starting positions, the correct DFSORT statements would be:
Code: |
INREC BUILD=(1,4,5:39,18)
SORT FIELDS=(5,18,CH,A)
|
You must specify the RDW (1,4) in the INREC statement, and you must use the positions from the reformatted record for the SORT statement. |
|
Back to top |
|
|
|