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
 
text to numeric conversion using DFSORT

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

New User


Joined: 24 Mar 2004
Posts: 29

PostPosted: Mon Jun 28, 2004 9:05 am    Post subject: text to numeric conversion using DFSORT
Reply with quote

Hi all,

Can One of you help me to achieve the solution for the task given below.

Need to covert a character feed to Number

the feed can have value say +123456789.67 or -123456789.25 etc... should convert these text values into a zoned decimal value or Packed decimal value(6 bytes).

can this be achived through DFSORT! Its really urgent.....
Back to top
View user's profile Send private message

bluebird

Active User


Joined: 03 Feb 2004
Posts: 127

PostPosted: Mon Jun 28, 2004 4:01 pm    Post subject:
Reply with quote

muthukumar
To get signs you have to use EDIT mask

and read the sort manual on this fine site.
Back to top
View user's profile Send private message
muthukumar

New User


Joined: 24 Mar 2004
Posts: 29

PostPosted: Tue Jun 29, 2004 10:37 am    Post subject:
Reply with quote

Hi Blue,

thanks for your response.. but i couldnt locate Sort manual in this - can you please help me to locate that

regards
Muthu
Back to top
View user's profile Send private message
muthukumar

New User


Joined: 24 Mar 2004
Posts: 29

PostPosted: Tue Jun 29, 2004 4:59 pm    Post subject:
Reply with quote

k ..thx
Back to top
View user's profile Send private message
imvs

New User


Joined: 12 May 2004
Posts: 33

PostPosted: Tue Jun 29, 2004 11:53 pm    Post subject:
Reply with quote

muthukumar
check this site for publications on DFSORT

http://www.ibm.com/servers/storage/support/software/sort/mvs/srtmpub.html
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue May 03, 2005 1:49 am    Post subject:
Reply with quote

I started answering questions on this site after this question was posed. For the record, you can use DFSORT's SFF format in INREC, OUTREC or OUTFIL to convert this type of value (and many others) to various editted or numeric forms. For example:

Code:

  INREC FIELDS=(1,10,11:11,13,SFF,TO=PD,LENGTH=6,...)


For complete details on DFSORT's new SFF format, and all of the other new DFSORT and ICETOOL functions available with DFSORT's Dec, 2004 PTF, see:

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 File Aid tool to compare numeric data balaji81_k Compuware & Other Tools 2 Tue Sep 26, 2017 3:35 am
No new posts Remove leading spaces from numeric field rexx77 SYNCSORT 6 Wed Sep 06, 2017 2:15 am
No new posts Return a Non Numeric value from REXX Learncoholic CLIST & REXX 3 Fri Sep 01, 2017 8:33 pm
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 22 Sun Aug 27, 2017 10:35 pm
No new posts Sorting on text - but in non-alphabet... Roy Ware SYNCSORT 5 Wed Aug 23, 2017 9:15 pm

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