DB2I
                                                        DB2I PRIMARY OPTION MENU                                                     SSID: DSN
COMMAND ===> 2

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)


F1=HELP                 F2=SPLIT             F3=END            F4=RETURN             F5=RFIND              F6=RCHANGE
F7=UP                      F8=DOWN           F9=SWAP          F10=LEFT                  F11=RIGHT            F12=CURSOR
 

                          DCLGEN
 
                                                                             DCLGEN                                                                          SSID: DSN
===> 

Enter table name for which declarations are required:


    1 SOURCE TABLE NAME ===> EMP157                           (Unqualified)
    2 TABLE OWNER ..... ===> IBMMFS                                (Optional)
    3 AT LOCATION ..... ===>                                                     (Optional)
 Enter destination data set:                                                          (Can be sequential or partitioned)
    4 DATA SET NAME ... ===> 'IBMMFS.MACC.DB2(DCL157)'
    5 DATA SET PASSWORD ===>                                            (If password protected)
 Enter options as desired:
    6 ACTION .......... ===> REPLACE                                         (ADD new or REPLACE old declaration)
    7 COLUMN LABEL .... ===> YES                                         (Enter YES for column label)
    8 STRUCTURE NAME .. ===> EREC                                   (Optional)
    9 FIELD NAME PREFIX ===> E                                           (Optional)
    10 DELIMIT DBCS .... ===> YES                                          (Enter YES to delimit DBCS identifiers)
    11 COLUMN SUFFIX ... ===> YES                                        (Enter YES to append column name)
    12 INDICATOR VARS .. ===> YES                                       (Enter YES for indicator variables)
 

F1=HELP                 F2=SPLIT             F3=END            F4=RETURN             F5=RFIND              F6=RCHANGE
F7=UP                      F8=DOWN           F9=SWAP          F10=LEFT                  F11=RIGHT            F12=CURSOR
 

 

® IBMMAINFRAMES.com Training Division                                                            © www.ibmmainframes.com