Zoned decimal equivalent in Syncsort for DB2 decimal datatyp

[Prasanna G]

Hi

I am urgently in need of zoned decimal equivalent of the below DB2 data types in Syncsort.
I need the sign to be displayed when negative, decimal point to be displayed in my file.
No need for digit separators.
Can some syncsort gurus be able to provide me with the details as early as possible?

Code: Select all

DECIMAL(22, 7),
DECIMAL(4, 0),
DECIMAL(10, 0),
DECIMAL(9, 2),


Thanks
Prasanna G.

[enrico-sorichetti]

I am urgently in need ... ... ...as early as possible?

remember that people replying to forum questions do it ..

ON THEIR OWN TIME
free of charge

based on ..
interest of the topic
benevolence factor of the TS(*)

claiming urgency is a way to lower dramatically Your benevolence factor

just look at the db2 manuals to find out the equivalence between DB2 data types and COBOL data types ..
and You should be able to reply Yourself to the question You asked ...

[Prasanna G]

Hi Enrico

I apologize for putting that in my post.
I have the cobol equivalent by generating the DCLGEN for the table. I would like to know the syncsort equivalent edit masks if any.


Thanks
Prasanna G.

[enrico-sorichetti]

the point is not about the datatype equivalence ...
but the format of the data in Your input file ( THAT' S WHAT COUNTS )

the manual is clear enough ...

DB2 DECIMAL/NUMERIC ( max_digits , dec_digits )
correspond to
COBOL S9( max_digits-dec_digits )V9(dec_digits )

the integer/decimal separator is VIRTUAL

zoned or packed depending on the COMP specification ...

gazillions of examples around here to show how to deal with them ( both with SYNCSORT or IBM DFSORT )
and how to take care of the differences in the number decimal digits

[Prasanna G]

Hi Enrico

I am not able to get the edit mask for S9(15)V9(7) Comp 3 in syncsort. All the examples provided are having s9(15)V9(2) Comp 3.
I need the edit mask for s9(15)v9(7) comp 3 in syncsort.

Thanks
Prasanna G.

[BillyBoyo]

Instead of two digits after the ".", put seven.

If that doesn't fix it, paste the sysout of what you have tried.