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 |
Mention the definition of cobol in varchar field.
What is the clustering index in the db2 database?
Define buffer pool.
Define db2.
What is copy pending status in db2?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
What is a thread?
What does db2 plan contain?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
List down the types of triggers in the db2 database?
Suppose if I need to update a column, how you do that using cursor?