what's the equivalent Cobol Data type for Decimal(x,y) in
DB2? what does the current SQLID register contain?
Answers were Sorted based on User's Feedback
Answer / arun
cobol equivalent data type would be PIC s9(x-y)V9(y) comp3
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / marekj
SQLID - current SQL authorization ID, and qualifier for
dynamic SQL if DYNAMICRULES(run) was set during BIND process.
| Is This Answer Correct ? | 2 Yes | 1 No |
what's the error code for Unique Index Violation?
select 100 records from million records ?
What is difference between isnull and coalesce?
Mention and explain the contention situations caused by locks?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
When is the access path determined for dynamic SQL?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
how do we solve soc 7 and soc4 ?
What is dbrm? What it contains?
What do you mean by cursor?
Explain the use of the WHERE clause.
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.