Convert PD to ZD using SYNCSORT

vidyakonda · New User Joined: 25 Jan 2006 Posts: 8

Hi,

I have the following problem while trying to sort the file.

Input file in hex format(2 records):
...æ
0109
0C9C
---
...æ
0109
0C9C

I had used syncsort
SORT FIELDS=COPY
INREC FIELDS=(1:1,2,PD,ZD)

Output is:
00A
00A

My question is why the output is 00A instead of 001. Ofcourse HEX on show 001 but when I view I should be able to see as 001.

Hope its clear.

Please suggest.

Thanks,
Vidya

gabriel.ryoga · New User Joined: 07 Jun 2007 Posts: 31 Location: Spain

It's because you are converting PD to ZD, with a C for displaying the sign.

Example:

00A is 0000C1 in HEX.

If you want to display 001, try converting to ZDF:

SORT FIELDS=COPY
INREC FIELDS=(1:1,2,PD,ZDF)

that will make:

001 = 0000F1 in HEX.

vidyakonda · New User Joined: 25 Jan 2006 Posts: 8

Wow..thanks.its worked fine.