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
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is dbrm? What it contains? When it will be created?
Which is faster delete or truncate?
Which command is used to remove all rows from a table?
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 .....
What are host variables in db2?
Is db2 relational database?
What is ibm db2 client?
Explain the contents that are a part of dclgen.
What is deadlock in db2?
Is ibm db2 open source?
What is temporal table in db2?
Explain various types of locks in db2?
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?
Define sqlca.