Reserved Keywords

You cannot use reserved keywords for the relational database object (table, column, index, etc.) names. For example, the word order is an SQL keyword; therefore, you cannot rename a relational database table or column as order.

If an existing DMSII data set is named ORDER, the DATABridge Client stores ORDER in the DATASETS client control table and an equivalent relational database table called "order_x" in the DATATABLES client control table. This same convention of adding _x to rename a reserved word applies to DMSII data items. For information on which words are reserved by your relational database, see the related database documentation.