SathyaS
New User
Joined: 20 Sep 2005 Posts: 11
|
|
|
|
Hi,
I have a input file which has an amount field in the edited numeric format ' 00000005413.75'. I want to convert this into packed decimal. Is there someway to do it using SORT? I could find ways to convert PD to edited numeric and not the other way round. And my input format is not ZD.
Could someone help me out please?
Thanks,
Sathya |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
You can use use DFSORT's UFF or SFF formats to handle values like that and TO=PD to convert to packed decimal. For example, if your character value was in positions 1-15, you could use these DFSORT control statements:
Code: |
OPTION COPY
INREC BUILD=(1,15,UFF,TO=PD,LENGTH=8)
|
For more information on DFSORT's UFF and SFF formats, see:
Use [URL] BBCode for External Links |
|