Zoned decimal equivalent in Syncsort for DB2 decimal datatyp



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Zoned decimal equivalent in Syncsort for DB2 decimal datatyp

Postby Prasanna G » Thu Apr 16, 2015 1:16 pm

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.
User avatar
Prasanna G
 
Posts: 68
Joined: Tue Apr 12, 2011 9:49 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Zoned decimal equivalent in Syncsort for DB2 decimal dat

Postby enrico-sorichetti » Thu Apr 16, 2015 1:28 pm

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 ...
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Zoned decimal equivalent in Syncsort for DB2 decimal dat

Postby Prasanna G » Thu Apr 16, 2015 1:41 pm

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.
User avatar
Prasanna G
 
Posts: 68
Joined: Tue Apr 12, 2011 9:49 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Zoned decimal equivalent in Syncsort for DB2 decimal dat

Postby enrico-sorichetti » Thu Apr 16, 2015 2:09 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Zoned decimal equivalent in Syncsort for DB2 decimal dat

Postby Prasanna G » Thu Apr 16, 2015 2:29 pm

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.
User avatar
Prasanna G
 
Posts: 68
Joined: Tue Apr 12, 2011 9:49 pm
Has thanked: 1 time
Been thanked: 0 time

Re: Zoned decimal equivalent in Syncsort for DB2 decimal dat

Postby BillyBoyo » Thu Apr 16, 2015 5:59 pm

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

If that doesn't fix it, paste the sysout of what you have tried.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post