Adabas D

#### Search Results

Search

# Adabas D

Adabas D tables and views can be documented in Predict with file objects of type BT and BV respectively. These file objects can be used to generate DDMs or CREATE TABLE/VIEW statements.

This document covers the following topics:

- Naming Conventions for Adabas D

- Adabas D Table, File Type BT

- Adabas D View, File Type BV

## Naming Conventions for Adabas D

The following naming conventions apply to files documenting Adabas D tables and views.

### Upper / lower case

If the Predict parameter General Defaults > Miscellaneous > Upper/lower case / Object ID is set to L, the following attributes of Adabas D objects are stored in upper and lower case as entered:

- File ID (object IDs containing lower case letters are not recommended)

- Derived field expressions

- SQL verifications

- Check expressions

- Constraint names

See also section Defaults in the Predict Administration documentation.

### Length

- Table/View names for Adabas D objects can have up to 18 characters.

- A fully qualified ID (Creator + Hyphen + Table/View name) may not exceed 27 characters.

### Permitted characters

See overview of permitted characters in the section Naming Conventions.

## Adabas D Table, File Type BT

        13:49:52             *****  P R E D I C T  *****             2007-05-31
                                      - Modify file -
        File ID ......... HNO-BT                          Modified 2007-05-31 at 13:23
        Type ............ Adabas D table                        by HNO
        Contained in DA .
        Keys ..                                                                Zoom: N

        Literal name ...........
        Average count ..........
        Stability .............*   Not specified
        Check constraint name ..
        Abstract     Zoom: N

          Additional attributes ..* N          Associations ..* N

Note
Parameters not listed below are described in other sections of this documentation: Parameters common to all object types, for example Keys, are described under Global Attributes. Parameters common to all file types, for example Literal name, are described under Common File Attributes. See also Common Parameters for SQL File Types.

Parameters
File ID | See Naming Conventions for Adabas D objects.
Contained in DA | ID of the database object containing the file. To generate a DDM from files of type Adabas D table, the file must be linked to a database of type Adabas D handler.
Check constraint name | If a table check expression has been defined and the name of a check constraint is entered here, the following clause is generated in the `CREATE TABLE` statement:
    CONSTRAINT constraint_name
    CHECK (check_expression)

## Adabas D View, File Type BV

        13:36:40             *****  P R E D I C T  *****             2007-05-31
                                       - Add a file -
        File ID ......... HNO-BV
        Type ............ Adabas D view
        Contained in DA .
        Keys ..                                                                Zoom: N

        Literal name .............
        Average count ............
        Stability ...............*   Not specified
        SQL attributes
          Select ................* A
          With check option ...... N (Y/N)

        Abstract     Zoom: N

          Additional attributes ..* N          Associations ..* N

Note
Parameters not listed below are described in other sections of this documentation: Parameters common to all object types, for example Keys, are described under Global Attributes. Parameters common to all file types, for example Literal name, are described under Common File Attributes. See also Common Parameters for SQL File Types.

Parameters
File ID | See Naming Conventions for Adabas D objects.
Contained in DA | ID of the database object containing the file. To generate a DDM from files of type Adabas D view, the file must be linked to a database of type Adabas D handler.

### On this page

- Naming Conventions for Adabas D
- Adabas D Table, File Type BT
- Adabas D View, File Type BV