File Retrieval

#### Search Results

Search

# File Retrieval

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

This document covers the following topics:

- File Retrieval Screen

- File-specific Retrieval Parameters

- File-specific Retrieval Functions

- Layout of File Lists

- Output Options for File Retrieval

- Output Options for File Retrieval - Continued

## File Retrieval Screen

The File Retrieval screen below is called with function code R and object code FI in a Predict main menu or with command `RETRIEVE FILE`.

        13:37:40             *****  P R E D I C T  *****             2007-05-31
        Plan  10                  - (FI) File Retrieval -                  Profile HNO

         Retrieval Type                           Retrieval Type

         D  Files                                 B  Files with parents
         E  Execute retrieval models              O  Files with no parent
         C  Dummy/Placeholder files               T  Files with children
         A  Difference of files                   U  Files with no child
                                                  R  Files related to a file

        Retrieval type ...
        Output mode .....* L List

        File ID ..........                                  Files of type ....*
        Contained in DA ..                                  File number .......
        External name ....
        Restrictions ....*   Profile HNO,used               Model ............*
        Output options ..*   Profile HNO                    Association ......* EL

        Command ===>
        Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
              Help  Next  Stop  Last  LnkEl Flip  Print Impl  AdmFi SelFi Prof  Main

## File-specific Retrieval Parameters

Parameters
Contained in DA | Restricts the scope of functions to files and userviews contained in the specified database.
Files of type | Restricts the scope of functions to files of the type specified. An asterisk displays a selection window with the valid file types. See File Type for a list.
File number | Restricts the scope of functions to files with this number.
External name | Name of the physical implementation (DSN, Table names). Can have up to 250 characters, but only the first 50 are evaluated by Predict retrieval functions.

## File-specific Retrieval Functions

### Difference of Files - Code A

This function compares files and displays the differences. The file attributes, the fields and the field attributes can be compared. The fields are compared using the field ID. If a userview is compared with its master file, however, the fields are compared by two-character Short name. The userview is always taken as first file, irrespective of which file is entered under First File ID.

A screen appears for entering the names of two files and selecting the attributes to be compared.

Command: `DIFFERENCE FILE`.

        13:45:50             *****  P R E D I C T  *****             2007-05-31
        Plan  10                   - Difference of Files -

        First File ID ..... HNO-FI1
        Second File ID ....

        Options
          List Fields .................* D Differences only
          Compare File attributes ...... N (Y,N)

        Mark Field attributes which should be compared.
          X  the order                X  the existence
          X  abstract                 X  owner IDs              X  keywords
          X  description              X  Field name synonyms    X  standard File
          X  verifications            X  Adabas attributes      X  Field definition
          X  Natural attributes       X  specification for 3GL  X  VSAM attributes

        Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
              Help  Next  Stop  Last  LnkEl Flip  Print Impl  AdmFi SelFi Prof  Main

Parameters
First file ID, Second file ID | The names of the files to be compared. Asterisk notation can be used to compare one file with many files or two sets of files.
Options
List fields |
Determines how the result of the comparison operation is to be displayed:
A | all fields are listed and differences are marked
D | only fields with differences are listed
N | a message indicates if differences were found.
Compare file attributes |
Y | File definitions are to be compared.
Field attributes to be compared
the order | Differences in the order of fields in a file. Note The system checks for each field in the list whether the previous field of file 1 is identical to the previous field of file 2. Redefinitions are ignored in the check for previous field. In the example below, EL1 is regarded as previous field of EL2 for both files
       FIRST_FILE               SECOND_FILE
         ------------------       ---------------------
         Ty L Field ID            Ty L Field ID
         ------------             ------------
            1 EL_1                   1 EL_1
         RE 1 EL_1                RE 1 EL_1
            2 EL_11                  2 EL_12
            2 EL_12                  2 EL_11
            1 EL_2                   1 EL_2
However, the difference in the order of the redefinitions is recognized and the message "Redefinitions are different" is given.
the existence | A message is issued if a field exists only in one file.
abstract | Abstract of fields.
owner IDs | Owners of fields.
keywords | Keywords of fields.
description | The description of fields.
Field name synonyms | Field-name-synonyms, language-synonym-names.
Standard file | Standard file, non-standard definition.
Verifications | Verifications linked to fields.
Adabas attributes | Security access level, security update level.
Field definition | Descriptor type, level number, field format, character set, field length, field type, max. occurrences, unique option, suppression option, user exit, Adabas EDIT mask, IMS offset, IMS variable field, DB2 field procedure, DB2 field parameter, DB2 master file, DB2 master field, DB2 index cluster, DB2 index subpage, DB2 index bufferpool.
Natural attributes | Edit mask, field headings.
specification for 3GL | Init value, justify, condition names, index name, depend name, Gr. structure.
VSAM attributes | Alternate index name, VSAM flags.

Note
This command can also be performed in batch mode. See the section Predict Commands in the Predict Reference documentation for a list of keywords and parameters. These keywords are not available online.

### Files Related to a File - Code R

Certain files are considered to be logically related. For example, Adabas files and userviews; VSAM files and VSAM userviews; logical VSAM files and their userviews. This function displays the following relationships of files:

- master files with their userviews

- userviews with their master files and other userviews of these master files.

For physical VSAM files also the related logical VSAM files are listed, for IMS segments also the IMS segment layouts.

Command: `RELATED FILE`.

## Layout of File Lists

       13:46:22             *****  P R E D I C T  *****             2007-05-31
                                       - List Files -                      Page:    1

        Cnt  File ID                            Type   Fnr    DDM Impl Other

           1 A                                    S
           2 * A-ADDR-File                        A     59         A
           3 * A-ANSP-File                        A     84         A
           4 A-File                               A      1
           5 A-U-File                             U      1
           6 Az-a-File                            A     54
           7 AA-TD                                D
           8 AA-TS                                S

