db2 import-help!

[siva]

dear sir

i face problem during importing in db2 udb 8.1.The export is successfull
but while importing i got the following error

connect to sample
export to myfile.ixf of ixf messages msgs.txt select * from staff
number of rows exported:35

connect to luse
import from myfile.ixf of ixf messages msgi.txt insert into staff
SQL3304N the table does not exists

and i used GUI tools also....my question is it is necessary to create the
table prior with the exact structure of the exported table and only datas
can be imported from the exported file?does db2 does not create the table
on its own while importing into a database like sqlserver or oracle.experts
kindly help me and give your valuable guidance.

thank you
siva!

[Greg Nash]

Hi,

There are a few different options with the import command. You have
used "insert into", which means insert the records into an existing
table. There is also "replace into" which means remove all existing
records prior to inserting. The one you're looking for is (I think)
"create into".

--greg

siva wrote:
> dear sir
>
> i face problem during importing in db2 udb 8.1.The export is successfull
> but while importing i got the following error
>
> connect to sample
> export to myfile.ixf of ixf messages msgs.txt select * from staff
> number of rows exported:35
>
> connect to luse
> import from myfile.ixf of ixf messages msgi.txt insert into staff
> SQL3304N the table does not exists
>
> and i used GUI tools also....my question is it is necessary to create the
> table prior with the exact structure of the exported table and only datas
> can be imported from the exported file?does db2 does not create the table
> on its own while importing into a database like sqlserver or oracle.experts
> kindly help me and give your valuable guidance.
>
> thank you
> siva!
>
>
>

[siva]

hi greg

thanks...yes "create into" worked for me.

NO WAR!
siva!