Salesforce.com Lightning and Lightning Web Component – 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
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 More