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
 
db2 data type

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

Active User


Joined: 17 Oct 2004
Posts: 173
Location: hyderabad
PostPosted: Wed Jul 20, 2005 12:10 pm    Post subject: db2 data type
 Reply with quote
Hi

can any one give the Db2 equivaqlent of Oracle NUMERIC (35)
as in db2

small int ---4
integer ---8
bigint ----18
decimal(p,s) ---p =31

SO for the NUMERIC (35) what is the equvalent in db2


thanks
siva
Back to top
View user's profile Send private message
References
Prasanthhere

Senior Member


Joined: 03 Aug 2005
Posts: 304
PostPosted: Wed Aug 03, 2005 3:55 pm    Post subject:
Reply with quote
We shuld either go 4 varchar(35) which will take depending on the values u give or numeric (35)
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