Interested to Buy Any Domain ? << Click Here >> for more details...
wht displays the number of times a query modified ?
- 2 Answers
- 7198 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 |
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
how to identify the pseudo conversation by seeing the program
What is dynamic SQL?
What is the maximum number of columns in a db2 table?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What is a thread?
When is the access path determined for dynamic SQL?
What is correlated subquery?
What is ibm db2 database?
Can we declare DB2 HOST variable in COBOL COPY book?
What is meant by repeatable read?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
COBOL 
