The DB2I primary option menu

The DB2I Primary Option Menu ISPF panel is the starting point for all DB2I tasks.

The following figure shows an example of the ISPF panel for the DB2I Primary Option Menu. From this panel, you can access all of the DB2I panels without passing through panels that you do not need.

Figure 1. The ISPF panel for the DB2I Primary Option Menu

 DSNEPRI                     DB2I PRIMARY OPTION MENU          SSID: DSN
 COMMAND ===>
 
 Select one of the following DB2 functions and press ENTER.
 
  1  SPUFI                  (Process SQL statements)
  2  DCLGEN                 (Generate SQL and source language declarations)
  3  PROGRAM PREPARATION    (Prepare a DB2 application program to run)
  4  PRECOMPILE             (Invoke DB2 precompiler)
  5  BIND/REBIND/FREE       (BIND, REBIND, or FREE plans or packages)
  6  RUN                    (RUN an SQL program)
  7  DB2 COMMANDS           (Issue DB2 commands)
  8  UTILITIES              (Invoke DB2 utilities)
  D  DB2I DEFAULTS          (Set global parameters)
  X  EXIT                   (Leave  DB2I)

The following descriptions explain the functions on the .

1 SPUFI: Lets you develop and execute one or more SQL statements interactively. For further information, see Executing SQL by using SPUFI.
2 DCLGEN: Lets you generate C, COBOL, or PL/I data declarations of tables. For further information, see DCLGEN (declarations generator).
3 PROGRAM PREPARATION: Lets you prepare and run an application program to run. For more information, see DB2 Program Preparation panel.
4 PRECOMPILE: Lets you convert embedded SQL statements into statements that your host language can process. For further information, see Precompile panel.
5 BIND/REBIND/FREE: Lets you bind, rebind, or free a package or application plan. For more information, see Bind/Rebind/Free Selection panel.
6 RUN: Lets you run an application program in a TSO or batch environment. For more information, see DB2I Run panel.
7 DB2 COMMANDS: Lets you issue DB2 commands.
8 UTILITIES: Lets you call DB2 utility programs.
D DB2I DEFAULTS: Lets you set DB2I defaults. See DB2I Defaults Panel 1.
X EXIT: Lets you exit DB2I.