dbimport error
This is a multi-part message in MIME format.
------=_NextPart_000_002F_01BEC470.0114BC70
Content-Type: text/plain;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
Hello all,
When I run dbimport utility, I get next error:
*** execute sqlobj
625 - Constraint name (n237_437) already exists.=20
Although I change directory name, sql file name & first row in the sql =
file.
What can I do?
------=_NextPart_000_002F_01BEC470.0114BC70
Content-Type: text/html;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dkoi8-r" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3401" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV>Hello all,</DIV>
<DIV> </DIV>
<DIV>When I run dbimport utility, I get next error:</DIV>
<DIV> </DIV>
<DIV>*** execute sqlobj<BR>625 - Constraint name (n237_437) already =
exists.=20
</DIV>
<DIV> </DIV>
<DIV>Although I change directory name, sql file name & first row in =
the sql=20
file.</DIV>
<DIV> </DIV>
<DIV>What can I do?</DIV></DIV></BODY></HTML>
------=_NextPart_000_002F_01BEC470.0114BC70--
Hello Shohin,
when creating Your orginal database You added contraints (maybe only a NOT
NULL on
a column) without giving the constraint a unique name. So Informix created a
name for You
by using the tabid and constraint-id. These names are exported as well. When
importing there
was an unnamed Constraint, which already gets the the ealier used constraint
name.
Check Your database.sql file, which creates the new database and delete all
clauses stating
"constraint name 'username'.nxxx_yyy", where xxx is the tabid and yyy is the
constraint-id.
For future use it will be a god way, to name all Your constraints manually
in Your create-
statements.
Wolfgang
Shohin <shohin@eapo.org> schrieb in im Newsbeitrag:
7lhle0$bph$1@news.xmission.com...
>
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_002F_01BEC470.0114BC70
> Content-Type: text/plain;
> charset="koi8-r"
> Content-Transfer-Encoding: quoted-printable
>
> Hello all,
>
> When I run dbimport utility, I get next error:
>
> *** execute sqlobj
> 625 - Constraint name (n237_437) already exists.=20
>
> Although I change directory name, sql file name & first row in the sql =
> file.
>
> What can I do?
>
> ------=_NextPart_000_002F_01BEC470.0114BC70
> Content-Type: text/html;
> charset="koi8-r"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META content=3D"text/html; charset=3Dkoi8-r" http-equiv=3DContent-Type>
> <META content=3D"MSHTML 5.00.2614.3401" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV>
> <DIV>Hello all,</DIV>
> <DIV> </DIV>
> <DIV>When I run dbimport utility, I get next error:</DIV>
> <DIV> </DIV>
> <DIV>*** execute sqlobj<BR>625 - Constraint name (n237_437) already =
> exists.=20
> </DIV>
> <DIV> </DIV>
> <DIV>Although I change directory name, sql file name & first row in =
> the sql=20
> file.</DIV>
> <DIV> </DIV>
> <DIV>What can I do?</DIV></DIV></BODY></HTML>
>
> ------=_NextPart_000_002F_01BEC470.0114BC70--
>
Are you using v7.24? There's a bug in v7.24 which causes this. I can give
you the UK Problem Number if you like. The workaround is to edit the
import SQL file.
Neil Truby
Londis Stores
Hampton Hill, UK
Shohin wrote in message <7lhle0$bph$1@news.xmission.com>...
>
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_002F_01BEC470.0114BC70
>Content-Type: text/plain;
> charset="koi8-r"
>Content-Transfer-Encoding: quoted-printable
>
>Hello all,
>
>When I run dbimport utility, I get next error:
>
>*** execute sqlobj
>625 - Constraint name (n237_437) already exists.=20
>
>Although I change directory name, sql file name & first row in the sql =
>file.
>
>What can I do?
>
>------=_NextPart_000_002F_01BEC470.0114BC70
>Content-Type: text/html;
> charset="koi8-r"
>Content-Transfer-Encoding: quoted-printable
>
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML><HEAD>
><META content=3D"text/html; charset=3Dkoi8-r" http-equiv=3DContent-Type>
><META content=3D"MSHTML 5.00.2614.3401" name=3DGENERATOR>
><STYLE></STYLE>
></HEAD>
><BODY bgColor=3D#ffffff>
><DIV>
><DIV>Hello all,</DIV>
><DIV> </DIV>
><DIV>When I run dbimport utility, I get next error:</DIV>
><DIV> </DIV>
><DIV>*** execute sqlobj<BR>625 - Constraint name (n237_437) already =
>exists.=20
></DIV>
><DIV> </DIV>
><DIV>Although I change directory name, sql file name & first row in =
>the sql=20
>file.</DIV>
><DIV> </DIV>
><DIV>What can I do?</DIV></DIV></BODY></HTML>
>
>------=_NextPart_000_002F_01BEC470.0114BC70--
>