Database Retrieval

#### Search Results

Search

# Database Retrieval

Retrieval functions applying to database objects are called from the Database Retrieval menu that is called with the command `RETRIEVE DATABASE` or with function code R and object type code DA in a Predict main menu.

This document covers the following topics:

- Database-Specific Retrieval Parameters

- Database-Specific Retrieval Functions

- Layout of Database Lists

- Output Options for Database Retrieval

Note
Standard retrieval functions are described in the section Retrieval in the Predict Reference documentation.

## Database-Specific Retrieval Parameters

Parameters
Database of type | Limits the scope of the function to databases of a certain type. Enter an asterisk to display possible values at your site or see complete list of database types in the section Database Maintenance Menu.
Database number | Limits the scope of the function to databases with the number specified.

## Database-Specific Retrieval Functions

### Explode IMS Database - Code I

Shows the hierarchical structure of an IMS/DL/I database. The level number before the file ID shows the level of the IMS/DL/I segment in the hierarchy. This function is only applicable to databases of type I. Command: `EXPLODE DATABASE`.

### Databases with children - with Association Type Contains FI and Output Option Adabas size=Y

The following output is produced with function Display databases with children if you specify association type "Contains FI" and output option Adabas size=Y for databases and files of type Adabas.

       13:13:02             *****  P R E D I C T  *****         2007-05-31
                            - Display Database with Children -

       Database ID ........ DA-WITH-FILE
       Type ............... Adabas, Isolated      Added 2007-05-31 at 10:25 by ARH
       Physical DBnr ...... 57                 Modified 2007-05-31 at 10:42 by ARH

    ---------------------------------------------------------------------------
       Adabas attributes                     Natural file numbers
         Maximal files ........                System file (FNAT) ...
         Checkpoint file ......                NAT-Security (FSEC) ..
         Adabas security ......                Predict (FDIC) .......
         Size of RABN ......... 0
         Distr. transaction ... N No
         Vista access only .... N

                    --------------- Database primary sizes ---------------
                                 Number of               Alternate RABN
                 Device    Cylinder     RABN             Start     End
       ASSO R1    3390       15           4032             1200      3200
       ASSO R2    3390       14           3780             2000      3760
       DATA R1    3380       12           1611
       DATA R2    3380       13           1755

       Cnt  File ID                            Type   Fnr    DDM Impl Other

          1 FI-A-001                            A     123
          2 FI-A-002                            A     124

       ------------------------------- Summary of sizes---------------------------

       Type  Device   No. of RABN    Min. RABN  Undoc. RABN
       ASSO   3390           7812         1942         5870
       DATA   3380           3366         1205         2161

        *** End of report ***

The total ASSO and DATA sizes defined for the database are calculated and displayed in column Summary of sizes/No. of RABN.

The sum of the sizes of ASSO and DATA for the individual related files is calculated and displayed in column Min. RABN.

The number of available RABNs is displayed in the column Undoc. RABN, or a message is given indicating that the sizes of the files exceed the size available in the parent database.

The system also checks whether the devices specified for the files are also specified for the parent database.

## Layout of Database Lists

The following list format applies when retrieving information on databases with output mode List.

     13:37:03             *****  P R E D I C T  *****                2007-05-31
                                  - List Database -
     -----------------------------------------------------------------------------------
     Cnt  Database ID                           Type                P-DBnr Run Mode

       15 ARH-X                                 Informix Handler        24 Local
       16 ARH-Y1                                Sybase Handler          22 Local
       17 * ARTICLE                             IMS
       18 AZ-PREDICT                            Adabas                  66 Isolated
       19 AZ-SAGPRD                             DB2

     *** End of report ***

