Multiple choice technology mainframe

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

  1. Precompile

  2. Package

  3. Bind

  4. Plan
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The BIND step analyzes static SQL statements, determines the most efficient access paths to the data, and stores this information in a plan or package. Precompile simply converts SQL to calls, while plan and package are the outputs of bind. BIND is the optimization phase.

Keep practicing — related questions