Questions And Answers for PowerBuilder CPD Exam

Question

The UPDATE statement in an embedded SQL script did not update a single row. What would be value of SQLCODE?

 [A] -1
 [B] NULL
 [C] -100
 [D] 0
 [E] Results in error.

Click here to see the answer

Answer

The correct answer is: D

Click here to go to top of the page.

Click here to see the explanation.

Explanation

If UPDATE statement WHERE clause doesn't find any rows that matches the WHERE clause, then it updates zero rows. Updating zero rows is not an error, that's why SQLCODE in this case contains zero, meaning successful. You need to check SQLNRows to find the number of rows effected.

Click here to go to top of the page.