Interested to Buy Any Domain ? << Click Here >> for more details...
wht displays the number of times a query modified ?
- 2 Answers
- 6973 Views
- TCS, I also Faced
- E-Mail Answers
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 physical storage length of date data type?
What is the difference between IN subselects and EXISTS subselect?
how can u nderstand the sql stmts executed successfully or not ?
What do you mean by NOT NULL? When will you use it?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
explain about index with examples
What is meant by union and union all?
Give some example of statistics collected during RUNSTATS?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
How can you quickly find out the # of rows updated after an update statement?
What is package in cobol db2?
How many sub queries can you combine together ?
COBOL 
