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