Folks,
Today, I was exporting a table in one database and then importing it in
another database. The table in destination database was missing one column
(my mistake while creating the table), but import did not complain about it.
Source table:
Column Type Type
name schema name Length Scale Nulls
---------------- --------- ------------------ -------- ----- -----
PROJECT_ID SYSIBM CHARACTER 14 0 No
DESCRIPTION SYSIBM CHARACTER 40 0 No
CONTRACT_ID SYSIBM CHARACTER 10 0 No
STATUS SYSIBM CHARACTER 10 0 No
ESTIMATE SYSIBM INTEGER 4 0 No
Export command:
db2 "export to project.ixf of ixf select * from project"
Destination table:
Column Type Type
name schema name Length Scale Nulls
---------------- --------- ------------------ -------- ----- -----
PROJECT_ID SYSIBM CHARACTER 14 0 No
DESCRIPTION SYSIBM CHARACTER 40 0 No
CONTRACT_ID SYSIBM CHARACTER 10 0 No
STATUS SYSIBM CHARACTER 10 0 No
Import command:
db2 "import from project.ixf of ixf replace into project"
Why does Import command not display error or warning about missing column.
--
Hemant Shah /"\ ASCII ribbon campaign
E-mail:
No************@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.