Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need Help on SORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
umakanth.ravirala

New User


Joined: 04 Sep 2007
Posts: 15
Location: Halifax, United Kingdom

PostPosted: Mon Feb 18, 2008 3:17 pm    Post subject: Need Help on SORT
Reply with quote

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
View user's profile Send private message

murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Mon Feb 18, 2008 4:01 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Tue Feb 26, 2008 10:41 pm    Post subject: Reply to: Need Help on SORT
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us