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

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

575


What is dbrm? What it contains? When it will be created?

589


Which is faster delete or truncate?

671


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

548


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1889






What are host variables in db2?

620


Is db2 relational database?

567


What is ibm db2 client?

515


Explain the contents that are a part of dclgen.

651


What is deadlock in db2?

577


Is ibm db2 open source?

580


What is temporal table in db2?

599


Explain various types of locks in db2?

685


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1931


Define sqlca.

647