IDS Forum

RE: Constraints script

Posted By: Erasmus, Marius
Date: Tuesday, 27 January 2004, at 12:22 a.m.

In Response To: RE: Constraints script (Erasmus, Marius)

Hi,

I have compiled the myschema from ART KAGEL (utils2_ak) and it works very
well.
I can give you the copy I compiled, but I think it will only work if you are
using Informix (9.21) on Sun Solaris (7).

Let me know.......

Marius.

-----Original Message-----
From: pamadeo@info.unlp.edu.ar [mailto:pamadeo@info.unlp.edu.ar]
Sent: 26 January 2004 05:19 PM
To: Erasmus, Marius
Subject: RE: Constraints script [2470]


Hi, do you have this scripts? Because, if is possible, I'd like a copy of
them.

Thanks and sorry for my english.

Paola
Buenos Aires. Argentina.

Mensaje citado por "Erasmus, Marius" <MErasmus@ejustice.pwv.gov.za>:

> Hi,
>
> Thanx for the reply....
>
> After struggling very much to compile, and eventually succeeding, I got
the
> following message when executing myschema from the command line.
> The PATH is set to include the directory where libifsql.so resides.
>
> ld.so.1: myschema: fatal: libifsql.so: open failed: No such file or
> directory
> Killed
>
> What can be wrong
>
> Marius.
>
> -----Original Message-----
> From: ART KAGEL, BLOOMBERG/ 65E 55TH [mailto:KAGEL@bloomberg.net]
> Sent: 21 January 2004 03:55 PM
> To: Erasmus, Marius
> Subject: Re: Constraints script [2465]
>
> Yes. My dbschema replacement utility, myschema, works in just this way,
and
> if
> you present two filename on the commandline myschema will write the CREATE
> DDL
> to the first file and all CREATE INDEX and ALTER TABLE ADD CONSTRAINT DDL
> commands to the second file. Myschema is a complete replacement for
> dbschema
> with the sole exception of the -hd option and also contains many
> enhancements
> and improvements to dbschema and avoids several of dbschema's problems.
> Myschema supports all Informix database engines (though support for 8.xx
> features has not been completely tested). Myschema is included in the
> package
> utils2_ak available for download from the IIUG Software Repository. (If
you
>
> decide to use myschema look for an update soon containing enhanced schema
> support for the SMI pseudo-tables in sysmaster.)
>
> Art S. Kagel
>
> ----- Original Message -----
> From: Marius Erasmus <MErasmus@ejustice.pwv.gov.za>
> At: 1/21 4:44
>
> > Hi there,
> >
> > I want to know if it's possible to use something like DBSCHEMA or some
> other
> > program to generate me a schema (like the one DBSCHEMA does), that will
> give
> > me ALL the constraints as separate commands.
> > The schema file that DBSCHEMA creates only have certain ALTER TABLE
.....
> or
> > CREATE INDEX ....... constraints at the bottom of the schema file, and
> most
> > of the primary key constraints are part of the table declarations.
> >
> > I need ALL the constraints and indexes (including PRIMARY KEYS) as a
> > separate ALTER TABLE / CREATE INDEX ....... command.
> >
> > Does someone know of any tool/script that can generate me something like
> > this.
> >
> > Thanx,
> >
> >
> > Marius Erasmus
> > DBA / UNIX Admin
> >
> > * (012) 470-1306
> > * 082 5522 848
> > * 082 131 5522 848
> >
> >
> > " Never interrupt your enemy when he is making a mistake!! "
>
>
>




-------------------------------------------------
This mail sent through IMP: http://mail.info.unlp.edu.ar/

Messages In This Thread

• Constraints script
  Erasmus, Marius -- Wednesday, 21 January 2004, at 3:56 a.m.
  • Re: Constraints script
    Ravi T -- Wednesday, 21 January 2004, at 8:55 a.m.
    • Re: Constraints script
      Jack Parker -- Wednesday, 21 January 2004, at 6:32 p.m.
  • RE: Constraints script
    Erasmus, Marius -- Thursday, 22 January 2004, at 2:35 a.m.
    • Re: Constraints script
      Jorge Garcia -- Thursday, 22 January 2004, at 12:27 p.m.
    • RE: Constraints script
      Jonathan Leffler -- Thursday, 22 January 2004, at 1:11 p.m.
    • RE: Constraints script
      Erasmus, Marius -- Tuesday, 27 January 2004, at 12:22 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.