Db2 Screen Shots

DB2I PRIMARY OPTION MENU COMMAND ===> Select one of the following DB2 functions and press ENTER.

3=END 9=SWAP

4=RETURN 5=RFIND 6=RCHANGE 10=LEFT 11=RIGHT 12=RETRIEVE

A

PF 1=HELP 2=SPLIT PF 7=UP 8=DOWN

M

ES

.c om

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)

FR

option : 1 -----------

SPUFI

===>

SSID: DSN

A

IN

Enter the input data set name: (Can be sequential or partitioned) 1 DATA SET NAME ... ===> 'LEM0U01.SUN.QUERIES(DROP1)' 2 VOLUME SERIAL ... ===> (Enter if not cataloged) 3 DATA SET PASSWORD ===> (Enter if password protected)

M

Enter the output data set name: (Must be a sequential data set) 4 DATA SET NAME ... ===> 'LEM0U17.HARI.DB2OUT'

IB

M

Specify processing options: 5 CHANGE DEFAULTS ===> YES (Y/N - Display SPUFI defaults panel?) 6 EDIT INPUT ...... ===> YES (Y/N - Enter SQL statements?) 7 EXECUTE ......... ===> YES (Y/N - Execute SQL statements?) 8 AUTOCOMMIT ...... ===> YES (Y/N - Commit after successful run?) 9 BROWSE OUTPUT ... ===> YES (Y/N - Browse output data set?) 10 CONNECT LOCATION ===>

PF 1=HELP

2=SPLIT

3=END

4=RETURN 5=RFIND

6=RCHANGE

A MCMILLAN PRODUCT

PF 7=UP

8=DOWN

option :2 ----------

9=SWAP

10=LEFT

--------------DCLGEN

12=RETRIEVE

SSID: DSN

------------------

.c om

===>

11=RIGHT

Enter table name for which declarations are required: 1 SOURCE TABLE NAME ===> 'EMP' (Unqualified) 2 TABLE OWNER ..... ===> (Optional) 3 AT LOCATION ..... ===> (Optional)

ES

Enter destination data set: (Can be sequential or partitioned) 4 DATA SET NAME ... ===> 'LEM0U17.SAI.DBS' 5 DATA SET PASSWORD ===> (If password protected)

FR

A

M

Enter options as desired: 6 ACTION .......... ===> ADD (ADD new or REPLACE old declaration) 7 COLUMN LABEL .... ===> YES (Enter YES for column label) 8 STRUCTURE NAME .. ===> HV-REC (Optional) 9 FIELD NAME PREFIX ===> HV(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) option :3 ---------SSID: DSN

IN

DB2 PROGRAM PREPARATION COMMAND ===>

IB

M

M

A

Enter the following: 1 INPUT DATA SET NAME .... ===> 2 DATA SET NAME QUALIFIER ===> TEMP (For building data set names) 3 PREPARATION ENVIRONMENT ===> FOREGROUND (FOREGROUND, BACKGROUND, EDITJCL) 4 RUN TIME ENVIRONMENT ... ===> TSO (TSO, CAF, CICS, IMS, RRSAF) 5 OTHER DSNH OPTIONS ..... ===> (Optional DSNH keywords) Select functions: Display panel? Perform function? 6 CHANGE DEFAULTS ........ ===> Y (Y/N) 7 PL/I MACRO PHASE ....... ===> N (Y/N) ===> N (Y/N) 8 PRECOMPILE ............. ===> N (Y/N) ===> Y (Y/N) 9 CICS COMMAND TRANSLATION ===> N (Y/N) 10 BIND PACKAGE ........... ===> N (Y/N) ===> Y (Y/N) 11 BIND PLAN .............. ===> N (Y/N) ===> Y (Y/N)

A MCMILLAN PRODUCT

COMPILE OR ASSEMBLE .... ===> N (Y/N) ===> Y (Y/N) PRELINK ................ ===> N (Y/N) ===> Y (Y/N) LINK ................... ===> N (Y/N) ===> Y (Y/N) RUN .................... ===> N (Y/N) ===> Y (Y/N)

options :4 -----------

PRECOMPILE COMMAND ===>

SSID: DSN

Enter precompiler data sets: 1 INPUT DATA SET .... ===> 2 INCLUDE LIBRARY ... ===>

(For building data set names)

ES

3 DSNAME QUALIFIER .. ===> TEMP 4 DBRM DATA SET ..... ===>

.c om

12 13 14 15

(FOREGROUND,

A

M

Enter processing options as desired: 5 WHERE TO PRECOMPILE ===> FOREGROUND BACKGROUND, or EDITJCL) 6 VERSION ........... ===> (Blank, VERSION, or AUTO) 7 OTHER OPTIONS ..... ===>

FR

options :5 ---------

SSID: DSN

IN

BIND/REBIND/FREE COMMAND ===>

