View previous topic :: View next topic |
Author |
Message |
vini Intermediate
Joined: 12 Jan 2004 Posts: 240 Topics: 48 Location: Maryland
|
Posted: Sat Mar 26, 2022 10:55 pm Post subject: Convert Amount having decimal point to PD using Syncsort |
|
|
Hello Sort Gurus,
Please let me know if there is a way to convert a field which is of type 9(8).9(2) into Packed Decimal (Comp-3) using Syncsort ?
Field starts at position 85 in the FB file.
Ex:
00000263.02
The source of the data in file was Bigdata/impala where all amount fields are stored with explicit decimal point.
Regards,
Vini |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Sun Mar 27, 2022 9:46 am Post subject: |
|
|
vini,
Untested control cards
Code: |
//SYSIN DD *
OPTION COPY
OUTREC OVERLAY=(Opos:Ipos,11,SFF,PD,LENGTH=6)
/*
** Ipos = Input display numeric field position
** Opos = Output PD field position.
|
_________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
vini Intermediate
Joined: 12 Jan 2004 Posts: 240 Topics: 48 Location: Maryland
|
Posted: Mon Mar 28, 2022 10:08 pm Post subject: |
|
|
Thank you so much Kolusu !!!
The provided solution worked like a charm |
|
Back to top |
|
|
|
|