Naming Columns
Lawson products use the hyphen (-) to separate words in column names
(for example, MONTH-PTS). IBM DB2 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
IBM DB2 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 IBM DB2. For example,
if a table has a column called VALUES, the database driver
changes the name to R_VALUES for the IBM DB2 server. For
a complete list of reserved words, see the IBM DB2 Guide
to SQL.