Select one of the following and press ENTER: (Add or replace an application plan)

A

1 BIND PLAN

M

2 REBIND PLAN 3 FREE PLAN

(Erase application plan or plans)

4 BIND PACKAGE

M

IB

(Rebind existing application plan or plans)

(Add or replace a package)

5 REBIND PACKAGE (Rebind existing package or packages) 6 FREE PACKAGE

(Erase a package or packages)

optoins : 6

A MCMILLAN PRODUCT

-----------RUN

===>

SSID: DSN

.c om

Enter the name of the program you want to run: 1 DATA SET NAME ===> 'LEM0U17.RAVIKK.DB22(ONE)' 2 PASSWORD .... ===> (Required if data set is password protected)

ES

Enter the following as desired: 3 PARAMETERS .. ===> 4 PLAN NAME ... ===> (Required if different from program name) 5 WHERE TO RUN ===> FOREGROUND (FOREGROUND, BACKGROUND, or EDITJCL) DB2 COMMANDS SSID: DSN

A

IN

FR

A

Cmd 1 ===> SELECT * FROM EMP Cmd 2 ===> Cmd 3 ===> ...> Cmd 4 ===> ...> Cmd 5 ===> ...> ...> Cmd 6 ===> ...> ...> Cmd 7 ===> ...> ...> ...>

M

Position cursor on the command line you want to execute and press ENTER

DB2

UTILITIES

M

SSID: DSN ===>

IB

M

Select from the following:

1 FUNCTION ===> EDITJCL (SUBMIT job, EDITJCL, DISPLAY, TERMINATE) 2 JOB ID ===> TEMP (A unique job identifier string) 3 UTILITY ===> REPORT (CHECK, CHECK DATA, COPY, DIAGNOSE, LOAD, MERGE, MODIFY, QUIESCE, RECOVER INDEX,

A MCMILLAN PRODUCT

RECOVER TABLESPACE, REORG INDEX, REORG TABLESPACE, REPORT, REPAIR, RUNSTATS, STOSPACE.) 4 CONTROL CARDS DATA SET ===> UTIL

5 RESTART ===> NO

.c om

To RESTART a utility, specify starting point, otherwise enter NO. (NO, At CURRENT position, or beginning of PHASE)

* The data set names panel will be displayed when required by a utility.

ES

DB2I DEFAULTS COMMAND ===> Change defaults as desired:

IN

FR

A

M

1 DB2 NAME ............. ===> DSN (Subsystem identifier) 2 DB2 CONNECTION RETRIES ===> 0 (How many retries for DB2 connection) 3 APPLICATION LANGUAGE ===> COBOL (ASM, C, CPP, COBOL, COB2, IBMCOB, FORTRAN, PLI) 4 LINES/PAGE OF LISTING ===> 60 (A number from 5 to 999) 5 MESSAGE LEVEL ........ ===> I (Information, Warning, Error, Severe) 6 SQL STRING DELIMITER ===> DEFAULT (DEFAULT, ' or ") 7 DECIMAL POINT ........ ===> . (. or ,) 8 STOP IF RETURN CODE >= ===> 8 (Lowest terminating return code) 9 NUMBER OF ROWS ....... ===> 20 (For ISPF Tables) 10 CHANGE HELP BOOK NAMES?===> NO (YES to change HELP data set names) 11 DB2I JOB STATEMENT: (Optional if your site has a SUBMIT exit)

IB

M

M

A

===> //LEM0U17 JOB (ACCOUNT),'NAME' ===> //* ===> //* ===> //*

****************************************************************** * DCLGEN TABLE(EMPTAB10) * * LIBRARY(LEM0U21.KBM.DCLGEN(EMPTAB10)) * * ACTION(REPLACE) * * LANGUAGE(COBOL) * * NAMES(HV-) *

A MCMILLAN PRODUCT

* * * * *

STRUCTURE(HV-REC) QUOTE LABEL(YES) COLSUFFIX(YES) INDVAR(YES)

* * *

* *

.c om

* ... IS THE DCLGEN COMMAND THAT MADE THE FOLLOWING STATEMENTS *

*

IB

M

M

A

IN

FR

A

M

ES

****************************************************************** EXEC SQL DECLARE EMPTAB10 TABLE ( NAME CHAR(10) ) END-EXEC. ****************************************************************** * COBOL DECLARATION FOR TABLE EMPTAB10 * ****************************************************************** 01 HV-REC. * ************************************************************* * NAME 10 HV-NAME PIC X(10). ****************************************************************** * INDICATOR VARIABLE STRUCTURE * ****************************************************************** 01 IEMPTAB10. 10 INDSTRUC PIC S9(4) USAGE COMP. ****************************************************************** * THE NUMBER OF COLUMNS DESCRIBED BY THIS DECLARATION IS 1 ******************************************************************

A MCMILLAN PRODUCT