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 |
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
How do I delete a table in db2?
What is iseries database?
Which command is used to remove all rows from a table?
What is an intent lock?
When the like statement is used?
Who uses db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What do you need to do before you do EXPLAIN ?
Where are plans stored?
How can you classify the locks in db2?