Access Database Functions

You can access database functions by requesting to create, alter, template, or drop a database.
carcudb2
You can access database functions by requesting to create, alter, template, or drop a database.
To access database functions, do one of the following:
  • Type
    C
    in the Option field and type
    DB
    in the Object field of the main header, then press Enter to create a database.
  • Type
    A
    ,
    T
    , or
    D
    , respectively, in the Option field and type
    DB
    in the Object field of the main header, then press Enter to alter, template, or drop a database.
    You can enter a database name in the Item Name field and a user ID in the Creator field to get a more specific selection list.
Selection Panels
When altering, dropping, or creating (by template) a view, a selection panel is presented to select the view if not already specified. Make the view selection list more specific by specifying selection criteria for the Item (view) Name and Creator ID prompts in the header.
Use the EQF facility to further specify the views displayed, and use scrolling commands to scroll through information. 
The View Selection screen displays all the fields available in the SYSIBM.SYSTABLES table. This information is available to make selection of the views easier.
To choose items from the listing, type 
next to the items to select. Press Enter to register the selection. For information about the fields, press F1 (Help).
Commands
The HEADER and COMPARE commands can make working with databases easier as follows:
  • HEADER
    Toggles the header on and off. This is helpful when viewing a long list of databases. Enter 
    or 
    HEADER 
    in the command line to toggle the header.
  • COMPARE
    Displays old and new versions of the database for comparison. This can be useful when you are templating or altering a database. Use the RESET command to reset a changed attributes to their original status.