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 information is held in SYSIBM.SYSCOPY?
What is the use of db2?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
what is a plan and how do you refer the plan in the program?
What is role in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is cursor with hold option in db2?
What is query_cache_limit?
define clustering index.
When is the results table for the query in a DECLARE CURSOR statement created?
Give the name of some fields form sqlca.
How many types of page locks can be held in db2?