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

How to convert character field to numeric field in sorting


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
balaji_be09
Warnings : 1

New User


Joined: 27 Sep 2005
Posts: 7
Location: pune

PostPosted: Tue Jul 10, 2007 10:52 pm
Reply with quote

Hi,

There is a field in record which is defined as +9(3).9(02). Now through sorting I have to use SUM fileds for same data. I am using sorting as follows
SORT FIELDS=(336,6,CH,A,597,4,CH,A,216,2,CH,A)
SUM FIELDS=(589,7,ZD,602,6,ZD)
Butv getting S0C7 error because of movement of character data type to numneric data type.
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 Jul 10, 2007 11:31 pm
Reply with quote

You can't use ZD to sum a number with a decimal point. You can use the technique discussed in the "Sum a number with a decimal point" Smart DFSORT Trick at:

www.ibm.com/servers/storage/support/software/sort/mvs/tricks/
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 Issues Converting From ZD to Signed N... DFSORT/ICETOOL 4
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Need to convert date format DFSORT/ICETOOL 20
This topic is locked: you cannot edit posts or make replies. Automation need help in sorting the data DFSORT/ICETOOL 38
No new posts Keep leading zero(s) after convert fl... SYNCSORT 7
Search our Forums:

Back to Top