View previous topic :: View next topic
|
Author |
Message |
baljinders
New User
Joined: 21 Aug 2006 Posts: 72
|
|
|
|
Hi,
I have to extract data of a particular date from a varibale length file. What should be the sort card for this ?
Code: |
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(59,8,CH,EQ,C'20100610') |
The date filed is defined as s9(9) compe-3.
In file aid , when i browse the file, the position of the filed is given as
|
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
Something like INCLUDE COND=(59,5,PD,EQ,20100610) |
|
Back to top |
|
|
baljinders
New User
Joined: 21 Aug 2006 Posts: 72
|
|
|
|
Thanks CICS Guy,
does that mean i don't have to worry the 4 byte RDW while specifing the field postion in the sort card as this is a VBS file ? |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
baljinders wrote: |
Thanks CICS Guy,
does that mean i don't have to worry the 4 byte RDW while specifing the field postion in the sort card as this is a VBS file ? |
You DO need to consider the RDW and add 4 bytes to the actual position for Variable length files. |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
Good point, I'm not familiar with file aid and missed that.... |
|
Back to top |
|
|
baljinders
New User
Joined: 21 Aug 2006 Posts: 72
|
|
|
|
That means my sort card will become
Include cond=(63,5,PD,EQ.C'20100610')
instead of
Include cond=(59,5,PD,EQ,C'20100610')
as my field is S9(9) Comp-3.
Right ? |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
baljinders,
No, it should be
Code: |
Include cond=(63,5,PD,EQ,20100610)
|
|
|
Back to top |
|
|
baljinders
New User
Joined: 21 Aug 2006 Posts: 72
|
|
|
|
Thanks a ton CICS Guy and Skolusu for your replies. I'll let you guys know the outcome once the job gets done.
Thanks again... |
|
Back to top |
|
|
baljinders
New User
Joined: 21 Aug 2006 Posts: 72
|
|
|
|
Thanks Guys,
It worked and i got the desired resutls
Thanks again |
|
Back to top |
|
|
|