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....

Answer / viswanath

thnks

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

Answer / anjireddy vintha

RUNTIME SUPERVISER WIL MONITER THE SQL QUERY'S AND IT WILL
GENERATE SQLCODE FOR EVERY EXEUTION OF SQL QUERY.

Answer / nithinbalaji mariappan

You need to display SQL-ERR-D variable from SQL CA on your program. It will write a sql error code

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

When would you prefer to use VARCHAR?

3 Answers  

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

How to execute stored procedure in db2 command editor?

0 Answers  

What are the three lock types?

2 Answers  

What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

How do you define a correlated name?

1 Answers  

What is db2 stogroup?

0 Answers  

How do I create a view in db2?

0 Answers  

What is meant by explain?

0 Answers  

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,