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 |
Is ibm db2 free?
Define sqlca.
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
what is the maximum number of tables that can be joined ?
Can you access the DB2 Directory table using SQL?
how will you retrieve first record in table
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
What is runstats db2?
How do you run JCL in cobol program
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What is the role of the data page in the db2 database?
what is the input to PLAN? what is the input to DBRM?