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.

Table 5–7: Progress-to-ORACLE Naming Conventions
Progress Field
ORACLE Column Name
Record ID
PROGRESS_RECID
Case-insensitive index
(for example, cust-num)
U##column-name
(U##cust_num)
Array with three elements
(for example, MONTH)
field##1, field##2, field##3
(MONTH##1, MONTH##2, MONTH##3)
Sequence
sequence-name
(NEXT_CUST_NUM)

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