DB2

41) How is a typical DB2 batch pgm executed ? 1. Use DSN utility to run a DB2 batch program from native TSO. An example is shown: DSN SYSTEM(DSP3) RUN …

31) How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only ) Use WITH HOLD option in DECLARE CURSOR statement. But, it …

21.) Explain about RCT. RCT is expanded as Resource – Control Table and is defined in the DB2/CICS region. This is the component that comprises of features that are gathered …

11.) Explain the function of Data Manager. The physical database is managed by the DB2 component called Data manager. It invokes other system components to perform logging, locking etc. 12.) …

1.) How would you find out the total number of rows in a DB2 table? Use SELECT COUNT(*) … in db2 query 2.) How do you eliminate duplicate values in …

21.What are some of the main fields in SQLCA? Major Fields in SQLCA is SQL CODE, SQLERRM, and SQLERRD.

11.When the LIKE statement is used? LIKE statement is used to conduct partial searches like the search of employees by name. It is not necessary to indicate the complete name, …

1.How to find number of rows in DB2 tables? User has to use SELECT COUNT (*) on DB2 query.

41.Write a query to delete a table from database.? DROP TABLE table-name is the syntax to delete a table from database.

31.When you will face SQLCODE -911? At the time of deadlock or timeout you will face SQLCODE -911.