how to u check the query is executing or not ?where will u check for sqlcode ?
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 is image copy in db2?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is buffer pool?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Explain the contention situations caused by locks?
Explain about rct.
What is the use of predicate?
What is db2 connect?
what are bind concepts in db2 cobol?
What is bind and rebind in db2?
What is a plan and package in db2?
What is the difference between drop table and delete table?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Which is faster delete or truncate?