How would you print the output of an SQL statement from SPUFI?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

How would you print the output of an SQL statement from SPUFI?

Print the output dataset.

(Continued on next question...)

Other Interview Questions

• What is the error code for Unique Index Violation?
• I need to view the number of tables existing under one particular OWNER. Is it possible ? If so, please give the SQL query for this ?
• What is DCLGEN?
• What is a clustering index?
• How many sub queries can you combine together?
• Can DASD types assigned to storage groups be intermixed ?
• Can DASD types assigned to storage groups be intermixed ?
• When would you prefer to use VARCHAR ?
• What are the 4 environments which can access DB2?
• What is a base table ?
• More...