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 |
Explain db2.
What is the purpose of the QUIESE Utility?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
Is db2 a programming language?
what is diffrence b/w file-aid tool and file-aid utility???
B37 abend during spufi?
wt is view ? wht r the restrictions for view ?
What is the syntax for FETCH in DB2 ?
What is cursor with hold option in db2?
wht r the requirements for writing a cobol-db2 pgm ?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
What is a cursor and what is its function?