In SPUFI suppose you want to selet maximum of 10

More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions

• When is the skeleton cursor table created?
• What is a lock?
• What is a DBRM, PLAN?
• What is auditing
• What is DCLGEN?
• Can we declare DB2 HOST variable in COBOL COPY book ?
• What is the Manimum Length SQLCA and what is the content of SQLCABC?
• How is the status of a utility reset after it has been stopped by DB2?
• Explain the use of the WHERE clause?
• What happens to a tablespace when its recovery information has been removed and a full recovery is no longer possible?
• More...