Posted: Wed Sep 28, 2005 10:14 am Post subject: jcl,sorting numeric field?
hi,
1)i am having a ps with empid,sal,dob,doj,mobilenumber,and i have to sort the file based on the sal field,using sort (iceman).,
in sort fields=(startloc,len,?,a),what type i have to mention for sorting numeric field?,whether to use zd,pd,bi,fi.,and if we enter directly values into ps , in which format it is stored.and how to avoid overflow?
2)is there any intersting document which gives good explanation about this?
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Wed Sep 28, 2005 10:23 am Post subject:
Which numeric format you need to use depends on the numeric format the value is stored as. You can't just pick a random format - you have to know what the format is. If you don't know what format it is, we can probably tell you by looking at the data in hex. Use a DFSORT job like this to print out some of the values in hex:
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
Posted: Thu Sep 29, 2005 12:56 am Post subject:
vjkumk,
Quote:
and how to avoid overflow?
What kind of overflow are you talking about. There will no overflow unless you try to find out the total of any numeric field by using SUM FIELDS=(start,length,format).
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
