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 |
How do I copy a table in db2?
What is meant by AUTO COMMIT?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How to resolve -917 sql code in DB2?
How to design maps
What r the comman abends in db2, jcl and cobol???????
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
How to find the maximum value in a column in the db2 database?
How many types of page locks can be held in db2?