dbimport error

[Guest_imported]

Hi,
I exported the informix database.
Then, I executed dbimport command on unix prompt as follows:
dbimport dbname -d dbservername -i dbname.exp
It says...
"Cannot open sql script file"

Then i tried giving the name and path of the script file...as:
dbimport dbname -d dbservername -i dbname.exp -f <path>/dbname.sql
It says...
&quot;Can not write data to disk and tape at the same time&quot;

Is there any problem with the command /arguments.
Pls reply..its urgent!

Regards,
Albert
mailto: trin_trin@rediffmail.com

 

[olded]

Albert:

The problem is you're giving the full path the sql file where you should be giving it to the parent directory where the export resides.

If database dbname.exp exists in /usr/tmp, change the above to:

dbimport dbname -d dbservername -i /usr/tmp

The -f switch is not needed if you follow the above.

regards,

Ed
Schaefer