Field and column names

These are the restrictions for naming OpenEdge fields and Oracle columns:

  • OpenEdge — Field names can be up to 32 characters long and can consist of alphabetic characters (A-Z and a-z), digits (0-9), and the special characters $, &, #, %, -, and _. A field name must begin with an alphabetic character.
  • Oracle — Column names can be up to 30 characters long. They can consist of the same characters as OpenEdge names, except % and -.

The set of characters that OpenEdge allows includes all of the characters Oracle allows. The OpenEdge DB-to-Oracle utility replaces characters that Oracle does not accept with the underscore ( _ ). For example, the OpenEdge custnum field maps to the CUST_NUM column in Oracle.