By using the DISPLAY DATABASE command.
Tweet This Post

By issuing the START RLIMIT command.
Tweet This Post

The DBA would issue a RECOVER BSDS command.
Tweet This Post

The DISPLAY command can return the following environmental data: DATABASE info, RLIMIT info, THREAD info, TRACE info, and UTILITY info.
Tweet This Post

A read-only cursor is one in which the result table was created by a query containing one of the following :
• a DISTINCT keyword
• a UNION operator
• a column or scalar function
• a GROUP BY clause
• a ORDER BY clause
• a HAVING clause
• a read-only view in the FROM clause
• a FROM clause identifying more than one table or view
Tweet This Post

The results table for a query specified in a DECLARE CURSOR statement of a cursor is created during the execution of the OPEN CURSOR statement.
Tweet This Post

EXEC SQL
DECLARE cur_name CURSOR for
SELECT col1,col2
FROM table1
WHERE col1 = search_condition
END-EXEC.
Tweet This Post

It directs DB2 to extract data from rows where the value of the column is the same as the current value of the host variable.
Tweet This Post

Fifteen
Tweet This Post

01 EMP-GRP. 49 E-LEN PIC S9(4) COMP. 49 E-NAME PIC X(25).
Tweet This Post