Page 1 of 1

Zoned decimal equivalent in Syncsort for DB2 decimal datatyp

PostPosted: Thu Apr 16, 2015 1:16 pm
by 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?

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


Thanks
Prasanna G.

Re: Zoned decimal equivalent in Syncsort for DB2 decimal dat

PostPosted: Thu Apr 16, 2015 1:28 pm
by 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 ...

Re: Zoned decimal equivalent in Syncsort for DB2 decimal dat

PostPosted: Thu Apr 16, 2015 1:41 pm
by 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.

Re: Zoned decimal equivalent in Syncsort for DB2 decimal dat

PostPosted: Thu Apr 16, 2015 2:09 pm
by 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

Re: Zoned decimal equivalent in Syncsort for DB2 decimal dat

PostPosted: Thu Apr 16, 2015 2:29 pm
by 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.

Re: Zoned decimal equivalent in Syncsort for DB2 decimal dat

PostPosted: Thu Apr 16, 2015 5:59 pm
by BillyBoyo
Instead of two digits after the ".", put seven.

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