View previous topic :: View next topic
|
Author |
Message |
Taylortek
New User
Joined: 22 Mar 2008 Posts: 4 Location: Seattle
|
|
|
|
I couldn't find this searching the site but it seems like it would be a common issue. I'm uploading and extract from a SQL database that contains both negative and positive integers. They come up with a fixed position of numbers followed by a - or a + (e.g. 000012545+ or 000012545-).
Is there a quick way to convert this to either ZD or PD format? I tried a few ways using the DFSORT conversion but the numbers keep coming out as positive. |
|
Back to top |
|
|
mdtendulkar
Active User
Joined: 29 Jul 2003 Posts: 237 Location: USA
|
|
|
|
Hi Taylortek,
Please try following
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,5,CST,PD)
It will convert Signed numeric with trailing separate sign into PD
Hope this helps
Regards
Mayuresh |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Quote: |
Please try following
... |
Mayuresh,
If you had followed your own advice and tried that, you would have found out that it doesn't work. That syntax is invalid. In the future, please try out your "solutions" with DFSORT before posting them. If you can't do that, then please don't post in this Forum.
Taylortek,
You can use a DFSORT job like this to do what you asked for. I assumed your numeric field was in positions 1-10. The output will be a 6-byte PD field in positions 1-6. Adjust as needed.
Code: |
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file
//SORTOUT DD DSN=... output file (FB/6)
//SYSIN DD *
OPTION COPY
SORT FIELDS=COPY
INREC BUILD=(1:1,10,SFF,TO=PD)
/*
|
|
|
Back to top |
|
|
Taylortek
New User
Joined: 22 Mar 2008 Posts: 4 Location: Seattle
|
|
|
|
Worked like a champ. Thanks again |
|
Back to top |
|
|
|