## Convert two PD fields to Numeric using Sort

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

### Convert two PD fields to Numeric using Sort

Hi there,

I have two packed decimal fields in a file of record length 80
Field1 1-4 (S9(7) COMP-3)
Field2 5-9 (S9(9) COMP-3)

I tried to do with the below, but the results are not as expected.
INREC BUILD=(1,9,PD,TO=ZD,LENGTH=16

Could you please advise how do I convert the data to numeric using SORT?
Kitz

Posts: 47
Joined: Thu Mar 17, 2011 3:46 am
Has thanked: 0 time
Been thanked: 1 time

### Re: Convert two PD fields to Numeric using Sort

Treat them as separate fields. Your INREC is attempting to use the first field's sign bits as data, which will give erroneous results at best.
Robert Sample
Global moderator

Posts: 3543
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 253 times

### Re: Convert two PD fields to Numeric using Sort

As Robert says, something like this;

INREC BUILD=(1,4,PD,TO=ZD,LENGTH=7,5,5,TO=ZD,LENGTH=9)
BillyBoyo
Global moderator

Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

### Re: Convert two PD fields to Numeric using Sort

Thanks a lot Billy Boya. I am able to convert the file to numeric now.

For some reasons, these fields are coming with a prefix '0' to each field.
1.Could you please advise how to I get rid of '0' to these fields?
2. Also, pls let me know how to I get a space in between these two fields in the output file.

Current file:
0111111011111111
0222222022222222
0121212014345678

Expected output:
111111 11111111
222222 22222222
121212 14345678
Kitz

Posts: 47
Joined: Thu Mar 17, 2011 3:46 am
Has thanked: 0 time
Been thanked: 1 time

### Re: Convert two PD fields to Numeric using Sort

Change both the LENGTH=s. Use X between the fields to insert one blank (2X to insert two blanks).
BillyBoyo
Global moderator

Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

### Re: Convert two PD fields to Numeric using Sort

Kitz,
In the future, please use code tags to indicate spacing:
Current file:
0111111011111111
0222222022222222
0121212014345678

Expected output:
111111 11111111
222222 22222222
121212 14345678
.... Terry
Terry Heinze

Posts: 212
Joined: Wed Dec 04, 2013 11:08 pm
Location: Richfield, MN, USA
Has thanked: 11 times
Been thanked: 11 times