Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts JOINKEYS Paired and Unpaired Sort on ... MFwhiz DFSORT/ICETOOL 7 Tue Nov 07, 2017 2:46 am
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us