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:
The following naming conventions apply to files documenting Ingres tables and views.
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.
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.
See overview of permitted characters in Naming Conventions.
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 |
|
||||
Duplicated |
|
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. |