View previous topic :: View next topic |
Author |
Message |
systemz Beginner
Joined: 19 Nov 2004 Posts: 10 Topics: 5
|
Posted: Fri Nov 19, 2004 9:58 am Post subject: syncsort - Include Cond issue |
|
|
Hi all,
I am running syncsort in order to select records that have a certain date in column 80 (in a variable length record)
below is my INCLUDE card statement:
INCLUDE COND=(84,09,CH,EQ,X'020041115C')
the picture of this field is : PIC S9(09) COMP-3.
my job ends with CC=0 but my output file contains zero records.
The input file has the data that i need.
Can some one help me with this?
thanks
sys. |
|
Back to top |
|
 |
systemz Beginner
Joined: 19 Nov 2004 Posts: 10 Topics: 5
|
|
Back to top |
|
 |
Phantom Data Mgmt Moderator

Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Fri Nov 19, 2004 10:35 am Post subject: |
|
|
systemz,
U need to change ur sort card as shown below. Pic S9(09) COMP-3 takes only 5 bytes so u should specify 84,5 and not 84,9.
Try this
Code: |
INCLUDE COND=(84,5,PD,EQ,20041115)
|
Thanks,
Phantom |
|
Back to top |
|
 |
systemz Beginner
Joined: 19 Nov 2004 Posts: 10 Topics: 5
|
Posted: Fri Nov 19, 2004 10:37 am Post subject: |
|
|
thanks a lot phantom!!!
systemz |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
|
Back to top |
|
 |
systemz Beginner
Joined: 19 Nov 2004 Posts: 10 Topics: 5
|
Posted: Fri Nov 19, 2004 10:53 am Post subject: |
|
|
thanks
this is a nice little chart
very helpful!!
systemz
 |
|
Back to top |
|
 |
Frank Yaeger Sort Forum Moderator

Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
|
Posted: Fri Nov 19, 2004 11:16 am Post subject: |
|
|
Quote: | I hope Frank wouldn't mind the link for a syncsort question. |
Well, I'll have to charge a nickel everytime a non-DFSORT customer accesses the table (just kidding, of course.) _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
Back to top |
|
 |
|
|