Progress
DataServer
for ORACLE Guide
Naming Conventions
The Progress-to-ORACLE utility generates names for the columns it adds to an ORACLE table. These names follow the conventions described in Table 5–7.
For example, if your source Progress table includes a field extent named MONTH with 12 elements, the Progress-to-ORACLE utility creates 12 columns of the same data type named MONTH##1, MONTH##2, MONTH##3, etc. A Progress 4GL reference to MONTH[3] translates into a reference to the ORACLE column MONTH##3.
In addition, the Progress-to-ORACLE utility modifies the names of Progress objects to non-ORACLE keywords in the ORACLE schema. For example, ORDER is a reserved word in ORACLE, so the utility changes the Order field of the Progress demo database to the Order_ column in an ORACLE database. It also modifies names that might conflict with unrolled field extents and that contain characters unacceptable to ORACLE. The Progress field name Order-line changes to Order_line to account for the fact that the hyphen (–) is an unacceptable character in ORACLE object names.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |