Mainframe Interview Questions - DB2

1.Bind Process


2.PLAN and PACKAGE

3.-805,-811,-904,100,-502,-818,-911,-180,-913, -922

4.Bind Parameters

5.DCLGEN and DBRM

6.BETWEEN , IN , LIKE commands

7.Subquery(subselect)

8.JOINS & UNIONS, GROUP BY and ORDERBY

9.copy pending and Check pending

10.DDL, DML and DC

11.SYSIBM.SYSTABLES , SYSIBM.SYSPACKAGE, SYSIBM.SYSCOPY, SYSIBM.SYSVIEWS, SYSIBM.SYSPLAN

12.Referential Integrity

13.alias and a synonym

14.SQLCA, COMMIT and ROLLBACK

15.NULL INDICATOR