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
 

 

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 Validate date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
No new posts DFSORT - Overriding default option TU... Steve Ironmonger DFSORT/ICETOOL 3 Tue Apr 04, 2017 3:54 pm
No new posts DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm
No new posts Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 pm


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