Naming Conventions

When DB2 table and column names are defined using quotation marks, they may contain any characters including spaces and quotes. In addition, they are not case sensitive. The following examples will cause Scriptoria to rename DB2 columns when importing. The use of non-standard names should be avoided since front-end development environments dependent on ODBC will not operate properly.

DB2 Name	Assigned Access Name	Rename Reason
“Abc”	Abc
ABC	ABC1	Abc and ABC are duplicates since Access names are not case sensitive.
“ Leading Space”	Leading Space	Leading spaces are invalid in Access
“InvalidChars[!‘.]”	InvalidChars_____	The special characters shown are invalid in Access
“A very long table name exceeding sixty-four characters is truncated to a length of sixty-four”	A very long table name exceeding sixty-four characters is truncated	Name is longer than the maximum Access length of 64.

It is advisable to rename any DB2 columns that are not compatible with Access.