DB2 Interview Questions | Eklavya Online

DB2 Interview Questions

What are the contents of a DCLMGEN?

EXEC SQL DECLARE TABLE statement which gives the layout of the table in terms of DB2 data type. A host language copy book that gives the host variable definitions for the column name.

What is DCLGEN?

DCLGEN is stands for DeCLarations GENErator. It is used to create the host language copy books for the table definitions. It also creates the DECLARE table.

What is role in DB2?

In DB2, a role is an object of database that group various privileges together and can be assigned to groups or user by GRANT statement.