Meaning of Columns
File ID | ID of the file definition.
Type | File types and their codes are listed in the section File Type .
Fnr | The physical file number. Only applicable for Adabas files.
DDM | An asterisk in this column indicates either that a Natural data definition module has been generated for the file or that the file has been used by either Adabas Native SQL or the Predict Preprocessor.
Impl |
How a file is implemented:
A | The file has been loaded into Adabas
C | ADACMP definitions have been generated for the file
D | The file has been implemented in DB2
U | UDFs have been generated for the file (IMS)
S | Vista translation table generated
Other | An asterisk in this column indicates that at least one copy code member for Assembler, C, COBOL, FORTRAN or PL/I or at least one ADAINV or ADASCR card member has been generated for the file.

## Output Options for File 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 attributes | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  |  |
Association attributes |  |  | Y | Y | Y | Y |  |  | Y | Y | Y | Y |  |  |  |
Attributes | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  |  |
Check expression | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  |  |
Composed Fields |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  |
Connecting character |  |  |  | Y |  |  |  |  |  | Y |  |  |  |  |  |
Description | Y |  | Y | Y |  |  | Y |  | Y | Y |  |  | Y |  |  |
Display length |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  |
Display modifier | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  |  |
Dummy/Placeholder |  |  |  |  |  |  |  |  |  | Y |  | Y |  | Y |  | Y
DV-Field expression |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |
Extract | Y |  | Y | Y |  |  | Y |  | Y | Y |  |  | Y | Y |  |
Generation layout |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  |
Adabas version |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  |
Language |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  |
Alignment/sync. |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  |
Position/Offset |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  |
Counter length |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  |
Compiler |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  |
Replace with syn. |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  |
Keywords | Y |  | Y | Y |  |  | Y |  | Y | Y |  |  | Y |  |  |
Linked Verification |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |
Mark implementation | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |  | Y |
No. abstract lines | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |  | Y |
Owner | Y |  | Y | Y |  |  | Y |  | Y | Y |  |  | Y |  |  |
With users | Y |  | Y | Y |  |  | Y |  | Y | Y |  |  | Y |  |  |
Show implementation | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  |  |
Subquery | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  |  |
Synonyms |  |  |  |  |  |  |  |  |  | Y |  | Y |  |  |  |
Trigger | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  |  |
Use Con-form | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  |  |
User exit | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  |  |
Vista elements | Y |  | Y |  |  |  | Y |  | Y |  |  |  | Y |  |  |
3GL specification |  |  |  |  |  |  |  |  |  | Y |  |  |  |  |  |

## Output Options for File Retrieval - Continued

Retrieval Type | U | E | C | R
--- | --- | --- | --- | ---
Output Mode | D | L | T | X | L | D | L
Current/Related | c | c | c | r | c | r | c | r | c | r | c | r
Adabas attributes | Y |  |  |  |  |  |  |  |  |  |  |
Association attributes |  |  | Y | Y |  |  |  |  |  |  |  |
Attributes | Y |  |  | Y |  | Y |  |  |  |  |  |
Check expression | Y |  |  |  |  |  |  |  |  |  |  |
Composed Fields |  |  |  |  |  |  |  |  |  |  |  |
Connecting character |  |  |  | Y |  | Y |  |  |  | Y |  |
Description | Y |  |  |  |  | Y |  |  |  | Y |  |
Display length |  |  |  |  |  |  |  |  |  |  |  |
Display modifier | Y |  |  |  |  |  |  |  |  |  |  |
Dummy/Placeholder |  |  |  | Y |  | Y | Y |  | Y |  |  |
DV-Field expression |  |  |  |  |  |  |  |  |  |  |  |
Extract | Y |  |  | Y |  | Y |  |  | Y | Y |  |
Generation layout |  |  |  |  |  |  |  |  |  |  |  |
Adabas version |  |  |  |  |  |  |  |  |  |  |  |
Language |  |  |  |  |  |  |  |  |  |  |  |
Alignment/sync. |  |  |  |  |  |  |  |  |  |  |  |
Position/Offset |  |  |  |  |  |  |  |  |  |  |  |
Counter length |  |  |  |  |  |  |  |  |  |  |  |
Compiler |  |  |  |  |  |  |  |  |  |  |  |
Replace with syn. |  |  |  |  |  |  |  |  |  |  |  |
Keywords | Y |  |  | Y |  | Y |  |  |  | Y |  |
Linked Verification |  |  |  |  |  |  |  |  |  |  |  |
Mark implementation | Y | Y | Y | Y | Y | Y |  | Y |  | Y | Y | Y
No. abstract lines | Y | Y |  | Y |  | Y |  | Y |  | Y | Y | Y
Owner | Y |  |  | Y |  | Y |  |  |  | Y |  |
With users | Y |  |  |  |  |  |  |  |  | Y |  |
Show implementation | Y |  |  |  |  |  |  |  |  |  |  |
Subquery | Y |  |  |  |  |  |  |  |  |  |  |
Synonyms |  |  |  |  |  |  |  |  |  |  |  |
Trigger | Y |  |  |  |  |  |  |  |  |  |  |
Use Con-form | Y |  |  |  |  | Y |  |  |  | Y |  |
User exit | Y |  |  |  |  |  |  |  |  |  |  |
Vista elements | Y |  |  |  |  |  |  |  |  |  |  |
3GL specification |  |  |  |  |  |  |  |  |  |  |  |

### On this page

- File Retrieval Screen
- File-specific Retrieval Parameters
- File-specific Retrieval Functions
- Layout of File Lists
- Output Options for File Retrieval
- Output Options for File Retrieval - Continued