IDS Forum

RE: Constraints script

Posted By: Jonathan Leffler
Date: Thursday, 22 January 2004, at 1:11 p.m.

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

--0__=08BBE4B0DFF0A8098f9e8a93df938690918c08BBE4B0DFF0A809
Content-type: multipart/alternative;
Boundary="1__=08BBE4B0DFF0A8098f9e8a93df938690918c08BBE4B0DFF0A809"

--1__=08BBE4B0DFF0A8098f9e8a93df938690918c08BBE4B0DFF0A809
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable






You've not got your Informix environment set properly? Specifically, y=
our
LD_LIBRARY_PATH (or moral equivalent - SHLIB_PATH or LIB_PATH, for exam=
ple)
is not set to include $INFORMIXDIR/lib and $INFORMIXDIR/lib/esql (you n=
eed
both). Or you did not manage to link statically. Or you did not manag=
e to
arrange for absolute pathnames for the shared libraries. Or ...

"esql -static ..." does a static link.

On some platforms (Solaris, Linux), using "esql -R$INFORMIXDIR/lib
-R$INFORMIXDIR/lib/esql ..." ensures that libraries are found even when=

LD_LIBRARY_PATH is not set.

Alternatively, you have to generate the list of CSDK libraries, convert=

them to absolute pathnames, and list the absolute pathnames on the comm=
and
line. It's a good idea to list them in the correct order, but you only=

need to list any given library once.

--
Jonathan Leffler (jleffler@us.ibm.com)
STSM, Informix Database Engineering, IBM Data Management
4100 Bohannon Drive, Menlo Park, CA 94025
Tel: +1 650-926-6921 Tie-Line: 630-6921
"I don't suffer from insanity; I enjoy every minute of it!"




|---------+------------------------------>
| | "Erasmus, Marius" |
| | <MErasmus@ejustice.|
| | pwv.gov.za> |
| | Sent by: |
| | forum.subscriber@ii|
| | ug.org |
| | |
| | |
| | 01/21/2004 11:35 PM|
|---------+------------------------------>
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
--|
| =
=
|
| To: ids@iiug.org =
=
|
| cc: =
=
|
| Subject: RE: Constraints script [2470] =
=
|
>--------------------------------------------------------------------=
-----------------------------------------------------------------------=
--|




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 CRE=
ATE
DDL
to the first file and all CREATE INDEX and ALTER TABLE ADD CONSTRAINT D=
DL
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.x=
x
features has not been completely tested). Myschema is included in the
package
utils2_ak available for download from the IIUG Software Repository. (I=
f
you

decide to use myschema look for an update soon containing enhanced sche=
ma
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 som=
e
other
> program to generate me a schema (like the one DBSCHEMA does), that wi=
ll
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, an=
d
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 l=
ike
> 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!! "



=

--1__=08BBE4B0DFF0A8098f9e8a93df938690918c08BBE4B0DFF0A809
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

<html><body>
<p>You've not got your Informix environment set properly? Specifically=
, your LD_LIBRARY_PATH (or moral equivalent - SHLIB_PATH or LIB_PATH, f=
or example) is not set to include $INFORMIXDIR/lib and $INFORMIXDIR/lib=
/esql (you need both). Or you did not manage to link statically. Or y=
ou did not manage to arrange for absolute pathnames for the shared libr=
aries. Or ...<br>
<br>
&quot;esql -static ...&quot; does a static link.<br>
<br>
On some platforms (Solaris, Linux), using &quot;esql -R$INFORMIXDIR/lib=
-R$INFORMIXDIR/lib/esql ...&quot; ensures that libraries are found eve=
n when LD_LIBRARY_PATH is not set.<br>
<br>
Alternatively, you have to generate the list of CSDK libraries, convert=
them to absolute pathnames, and list the absolute pathnames on the com=
mand line. It's a good idea to list them in the correct order, but you=
only need to list any given library once.<br>
<br>
--<br>
Jonathan Leffler (jleffler@us.ibm.com)<br>
STSM, Informix Database Engineering, IBM Data Management<br>
4100 Bohannon Drive, Menlo Park, CA 94025<br>
Tel: +1 650-926-6921 Tie-Line: 630-6921<br>
&quot;I don't suffer from insanity; I enjoy every minute of it!&q=
uot;<br>
<br>
<br>
<img src=3D"cid:10__=3D08BBE4B0DFF0A8098f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for &quot;Erasmus, Mari=
us&quot; &lt;MErasmus@ejustice.pwv.gov.za&gt;">&quot;Erasmus, Marius&qu=
ot; &lt;MErasmus@ejustice.pwv.gov.za&gt;<br>
<br>
<br>

<table V5DOTBL=3Dtrue width=3D"100%" border=3D"0" cellspacing=3D"0" cel=
lpadding=3D"0">
<tr valign=3D"top"><td width=3D"1%"><img src=3D"cid:20__=3D08BBE4B0DFF0=
A8098f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"72" al=
t=3D""><br>
</td><td style=3D"background-image:url(cid:30__=3D08BBE4B0DFF0A8098f9e8=
a93df938@us.ibm.com); background-repeat: no-repeat; " width=3D"1%"><img=
src=3D"cid:20__=3D08BBE4B0DFF0A8098f9e8a93df938@us.ibm.com" border=3D"=
0" height=3D"1" width=3D"225" alt=3D""><br>

