Packed Decimal Subtraction

Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL
Post Reply Previous topicNext topic
krbnsol
Posts: 2
Joined: Mon Aug 01, 2022 5:36 pm
Skillset: DB2 DBA, COBOL, JCL, Postgres, DVM,
Referer: friend

Packed Decimal Subtraction

Postby krbnsol » Mon Aug 01, 2022 5:56 pm

I have two field on my input record that are in packed decimal format(2 decimal positions) one is 9(5)v99 and the other is 9(3)v99, my output record i would like to get the value of FLD2 subtracted from FLD1 in packed decimal format 9(5)v99, is this possible with syncsort. Any examples would be apprcieated.

thanks
Top
krbnsol
Posts: 2
Joined: Mon Aug 01, 2022 5:36 pm
Skillset: DB2 DBA, COBOL, JCL, Postgres, DVM,
Referer: friend

Re: Packed Decimal Subtraction

Postby krbnsol » Mon Aug 01, 2022 10:14 pm

Found the solution after playing around with the various options. Hope I didn't waste anyone's time on this one.

thanks
Top
User avatar
sergeyken
Posts: 458
Joined: Wed Jul 24, 2019 10:12 pm
Skillset: Assembler, JCL, Utilities, PL/I, C/C++, DB2, SQL, REXX, COBOL, etc. etc. etc.
Referer: Internet search

Re: Packed Decimal Subtraction

Postby sergeyken » Tue Aug 02, 2022 4:07 am

FYI:

The formats like 9(5)V99 et.al. are all UNPACKED (or ZONED) DECIMALS, rather than PACKED DECIMALS.
Javas and Pythons come and go, but JCL and SORT stay forever.
Top
Post Reply Previous topicNext topic
  • Similar Topics
    Replies
    Views
    Last post

Return to “Syncsort/Synctool”