Naming Columns

Lawson products use the hyphen (-) to separate words in column names (for example, MONTH-PTS). Oracle does not allow hyphens, so the database driver automatically replaces the hyphens with underscores when it communicates with the database. For example, the column MONTH-PTS changes to MONTH_PTS.

Reserved Words

Oracle reserves some words that cannot be used for table, column, or index names. Lawson products do not have this restriction. To avoid problems between the two naming conventions, the database driver prefixes R_ to table, column, and index names that are reserved by Oracle. For example, if a table has a column called VALUES, the database driver changes the name to R_VALUES for the Oracle server. For a complete list of reserved words, see the Oracle Guide to SQL.