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 ibm db2 database?
How do I add a column to a table in db2?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
Can there be more than one cursor open for any program?
Where could you look if you had a question about whether a column has been defined as an index?
What is a db2 collection?
What is UNION,UNION ALL?
Define db2 and its databases?
How to find schema of a table in db2?
What is a clustering index?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?