Ingres

#### Search Results

Search

# Ingres

Ingres tables and views can be documented in Predict with file objects of type JT and JV respectively. These file objects can be used to generate DDMs or `CREATE TABLE/VIEW` statements.

This document covers the following topics:

- Naming Conventions for Ingres

- Ingres Table, File Type JT

- Ingres View, File Type JV

## Naming Conventions for Ingres

The following naming conventions apply to files documenting Ingres 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 Ingres objects are stored in upper and lower case as entered:

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

- DV field expressions

- SQL verifications

- Check expressions

- Constraint names

See also section Defaults in the Predict Administration documentation.

### Length

- Table/View names for Ingres objects can have up to 24 characters.

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

### Permitted characters

See overview of permitted characters in Naming Conventions.

## Ingres Table, File Type JT

        13:13:01             *****  P R E D I C T  *****             2007-05-31
                                       - Modify file -
        File ID ......... HNO-JT                             Added 2007-05-31 at 10:28
        Type ............ Ingres table                          by HNO
        Contained in DA .
        Keys ..                                                                Zoom: N

        Literal name ......
        Average count .....
        Stability ........*   Not specified
        Journaling ........   (Y/N)
        Duplicated ........   (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 | ID of the Predict object documenting the Ingres table. See Naming Conventions for Ingres objects.
Contained in DA | ID of the database object containing the file. To generate a DDM from files of type Ingres table, the file must be linked to a database of type Ingres Handler.
Journaling |
Y | The clause `WITH JOURNALING` is entered in the `CREATE` statement.
N | The clause `WITH NO JOURNALING` is entered in the `CREATE` statement.
Duplicated |
Y | The clause `WITH DUPLICATES` is entered in the `CREATE` statement.
N | The clause `WITH NO DUPLICATES` is entered in the `CREATE` statement.

## Ingres View, File Type JV

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

        Literal name .............
        Average count ............
        Stability ...............*   Not specified
        SQL attributes
          Select ................* A Select all
          With check option ...... N No

        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 | ID of the Predict object documenting the Ingres view. See Naming Conventions for Ingres objects.
Contained in DA | ID of the database object containing the file. To generate a DDM from files of type Ingres view, the file must be linked to a database of type Ingres Handler.

### On this page

- Naming Conventions for Ingres
- Ingres Table, File Type JT
- Ingres View, File Type JV