WHAT IS MEANT BY COMMIT COMMAND?
Answers were Sorted based on User's Feedback
Answer / labog
Commit saves all the changes made to the database and
closes all Cursors opened except the Cursors with WITH HOLD
option.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / harsha
It is used to save the Logical Unit of Work(LUW) to
database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / santhosh
commit means saves the previous transaction done
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishnaveni
commit is used to save the previous dml(data manipulation
language ex:insert,upadte,.) statements
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shaikdada
I TOLD IT IS THE LAST EXECUTABLE STATEMENT OF COBOL DB2
PROGRAM.
| Is This Answer Correct ? | 2 Yes | 3 No |
What is the use of db2?
Can you use max on a char column?
Q4. How will you get the count of record without using COUNT verb in query?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
wht are the restrictions for union ?
What is db2 look?
How do we specify index to include or not during bind process.
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
Mention data types used in db2 ?
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.
What is REORG? When is it used?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?