Progress
DataServer
for ORACLE Guide


Naming Conventions

One factor to consider when planning for maximum compatibility across Progress and ORACLE is the kind of restrictions each has for naming tables and fields.

Field and Column Names

These are the restrictions for naming Progress fields and ORACLE columns:

The set of characters that Progress allows includes all of the characters ORACLE allows. The Progress-to-ORACLE utility replaces characters that ORACLE does not accept with the underscore ( _ ). For example, the Progress cust-num field maps to the CUST_NUM column in ORACLE.

Table Names

There can be more than one ORACLE table (or view) with the same name within a database, because ORACLE qualifies tables by owner as well as by name. Progress requires unique table names.

Progress resolves non-unique table names for you. When Progress encounters matching table names while creating or updating a schema image, for the second and subsequent occurrence of a table name, it names the corresponding ORACLE table table-1, table-2, etc. For example, if Progress encounters a second instance of a table named employee in the ORACLE database, it names the corresponding schema-holder table employee-1. The Table Properties Sheet in the Data Dictionary has a DataServer option that shows you which ORACLE table mapped to the schema-holder table.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095