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 DB2 Catalog column tell you when an index needs table reorganized ?
When can an insert of a new primary key value threaten referential integrity?
What are the uses of db2 optimizer?
what are the max. & min. no. of partitions allowed in a partition tablespace?
How to handle null values in db2
Is the primary key a clustered index?
What is an instance database?
What's The Percentage Free Space ?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
what's the error code for Unique Index Violation?
What is a root page?