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 the use of cursors?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is a buffer pool?
What is reorg and runstats in db2?
What is meant by dclgen?
What is the maximum number of columns in a db2 table?
define clustering index.
how can i pull up a query which was previously stored in qmf
Explain the function done by data manager?
What is rebind in db2?
Which one allows duplicate values Union or Union All ?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,