how to u check the query is executing or not ?where will u check for sqlcode ?

Answer Posted / nithinbalaji mariappan

You need to display SQL-ERR-D variable from SQL CA on your program. It will write a sql error code

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the benefits of using the db2 database?

662


How is a typical db2 batch pgm executed?

642


Which command is used to remove all rows from a table?

553


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10777


What is runstats db2?

585






Why do we bind in db2?

632


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2324


What is with ur in db2?

760


Give the name of some fields form sqlca.

614


What is a trigger in the db2 database?

596


What is the difference between oracle and db2?

587


How to compare data between two tables in db2?

660


What is the syntax for creating a table in the db2 database?

628


What are types of indexes?

593


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

581