Previous Page | Next Page

SAS/ACCESS Interface to DB2 Under UNIX and PC Hosts

Naming Conventions for DB2 Under UNIX and PC Hosts

For general information about this feature, see SAS Names and Support for DBMS Names.

The PRESERVE_TAB_NAMES= and PRESERVE_COL_NAMES= options determine how SAS/ACCESS Interface to DB2 under UNIX and PC Hosts handles case sensitivity, spaces, and special characters. (For information about these options, see Overview of the LIBNAME Statement for Relational Databases.) DB2 is not case sensitive and all names default to uppercase.

DB2 objects include tables, views, columns, and indexes. They follow these naming conventions.

Schema and database names have similar conventions, except that they are each limited to 30 and 8 characters respectively. For more information, see your DB2 SQL reference documentation.

Previous Page | Next Page | Top of Page