Tag: mainframe

Dynamic SQL statements are embedded in programs and bound before they are executed.

The COBOL copy statements will be expanded during pre-compile stage.

SQL data type DATE, TIME or TIMESTAMP will be accdepted as character strings in COBOL program

In Dynamic SQL ,The COMMIT or ROLLBACK statement destroys the prepared statement and the statement need to be prepared again.

Which step analyzes all the static SQL and stores the more efficient path to the data in a plan/package while compiling a cobol/DB2 program

COBOL host structures can have maximum of three levels in a COBOL/DB2 program

Which assembler routine used to obtain a formatted form of the SQLCA and a text message based on the SQLCODE field of SQLCA

To allow DB2 to close a cursor after a commit or a rollback operation, we use the WITH HOLD option of the DECLARE CURSOR statement.

In the segemented table space each segment contain.