Hi, I am using db2 V9.5 on windows. From the control center I exported a table in the IXF format using the GUI screens for export. The import of that table works fine when using the GUI, but when I try to import using CLI, it gives the following error. The sql for the import is the very same which is shown when we import using the GUI.
Where am I going wrong??
Quote:
db2 IMPORT FROM "C:\SPs\met_table_export" OF
IXF MESSAGES "xyz" CREATE INTO DB2ADMIN.metadata;
SQL3035N The tablename parameter in the target specification is not valid.
|
Is it expecting the DB2ADMIN.metadata table to exist already??
dBforums
>
import table command error
08-12-09, 06:51
Linear Mode
