Informix

#### Search Results

Search

# Informix

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

This document covers the following topics:

- Naming Conventions for Informix

- Informix Table, File Type XT

- Informix View, File Type XV

## Naming Conventions for Informix

The following naming conventions apply to files documenting Informix 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 Informix 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 Informix objects can have up to 18 characters.

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

### Permitted characters

- IDs containing special characters must be enclosed in double quotes, for example:

      "USR1"-"FIL£ABC"

- See overview of permitted characters in Naming Conventions.

## Informix Table, File Type XT

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

        Literal name ....
        Average count ...
        Stability ......*   Not specified
        Informix ONLINE .   (Y/N)
        Extensize .......
        Nextsize ........
        Lock mode ......*
        DBspace/Path.
        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 Informix table. See Naming Conventions for Informix objects.
Contained in DA | ID of the database object containing the file. To generate a DDM from files of type Informix table, the file must be linked to a database of type Informix Handler.
Informix ONLINE |
Y | An Informix ONLINE database is used.
Note The following parameters are only applicable if Informix ONLINE is set to Y.
Extentsize | Size of the initial extent for the table and its key.
Nextsize | Size of subsequent extents which are added if necessary.
Lock mode |
Determines whether locking is set to page level or row level.
P | Page level locking.
R | Row level locking.
DBspace/Path | Name of the DBspace where Informix ONLINE is to store the table. If this parameter is not specified, the table is stored in the DBspace of the database entered under in database.

## Informix View, File Type XV

        13:13:37             *****  P R E D I C T  *****             2007-05-31
                                       - Add a file -
        File ID ......... HNO-XV
        Type ............ Informix 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 Informix view. See Naming Conventions for Informix objects.
Contained in DA | ID of the database object containing the file. To generate a DDM from files of type Informix view, the file must be linked to a database of type Informix Handler.

### On this page

- Naming Conventions for Informix
- Informix Table, File Type XT
- Informix View, File Type XV