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
 

 

How to make left align alphnumeric number to right align num

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
sadashiv.a.bhosure

New User


Joined: 01 Feb 2007
Posts: 15
Location: india

PostPosted: Fri Feb 02, 2007 11:18 am    Post subject: How to make left align alphnumeric number to right align num
Reply with quote

Hi,
I am facing problem while sorting & matching sorted files.
for ex.
file1 : contain left align alphnumeric number
file1 : contain right align number

suppose file1,file2 contain
1
1
2
15 data, after sorting file1 file on above field o/p file contain sorted data as 1,1,15,2
and after sorting file2 on above field it gives 1,1,2,15 hence two output file does not matches.

Could anyone please help me how to handle this situaion......
Back to top
View user's profile Send private message

sadashiv.a.bhosure

New User


Joined: 01 Feb 2007
Posts: 15
Location: india

PostPosted: Fri Feb 02, 2007 11:52 am    Post subject: Re: How to make left align alphnumeric number to right align
Reply with quote

Code:

filed 1      field2 (left align alphanumeric number).

abcde        1
xyaaa        2
xyaaa        15
xyaaa        1


I want to sort above file on filed1 and field2 simaltaneously.
O/p should be

Code:

abcde        1
xyaaa        1
xyaaa        2
xyaaa        15


I want treat left align alphnumeric number as an integer.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Fri Feb 02, 2007 12:51 pm    Post subject:
Reply with quote

Hi there,

Try this DFSORT statement:

Code:

//SYSIN    DD  *
   SORT FIELDS=(1,5,CH,A,6,2,UFF,A)
/*
Back to top
View user's profile Send private message
sadashiv.a.bhosure

New User


Joined: 01 Feb 2007
Posts: 15
Location: india

PostPosted: Fri Feb 02, 2007 1:03 pm    Post subject:
Reply with quote

Thank you very much Ekta....
Back to top
View user's profile Send private message
sadashiv.a.bhosure

New User


Joined: 01 Feb 2007
Posts: 15
Location: india

PostPosted: Fri Feb 02, 2007 1:05 pm    Post subject:
Reply with quote

It's working fine Thanks a lot.
Back to top
View user's profile Send private message
sadashiv.a.bhosure

New User


Joined: 01 Feb 2007
Posts: 15
Location: india

PostPosted: Fri Feb 02, 2007 1:07 pm    Post subject:
Reply with quote

Hi Ekta, Can you tell me what is the meaning of 'UFF' ?
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Fri Feb 02, 2007 1:36 pm    Post subject:
Reply with quote

Hi There,

UFF means unsigned free form format

For more information on DFSORT's UFF and SFF formats, see:

http://www.ibm.com/servers/storage/support/software/sort/mvs/pdug/
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SMTP the current generation number of... Jyothi Kulunde JCL & VSAM 4 Thu May 04, 2017 4:08 pm
No new posts Edit large number of datasets (QSAM) zh_lad TSO/ISPF 3 Tue Apr 04, 2017 6:08 pm
No new posts how to mask the phone number kumarinfy DB2 4 Mon Apr 03, 2017 5:23 pm
No new posts what is meaning of the number in dcl Martylin PL/I & Assembler 2 Thu Mar 09, 2017 7:18 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am


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