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

DFSORT returns SOC7 in sum


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
JAYANT KUMAR SAHOO

New User


Joined: 15 Mar 2006
Posts: 14

PostPosted: Fri Apr 14, 2006 4:32 am
Reply with quote

Hi Techies
I need ur help asap.
I have a file with million records with a numeric field starting from 35 and length 10.
The field can hold data like
7.75
233792.4
4676
etc etc

That means fixed number along with number with decimal places can appear.The max decimal place can appear is 2.

If I am using a sort card like

TRAILER1=(1:TOT=(35,10,ZD,EDIT=(SIIIIIIIIII.II),SIGNS=(,-)))
I am getting a SOC7 abend as the decimal bit(ie . dot) is treated as a char(its my belief).

When I am discarding the decimal bit or just replacing with it a 0 the sort is working fine.

How can I get the sum with sort.
Please reply soon asap.

Tahnking u in advance.
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: Fri Apr 14, 2006 4:49 am
Reply with quote

For those types of values, you need to use DFSORT's UFF format rather than DFSORT's ZD format. See the following for more information on DFSORT's UFF format:

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 Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts DFsort help with SUM() DFSORT/ICETOOL 12
No new posts DFSORT - VB file RDW getting overridden DFSORT/ICETOOL 3
Search our Forums:

Back to Top