Salesforce.com Learn & Share
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 PROGRAM(EDD470BD) PLAN(EDD470BD) LIB(‘ED 01T.OBJ.LOADLIB’) END (10)
Read More31) 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 has not effect in psuedo-conversational CICS programs. 32) Give the…
Read More21.) 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 through macros of DSNCRCT. RCT matches with the transaction ID…
Read More11.) 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.) What is a storage group (STOGROUP)? STOGROUP is a named…
Read More1.) 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 DB2 SELECT ? Use SELECT DISTINCT … in db2 query…
Read More21.What are some of the main fields in SQLCA? Major Fields in SQLCA is SQL CODE, SQLERRM, and SQLERRD. (122)
Read More11.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, the partial string matches would do. (101)
Read More1.How to find number of rows in DB2 tables? User has to use SELECT COUNT (*) on DB2 query. (130)
Read More41.Write a query to delete a table from database.? DROP TABLE table-name is the syntax to delete a table from database. (175)
Read More31.When you will face SQLCODE -911? At the time of deadlock or timeout you will face SQLCODE -911. (163)
Read More