how to u check the query is executing or not ?where will u check for sqlcode ?
Answer Posted / ankit.:-)
before embeding check that command in SPUFI and u will get
the sqlcode value , if it is successful means
sqlcode=0 ,then go for embeding into pgm
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Can one database have multiple instances?
Is db2 a mainframe?
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.
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Which isolation level provides highest data integrity?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
How to check sequence on a table in db2?
Can we delete records from view?
What is catalog database in db2?
Are view updateable?
What are the bind parameters ibm db2?
What is db2 bind?
What is netezza database?
What is a buffer in memory?