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

text to numeric conversion using DFSORT


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
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
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
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
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
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
Reply with quote

muthukumar
check this site for publications on DFSORT

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

DFSORT Developer


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

PostPosted: Tue May 03, 2005 1:49 am
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:

Use [URL] BBCode for External Links
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Copy only TEXT or String from a record SYNCSORT 4
No new posts GDG generation name to GDG Base name ... DFSORT/ICETOOL 3
No new posts Date format correction using dfsort DFSORT/ICETOOL 3
No new posts FB to .CSV conversion using sort DFSORT/ICETOOL 7
No new posts small int to zoned decimal conversion DFSORT/ICETOOL 3
Search our Forums:

Back to Top