IDS Forum

Re: implicit PK

Posted By: Art Kagel
Date: Tuesday, 9 March 2010, at 5:30 p.m.

In Response To: implicit PK (ALBERTO ROMEU PESSONIO FILHO)

Not automated, no. You will have to drop all of your tables with implicit
constraints (since they have constraint names that are actually illegal so
you can't drop the constraints) but you can make it easier to do:

- Get my packages utils2_ak and utils3_ak from the IIUG Software

Repository

- Build the utilities in utils2_ak to get the myschema utility

- Run myschema with the -l option (makes the output compatible with

dbexport/dbimport) into a file named <databasename>.sql

- Dbexport your database.

- Substitute the output file from myschema above for the one in the

dbexport <databasename>.exp directory

- Drop or rename your original database.

- dbimport the database using the <databasename>.sql file built by

myschema.

Voila!

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)

See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.

On Tue, Mar 9, 2010 at 5:40 AM, ALBERTO ROMEU PESSONIO FILHO <
arfilho@orizonbrasil.com.br> wrote:

> Hi guys!
>
> Does anybody know how can I do to change an implicit PK to an explicit PK
> for
> all tables in a database automatically? I have several databases (about 50)
> that uses implicit PK on the tables and I need to detach them using a SQL
> script or a SPL for all tables in database.
>
> Example:
>
> create table "informix".tbgrupoexcecao
> (
>
> ems_numero integer not null ,
>
> pri_grupo smallint,
>
> primary key (pri_grupo)
> );
>
> I need to change to this;
>
> create table "informix".tbgrupoexcecao
> (
>
> ems_numero integer not null ,
>
> pri_grupo smallint
> );
>
> create unique index ix_01 on "informix".tbgrupoexcecao
> (pri_grupo) using btree in dbspace_x;
>
> I appreciate any help.
> Thanks in advance,
> Alberto.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--00151750df1644dc16048165bb80

Messages In This Thread

• implicit PK
  ALBERTO ROMEU PESSONIO FILHO -- Tuesday, 9 March 2010, at 5:40 a.m.
  • Re: implicit PK
    Fernando Nunes -- Tuesday, 9 March 2010, at 6:44 a.m.
    • AW: implicit PK
      Andreas.KUTSCHE@spar.at -- Tuesday, 9 March 2010, at 7:57 a.m.
      • Re: AW: implicit PK
        rroussey@comcast.net -- Tuesday, 9 March 2010, at 10:11 a.m.
  • Re: implicit PK
    Art Kagel -- Tuesday, 9 March 2010, at 5:30 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.