how to u check the query is executing or not ?where will u check for sqlcode ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / arun
If you want to check from DBA point of view.
I would suggest if the query is taking longer time you can
use any of the tools like detector and check how long the
query is running and how much cpu has been allocated to
this thread and how many get pages has been done how many
rows has been selected or inserted or updated.
We have tools to know the current status of the query.
If the query is simple and completes quickly SQL RC = 0 is
for the normal completion of the query
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anjireddy vintha
RUNTIME SUPERVISER WIL MONITER THE SQL QUERY'S AND IT WILL
GENERATE SQLCODE FOR EVERY EXEUTION OF SQL QUERY.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
Answer / 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 |
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What techniques are used to retrieve data from more than one table in a single SQL statement?
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is meant by dclgen?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What can the Locate option of the Repair Utility accomplish?
How can you quickly find out the # of rows updated after an update statement?
how to u check the query is executing or not ?where will u check for sqlcode ?
How would one remove old reorg information from the DB2 catalog?