Convert PD to unsigned integer



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

Convert PD to unsigned integer

Postby fornanthakumar » Sat Jan 14, 2012 2:55 am

Hi,

Using DFSORT,

MY input data is

00000000
0000600D

I want my output should be 0000000000600000

So I tried,

(1,8,PD,TO=ZD,LENGTH=16)

But i am getting 000000000060000} .. i tried using other formats like FS,LS,TS,CLO,CST..

Please someone help me out on this issue.
Regards,
Nanthu.Y.
fornanthakumar
 
Posts: 69
Joined: Fri Oct 22, 2010 1:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Convert PD to unsigned integer

Postby Frank Yaeger » Sat Jan 14, 2012 5:30 am

Your PD value has a D sign so it is a negative number (-60000) and is correctly represented in ZD as X'F0...F6F0F00F0F0D0' which looks like '0...60000}'.

If you really want the absolute value, you can use:

(1,8,PD,M11,LENGTH=16)

That would display '0...60000' for your negative PD value but the sign will be lost.

If you really want -0...60000' or something else, tell me exactly what you want using various examples of input and output.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post