User`s guide

SQL Error Recognition During Ingres Database Imports
Ingres Exports Data Export User’s Guide
6-2 Version 5.0rev1
SQL Error Recognition During Ingres Database
Imports
When you export to Ingres, initially an export to ASCII is performed. Next, a
series of SQL commands is generated to create tables, copy data and add
indices. The commands are executed and a log of the execution is stored in
<deffile>_import.log (where <deffile> is the name of the definition
file). This log file is searched for errors. If any errors are found, they are placed
in the <deffile>.log file and the following message is displayed:
ÒIngres completed with possible errors detected. Examine
<deffile>_import.log file for actual errors.Ó
See Checking Export Output on Page 4-7 for more information.
Loading and Accessing Ingres Tables
Data Export uses the Ingres copy statement to load database tables. Refer to
your Ingres documentation for restrictions and recommendations about the
copy statement.
You should be aware of any restrictions imposed by the Ingres Database
Management System, such as reserved words and naming conventions. See
the appropriate Ingres manuals for information.