Newbie question : dbimport

On Thu, 18 Jan 2001 11:33:15 -0600, "abdel BIDAR" <abdel.bidar@marconi.com> wrote: >I made an export of the database and it worked fine but when I tried to do a >dbimport on a 2000 Database: >dbimport -i /export ext> >I have such a message : > >Create Database >330 Cannot create o rename database >100 ISAM error : Duplicate value for a record with a unique key > Don't know if that is the problem, but syntax is: dbimport database_name -i dbi_path where dbi_path is path to directory where directory database_name.exp exists. Nebojsa > >If someone can tell me Where can i find these message explain in Informix >documentation . >Which document I have to read ? > >

On Thu, 18 Jan 2001 11:33:15 -0600, "abdel BIDAR" <abdel.bidar@marconi.com> wrote: >I made an export of the database and it worked fine but when I tried to do a >dbimport on a 2000 Database: >dbimport -i /export ext> >I have such a message : > >Create Database >330 Cannot create o rename database >100 ISAM error : Duplicate value for a record with a unique key > I was wrong. You are importing database that already exists. Sory. Nebojsa > >If someone can tell me Where can i find these message explain in Informix >documentation . >Which document I have to read ? > > >Thanks a lot in advance >Abdel BIDAR >abdel.bidar@marconi.com >

abdel BIDAR wrote: > I made an export of the database and it worked fine but when I tried to do a > dbimport on a 2000 Database: > dbimport -i /export ext> > I have such a message : > > Create Database > 330 Cannot create o rename database > 100 ISAM error : Duplicate value for a record with a unique key > > > If someone can tell me Where can i find these message explain in Informix > documentation . > Which document I have to read ? > > > Thanks a lot in advance > Abdel BIDAR > abdel.bidar@marconi.com The documentation is the SQL Reference Guide. The error message seems to say that the database already exists. The database must not exist prior to the execution of dbimport as dbimport creates the database itself. Regards -- Helmut Leininger Bull AG / Vienna Open Systems Support Email: h.leininger@bull.at This opinion is mine and not necessarily that of my employer. No guarantees whatsoever.

I made an export of the database and it worked fine but when I tried to do a dbimport on a 2000 Database: dbimport -i /export ext I have such a message : Create Database 330 Cannot create o rename database 100 ISAM error : Duplicate value for a record with a unique key If someone can tell me Where can i find these message explain in Informix documentation . Which document I have to read ? Thanks a lot in advance Abdel BIDAR abdel.bidar@marconi.com

Thanks a lot for the help... Yes the problem is that after the export I tried to launch a specific script that recreate the database and open it so as I tried to import in it , I have all the messages . I droped the database manually and everything is going well now. Thanks a lot again Abdel abdel BIDAR <abdel.bidar@marconi.com> wrote in message news:946kiv$cct$1@newsfeed.pit.comms.marconi.com... > I made an export of the database and it worked fine but when I tried to do a > dbimport on a 2000 Database: > dbimport -i /export ext> > I have such a message : > > Create Database > 330 Cannot create o rename database > 100 ISAM error : Duplicate value for a record with a unique key > > > If someone can tell me Where can i find these message explain in Informix > documentation . > Which document I have to read ? > > > Thanks a lot in advance > Abdel BIDAR > abdel.bidar@marconi.com > >