Interview Questions

In SPUFI suppose you want to selet maximum of 1000 rows ...

DB2 ( IBM Database 2 ) Interview Questions


(Continued from previous question...)

In SPUFI suppose you want to selet maximum of 1000 rows ...

Q: In SPUFI suppose you want to selet maximum of 1000 rows, but the select returns only 200 rows, What are the 2 SQLCODEs that are returned?

An:
+100 ( for successful completion of the query), 0 (for successful COMMIT if AUTOCOMMIT is set to Yes ).

(Continued on next question...)

Other Interview Questions