how to u check the query is executing or not ?where will u check for sqlcode ?
- 6 Answers
- 10707 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / lu
OH man...everytime, you execute a sql statement, u have to
check you SQLCODE = 0 or not = 0....this a basic using DB2,
Oracle....
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What os does db2 run on?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
On which levels locks can be applied?
What are the two types of logging in the db2 database? Explain them.
How can you quickly find out the # of rows updated after an update statement?
Mention the various locks that are available in db2.
Can we insert update delete in view?
What is host variable?
How to find schema of a table in db2?
What is sqlca’s maximum length?
What is the max length of sqlca?
What is innodb buffer pool?
Can you use max on a char column?
How do you eliminate duplicate values in db2?
What parameters are used to control the free space in DB2?
