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 |
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
Where could you look if you had a question about whether a column has been defined as an index?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
How to find last record before record through SQLRPGLE?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
What is dbrm in db2 database?
Mention data types used in db2 ?
What is the use of dclgen in db2?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
what is difference between Plan and Package
What are the uses of db2 optimizer?