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.