What is the COBOL picture clause for a DB2 column defined
as DECIMAL(11,2)?
Answers were Sorted based on User's Feedback
Answer / pradeep
it is s9(m-n)v9(n) comp-3 in this case m=11, n=2
ie s9(9)v9(2) comp-3
| Is This Answer Correct ? | 30 Yes | 4 No |
PIC S9(9)V99 COMP-3.
In DECIMAl(11,2), 11 indicates the size of data type and 2
indicates the precision.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is correlation names?
What is sqlca’s maximum length?
What is buffer pool and list some of them?
What DB2 Catalog column tell you when an index needs table reorganized ?
what is the difference between where clause and having clause
What is null indicator in db2?
What is lock escalation in db2?
how 2 resolve the -311 sqlcode
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How to execute stored procedures?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..