Issuing Db2 Commands from Natural

#### Search Results

Search

# Issuing Db2 Commands from Natural

The Db2 Command part of the Natural Tools for Db2 enables you to issue Db2 commands from a Natural environment.

A file is maintained for each user on the system file `FUSER`. This file is stored under the object name `DB2$CMD` in the Natural library of the current user.

You can select a command and submit it, save the command file and save and/or print the output report.

This section covers the following topics:

- Invoking the Db2 Command Part

- Displaying the Command File

- Displaying the Output Report

## Invoking the Db2 Command Part

To invoke the Interactive SQL function

- On the Natural Tools for Db2 Main Menu, enter function code `D` and press ENTER.

  The Execute Db2 Command screen is displayed:

         16:07:56              ***** NATURAL TOOLS FOR DB2 *****            2009-10-30
                                    - Execute DB2 Command -

                                Code   Function

                                  C    Display Commands
                                  O    Display Output
                                  ?    Help
                                  .    Exit

                          Code .. _    Library .. DBA_____

        Command ===>
        Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
              Help        Exit                                                  Canc

  The following functions are available:

  Code | Description
  --- | ---
  `C` | Displays your command file. If you have not saved a command file yet, a default file is displayed.
  `O` | If an output file exists, the output report is displayed.

  The following parameter can be specified:

  Parameter | Description
  --- | ---
  `Library` | You can enter a user name or library. The default is the currrent user ID.

## Displaying the Command File

To display the command file

- On the Execute DB2 Command menu, enter function code `C` and press ENTER.

  The DB2 Commands screen is displayed:

        16:12:11              ***** NATURAL TOOLS FOR DB2 *****            2009-10-30
                                       - DB2 Commands -

          Mark the line of the command you want to execute with 'S' and press PF4

          Cmd 1    _    -DISPLAY THREAD (*).........................................
          Cmd 2    _    -DISPLAY LOCATION...........................................
          Cmd 3    _    -DISPLAY DATABASE(*) LIMIT(2500)............................
                        ............................................................
          Cmd 4    _    -DISPLAY PROCEDURE (*)......................................
                        ............................................................
          Cmd 5    _    -DISPLAY DATABASE(DSNDB04) LIMIT (*)........................
                        ............................................................
          Cmd 6    _    ............................................................
                        ............................................................
          Cmd 7    _    ............................................................
                        ............................................................
          Cmd 8    _    ............................................................
                        ............................................................
                        ............................................................

        Command ===>
        Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
                          Exit  Subm  Save                                Next  Canc

  Use PF11 (Next) to scroll to the next page.

  You can modify the command file. Save your modifications with PF5 (Save).

To execute a command

- Mark the command with an `S` and press PF4 (Subm).

  The results are displayed on the DB2 Commands Output screen:

        16:13:23              ***** NATURAL TOOLS FOR DB2 *****           2009-10-30
                                    - DB2 Commands Output -

          Command:           -DISPLAY DATABASE(DSNDB04) LIMIT (*)
          Return Code 1:     00000000          Return Code 2:   00000000
          Length of Output:  00001AFB

          DSNT360I - ***********************************
          DSNT361I - *  DISPLAY DATABASE SUMMARY
                     *    GLOBAL
          DSNT360I - ***********************************
          DSNT362I -     DATABASE = DSNDB04  STATUS = RW
                         DBD LENGTH = 72674
          DSNT397I -
          NAME     TYPE PART STATUS             PHYERRLO PHYERRHI CATALOG  PIECE
          -------- ---- ---- ------------------ -------- -------- -------- -----
          ADRESSE  TS        RW
          ALIASRBY TS        RW
          ALLDATA0 TS        RW

        Command ===>
        Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
                          Exit        Save  --    -     +     ++                Canc

To save the command file

1. Press PF5 (Save).

   The output file is stored under the object name `DB2$OUT` in the Natural library of the current user.

2. Press PF3 (Exit) to return to the command file.

   You can submit further commands.

## Displaying the Output Report

To display the last output record

- On the Execute DB2 Command menu, enter function code `O` and press ENTER.

  The DB2 Commands Output screen is displayed:

        16:13:57              ***** NATURAL TOOLS FOR DB2 *****           2009-10-30
                                    - DB2 Commands Output -

          Command:           -DISPLAY DATABASE(*) LIMIT(2500)
          Return Code 1:     00000000          Return Code 2:   00000000
          Length of Output:  00007468

          DSNT360I - ***********************************
          DSNT361I - *  DISPLAY DATABASE SUMMARY       *
                     *    GLOBAL                       *
          DSNT360I - ***********************************
          DSNT362I -     DATABASE = DSNDB01  STATUS = RW
                         DBD LENGTH = 8000
          DSNT397I -
          NAME     TYPE PART STATUS             PHYERRLO PHYERRHI CATALOG  PIECE
          -------- ---- ---- ------------------ -------- -------- -------- -----
          DBD01    TS        RW
          SPT01    TS        RW
          SCT02    TS        RW

        Command ===>
        Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
                          Exit        Print --    -     +     ++                Canc

  To print the output record, press PF5 (Print).

### On this page

- Invoking the Db2 Command Part
- Displaying the Command File
- Displaying the Output Report