Posted: Mon Oct 03, 2005 11:59 am Post subject: sorting signed numeric fields
My sort card is as follows:
SORT FIELDS=(5,13,CH,A,36,14,CH,A)
Where the field at position 5, 13 is character type, but field at position 36, 14 is signed numeric. So, is the above sort card is proper, or I need to give something else instead of CH for numeric-type? However, with this sort card also I m getting the sorting done. _________________ Thanks,
Gayatri.
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Mon Oct 03, 2005 1:21 pm Post subject:
It depends on what you mean by "signed numeric". DFSORT has many different types of signed numeric formats (FI, PD, ZD, FS, SFF). Please show an example of exactly what the signed numeric values look like for positive and negative numbers. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
This discusses possible problems with using CH/BI on Signed numeric fields. As Frank Said, there are different types of signed numerics (Zoned Decimal - ZD, Packed Decimal - PD....). Show us how your input file look like. Paste couple of lines from your input file.
Also, use HEX ON and paste the Hex values along with the original record, so that we can see how the data is stored.
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
