SQL Operations Guide

Previous Topic

Next Topic

Check for Invalid Characters in Field Names

The -k switch allows one to skip importing fields that do not comply with the conventional identifier rules without being prompted every time an incompatible field is encountered.

ctsqlimp also has a “non-interactive” option (-i) which avoids prompting the user by having a list of pre-defined default answers. The actions taken by default are the most conservative and safe. In case an unconventional field is encountered, the default action is to import the field and inform the user that in FairCom DB SQL statements, the resulting column name must be enclosed in double quotation marks.

The option -k can be used in conjunction with the -i option to change the default behavior in case an unconventional field is encountered and automatically skip it.