Tag: technology

Difference between UNION and UNION ALL.

What is the communication area between DB2 and cobol to communicate the error codes.

A host variable structure can allow to contain an OCCURS clause.

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

The data definition of Null indicator variables in cobol/DB2 program is ?

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