Tag: mainframe

__________utility gathers information about data in tablespaces, indexes and updates DB2 catalog

If a transaction successfully updates a record, it is imperative that it has an ________ on it

If a table is dropped, the space for that table can be reclaimed with minimum reorg in

In Partitioned Tablespace, individual partitions cannot be independently recovered and reorganized

DB2 Security is provided internal to DB2 using the

DEFINE DATA LOCAL 1 #VAR-1 (A25) END-DEFINE MOVE 'THIS IS MY FIRST PROGRAM' TO #VAR-1 WRITE #VAR-1 END The above statements are correct or not.

Packed numeric, 7 positions before and 2 after decimal point and 1 sign position

Command used to catch the syntax errors

A list of the last names and salaries of all employees earning at least $40,000 a year. READ EMPLOYEES WITH SALARY STARTING FROM 40000 DISPLAY NAME SALARY END

What the EXAMINE command will do