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 is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
What does the RUNSTATS Utility do?
What is dbrm? What it contains?
how to check the table is empty or not?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
How to view db2 table structure?
How to find the number of rows in a db2 table?
Can we declare DB2 HOST variable in COBOL COPY book?
What os does db2 run on?
What is db2 stogroup?
What's the maximum number of characters that a tablename can have?
Explain package in db2 and its advantages?