Sybase

Sybase tables and views can be documented in Predict with file objects of type YT and YV respectively. These file objects can be used to generate DDMs or CREATE TABLE/VIEW statements.

This document covers the following topics:

Naming Conventions

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

  • A fully qualified ID (Creator + Hyphen + Table/View name) must not exceed 32 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.

Sybase Table, File Type YT

    13:18:12             *****  P R E D I C T  *****             2007-05-31
                                    - Add a file -
    File ID ......... HNO-YT
    Type ............ Sybase table
    Contained in DA .
    Keys ..                                                                Zoom: N
   
    Literal name ....
    Average count ...
    Stability ......*   Not specified
    Database name ...
    Segment 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

ID of the Predict object documenting the Sybase table.

See Naming Conventions for Sybase objects.

Contained in DA

ID of the database object containing the file.

To generate a DDM from files of type Sybase table, the file must be linked to a database of type Sybase Handler.

Database name Name of the database in Sybase containing the table.
Segment name Name of the segment where the table is to be placed

Sybase View, File Type YV

    13:19:57             *****  P R E D I C T  *****             2007-05-31
                                    - Add a file -
    File ID ......... HNO-YV
    Type ............ Sybase 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 Sybase table.

See Naming Conventions for Sybase objects.

Contained in DA

ID of the database object containing the file.

To generate a DDM from files of type Sybase table, the file must be linked to a database of type Sybase Handler.