<ul>
<ul>
<ul>
<ul><b><font size=3D"2">&quot;Erasmus, Marius&quot; &lt;MErasmus@ejusti=
ce.pwv.gov.za&gt;</font></b><br>
<font size=3D"2">Sent by: forum.subscriber@iiug.org</font>
<p><font size=3D"2">01/21/2004 11:35 PM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"100%"><img src=3D"cid:20__=3D08BBE4B0DFF0A8098f9e8a93=
df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"1" face=3D"Arial"> </font><br>
<font size=3D"2"> To: </font><font size=3D"2">ids@iiug.org</font><br>
<font size=3D"2"> cc: </font><br>
<font size=3D"2"> Subject: </font><font size=3D"2">RE: Constraints scri=
pt [2470]</font></td></tr>
</table>
<br>
<br>
<tt>Hi,<br>
<br>
Thanx for the reply....<br>
<br>
After struggling very much to compile, and eventually succeeding, I got=
the<br>
following message when executing myschema from the command line.<br>
The PATH is set to include the directory where libifsql.so resides.<br>=

<br>
ld.so.1: myschema: fatal: libifsql.so: open failed: No such file or<br>=

directory<br>
Killed<br>
<br>
What can be wrong <br>
<br>
Marius.<br>
<br>
-----Original Message-----<br>
From: ART KAGEL, BLOOMBERG/ 65E 55TH [<a href=3D"mailto:KAGEL@bloomberg=
.net">mailto:KAGEL@bloomberg.net</a>] <br>
Sent: 21 January 2004 03:55 PM<br>
To: Erasmus, Marius<br>
Subject: Re: Constraints script [2465]<br>
<br>
Yes. &nbsp;My dbschema replacement utility, myschema, works in just thi=
s way, and<br>
if <br>
you present two filename on the commandline myschema will write the CRE=
ATE<br>
DDL <br>
to the first file and all CREATE INDEX and ALTER TABLE ADD CONSTRAINT D=
DL <br>
commands to the second file. &nbsp;Myschema is a complete replacement f=
or<br>
dbschema <br>
with the sole exception of the -hd option and also contains many<br>
enhancements <br>
and improvements to dbschema and avoids several of dbschema's problems.=
&nbsp;<br>
Myschema supports all Informix database engines (though support for 8.x=
x <br>
features has not been completely tested). Myschema is included in the<b=
r>
package <br>
utils2_ak available for download from the IIUG Software Repository. &nb=
sp;(If you<br>
<br>
decide to use myschema look for an update soon containing enhanced sche=
ma <br>
support for the SMI pseudo-tables in sysmaster.)<br>
<br>
Art S. Kagel<br>
<br>
----- Original Message -----<br>
From: Marius Erasmus &nbsp;&lt;MErasmus@ejustice.pwv.gov.za&gt;<br>
At: &nbsp;1/21 &nbsp;4:44<br>
<br>
&gt; Hi there,<br>
&gt; <br>
&gt; I want to know if it's possible to use something like DBSCHEMA or =
some<br>
other<br>
&gt; program to generate me a schema (like the one DBSCHEMA does), that=
will<br>
give<br>
&gt; me ALL the constraints as separate commands.<br>
&gt; The schema file that DBSCHEMA creates only have certain ALTER TABL=
E .....<br>
or<br>
&gt; CREATE INDEX ....... constraints at the bottom of the schema file,=
and<br>
most<br>
&gt; of the primary key constraints are part of the table declarations.=
<br>
&gt; <br>
&gt; I need ALL the constraints and indexes (including PRIMARY KEYS) as=
a<br>
&gt; separate ALTER TABLE / CREATE INDEX ....... command.<br>
&gt; <br>
&gt; Does someone know of any tool/script that can generate me somethin=
g like<br>
&gt; this.<br>
&gt; <br>
&gt; Thanx,<br>
&gt; <br>
&gt; <br>
&gt; Marius Erasmus<br>
&gt; DBA / UNIX Admin<br>
&gt; <br>
&gt; * (012) 470-1306<br>
&gt; * 082 5522 848<br>
&gt; * 082 131 5522 848<br>
&gt; <br>
&gt; <br>
&gt; &quot; Never interrupt your enemy when he is making a mistake!! &q=
uot;<br>
<br>
<br>
<br>
</tt>

</body></html>=


--1__=08BBE4B0DFF0A8098f9e8a93df938690918c08BBE4B0DFF0A809--


--0__=08BBE4B0DFF0A8098f9e8a93df938690918c08BBE4B0DFF0A809
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=08BBE4B0DFF0A8098f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7

--0__=08BBE4B0DFF0A8098f9e8a93df938690918c08BBE4B0DFF0A809
Content-type: image/gif;
name="ecblank.gif"
Content-Disposition: inline; filename="ecblank.gif"
Content-ID: <20__=08BBE4B0DFF0A8098f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7

--0__=08BBE4B0DFF0A8098f9e8a93df938690918c08BBE4B0DFF0A809
Content-type: image/gif;
name="pic24197.gif"
Content-Disposition: inline; filename="pic24197.gif"
Content-ID: <30__=08BBE4B0DFF0A8098f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64

R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA
AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR
RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH
LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK
BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI
TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR
M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNUtJOUAVLoUr1+wqDGTE4zk+T6FG
uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO3mpOaKnL0Z2EKvNMSILEThKhCg
zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXpuFKhSYZALd0O5RKa2z9EYKBbpb
qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NENQj2jXjmfNgOZDaXb5glRmXQ33
YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4rwxxINMvpFFAz1KOODHiu+4aEw
NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoCWOOUwgltIwAKRxJgbIkJAQZEq0
2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ6ChjCAH3QlhJcT6VWE6FCkfCco
CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3QxhgohNKXJCWv8JQr/PDdaqd6w
2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iImTHEQyqJ4eIxJJoUBc+3CbBuwZE
V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4senwEhYGnKEFJeGrxUZy8dB8gmAXI/sPvH
ESfCwVt5hTgYiqQqtdRNHQIU1PJ33ZqmzgE90OwLaoJcnMop1WiMmgkPHQRIrwgFuNV90A3doNKT
mrKIN07AnGcI9BQjhCBN4RfA1qIZnMqorJCogKfGQnxSCDilTVIA0yl5ciTovgLuBDKFUDE9aQcw
9SA+rjSNf9/M1gxrj6VwDTS0IUSElMzBfsj0NFXR2kwsV1A5IF1grLgLL/r1R40BZEnuBWgmQEyb
jqRwSAt6bqMCOFkvKFN2GPPkUzIm/SCF8z8pVzpbjVnMsy0vOr1hw3SaSRUhpY09v0z0J1FnwzPl
fmh+xl4WtR0zGu24I4KbMQm3lnVu2oNWxI9W/lcyzA+mCKF4DBikxb/+UWtOGRiFP8qEwAayIgIA
Ow==

--0__=08BBE4B0DFF0A8098f9e8a93df938690918c08BBE4B0DFF0A809--

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.