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 physical storage length of timestamp data type?
Explain correlated sub-queries.
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
List some fields from sqlca?
What is EXPLAIN?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is package in db2 mainframe?
What is explain in db2?
What is a system catalog table in db2?
How do you Load a table ?? and what is Load replace ?
what is difference between random and sequence file access
How to see the structure of db2 table??