View previous topic :: View next topic
|
Author |
Message |
umakanth.ravirala
New User
Joined: 04 Sep 2007 Posts: 15 Location: Halifax, United Kingdom
|
|
|
|
Hi
I want to sort out some records from a file, I have client id as key field.
Based on the following syntax, could you please give me the syntax for numeric fields?
(here I am mapping character fields )
SORT FIELDS=(16,8,PD,A)
OUTFIL FILES=02, INCLUDE= (10, 1, CH, EQ, C’N’) |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Ravi,
Quote: |
could you please give me the syntax for numeric fields? |
Quote: |
SORT FIELDS=(16,8,PD,A) |
Why do you think PD is not a numeric field? |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
Ravi,
Do you mean for the Include Statement?
If so, you can try coding the following:
Code: |
INCLUDE=(10,1,CH,EQ,C'1')
or
INCLUDE=(10,1,ZD,EQ,1) |
|
|
Back to top |
|
|
|