What is the COBOL picture clause for a DB2 column defined
as DECIMAL(11,2)?
- 5 Answers
- 19572 Views
- Emsang, I also Faced
- E-Mail Answers
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 bind package and plan in db2?
How to retrieve rows from a db2 table in embedded sql?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
How can you quickly find out the number of rows updated after an update statement?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
what's the error code for Unique Index Violation?
How do you insert a record with a nullable column?
What is the difference between spufi and qmf?
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,
How to resolve -818 sql code in DB2?
How to find schema of a table in db2?
COBOL 
