IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need Help on SORT


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
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
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: 1436
Location: Bangalore,India

PostPosted: Mon Feb 18, 2008 4:01 pm
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: 496
Location: USA

PostPosted: Tue Feb 26, 2008 10:41 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
Search our Forums:

Back to Top