wht displays the number of times a query modified ?
Answers were Sorted based on User's Feedback
Answer / ramakrishna javvaji
SQLERRID(3) field of SQLCA will have no of updates that the
query made.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / mehdee
- If you mean what displays the number of time that a DB2
row has been modified, then my answer is when you create
this DB2 table add a column like SEQ_NUM and as you define
it like SMALLINT, right there you can have it increamented
by 1. Please look into manual for it's exact format.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the database descriptor?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
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?
What are the Isolation levels possible ?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is sqlca?
wht steps we need will coding cobol and db2 pgm ?
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
How do I delete a column in db2?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is the maximum size of a char data type in db2?
What is db2 bind process?