Meaning of Columns
Database ID | ID of the database object. If the output option Mark implementation is set to Y, implemented objects are marked with an asterisk. For databases, "implemented" means that it is one of the following: of type A and connected to a physical Adabas database, of type D and connected to a physical DB2 database of type P and its database number is defined in the NTDB macro as an Entire System Server database, or of type I.
Type | The database type. See Database Maintenance Menu.
P-DBnr | The physical number of the database.
Vista Parm | Accessibility of Adabas databases using Adabas Vista. Possible values are listed in the section Defining Basic Attributes of Databases.

## Output Options for Database Retrieval

Notes:

1. Unless output mode is S, the option Cover page is always valid.
2. Page size is only applicable when printing or if general default parameter Use SAG Editor for output is set to Y. Page size is not applicable in batch mode.

Retrieval type | D | B | O | T
--- | --- | --- | --- | ---
dummies=Y|N | dummies=D|P
Output Mode | D | L | D | L | D | L | D | L | D | L
Current/Related | c | c | c | r | c | r | c | c | c | r | c | r | c | r | c | r
Adabas sizes | x |  | x |  |  |  | x |  | x |  |  |  | x |  |  |
Association attributes |  |  | x | x | x | x |  |  | x | x | x | x |  |  |  |
Attributes | x |  | x |  |  |  | x |  | x |  |  |  | x |  |  |
Connecting character |  |  |  | x |  |  |  |  |  |  | x |  |  |  |  |
Description | x |  | x | x |  |  | x |  | x | x |  |  | x |  |  |
Display modifier | x |  | x |  |  |  | x |  | x |  |  |  | x |  |  |
Dummy/Placeholder |  |  |  |  |  |  |  |  |  | x |  | x |  | x |  | x
Extract | x |  | x | x |  |  | x |  | x | x |  |  | x | x |  |
Keywords | x |  | x | x |  |  | x |  | x | x |  |  | x |  |  |
Mark implementation | x | x | x | x | x | x | x | x | x | x | x | x | x |  | x |
No. abstract lines | x | x | x | x | x | x | x | x | x | x | x | x | x |  | x |
Owner | x |  | x | x |  |  | x |  | x | x |  |  | x |  |  |
With users | x |  | x | x |  |  | x |  | x | x |  |  | x |  |  |
Show implementation | x |  | x |  |  |  | x |  | x |  |  |  | x |  |  |
Use Con-form | x |  | x | x |  |  | x |  | x | x |  |  | x |  |  |
User exit | x |  | x |  |  |  | x |  | x |  |  |  | x |  |  |

Retrieval Type | U | E | C | I
--- | --- | --- | --- | ---
Output Mode | D | L | T | X | L | D | T
Current/Related | c | c | c | r | c | r | c | r | c | r | c | r
Adabas sizes | x |  |  |  |  |  |  |  |  |  |  |
Association attributes |  |  | x | x |  |  |  |  |  |  |  |
Attributes | x |  |  | x |  | x |  |  |  |  |  |
Connecting character |  |  |  | x |  | x |  |  |  | x |  |
Description | x |  |  |  |  | x |  |  |  | x |  |
Display modifier | x |  |  |  |  |  |  |  |  |  |  |
Dummy/Placeholder |  |  |  | x |  | x | x |  | x |  |  |
Extract | x |  |  | x |  | x |  |  | x | x |  |
Keywords | x |  |  | x |  | x |  |  |  | x |  |
Mark implementation | x | x | x | x | x | x |  | x |  | x | x | x
No. abstract lines | x | x |  | x |  | x |  | x |  | x |  | x
Owner | x |  |  | x |  | x |  |  |  | x |  |
With users | x |  |  |  |  |  |  |  |  | x |  |
Show implementation | x |  |  |  |  |  |  |  |  |  |  |
Use Con-form | x |  |  |  |  | x |  |  |  | x |  |
User exit | x |  |  |  |  |  |  |  |  |  |  |

### On this page

- Database-Specific Retrieval Parameters
- Database-Specific Retrieval Functions
- Layout of Database Lists
- Output Options for Database Retrieval