how can u nderstand the sql stmts executed successfully or not ?

Question Posted / visu.kanchamreddy

1 Answers
5971 Views
TCS, I also Faced
E-Mail Answers

how can u nderstand the sql stmts executed successfully or not ?..

Oh man, you have to check SQLCODE for each SQL
stament...SQLCODE = 0 it's good.... SQLCODE not = 0 it's
bad.
OR you look in SQLCA... verify this SQLERRD

Is This Answer Correct ?

5 Yes

0 No

Post New Answer

More DB2 Interview Questions

What is the difference between nvl and coalesce?

0 Answers

how to resolve -811 error. give clear explination

4 Answers IBM,

What is with ur in db2?

0 Answers

What can the Locate option of the Repair Utility accomplish?

2 Answers

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers Mphasis,

what is the difference between where clause and having clause

2 Answers IBM,

Which one allows duplicate values Union or Union All ?

3 Answers

Why do we use cursor?

0 Answers

Mention and explain the contention situations caused by locks?

1 Answers

my project is insurance management system,how to explain my work environment in interview?

2 Answers CGI, Value Labs,

Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?

1 Answers

What are the Isolation levels possible ?

5 Answers

For more DB2 Interview Questions Click Here