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

Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
Suggest New Category

Question Posted / visu.kanchamreddy

6 Answers
12810 Views
Infosys, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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

Answer / viswanath

thnks

Is This Answer Correct ?

0 Yes

0 No

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

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

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

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

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

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

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

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

Post New Answer