Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
Comp in DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
chandrasekhar

New User


Joined: 29 Sep 2004
Posts: 35
Location: bangalore

PostPosted: Tue Nov 02, 2004 7:22 pm    Post subject: Comp in DB2
Reply with quote

Can someone tell me exactly how COMP, COMP-3 values get stored in DB2.

If a value of COMP-3 needs to be stored how should the DB2 column be like
Back to top
View user's profile Send private message
References
PostPosted: Tue Nov 02, 2004 7:22 pm    Post subject: Re: Comp in DB2 Reply with quote

anuradha

Global Moderator


Joined: 06 Jan 2004
Posts: 257

PostPosted: Tue Nov 09, 2004 7:20 pm    Post subject:
Reply with quote

Hi Chandra,

For SQL declaration of DECIMAL(n,m),
the COBOL equivalent generated is PIC S9(n-m)v9(m) COMP-3
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1