Re: Alter table

Posted in 2005

Jonathan Leffler — Tue, 26 Jul 2005 18:48:54 -0700 — source: Usenet: comp.databases.informix

On 7/26/05, Colin Dawson <cjd_1955@hotmail.com> wrote: > Bit of a stupid question, but.... > > Is there a quick/easy way to determine what tables have outstanding > 'alters'? There's a Perl script I wrote in the IIUG software archive... Well, I thought there was - I can't now find it. (And ipa.info.pl.txt comes up with premature end, so I can't tell if that's the file - though I don't think that's the name I'd use, even though it has the right extension). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/ sending to informix-list

↪ replying to Jonathan Leffler

Superboer — 27 Jul 2005 00:10:37 -0700 — source: Usenet: comp.databases.informix

database sysmaster; set isolation to dirty read;select --+ORDERED pg_partnum + pg_pagenum - 1 partn from sysdbspaces a, syspaghdr where pg_partnum = 1048576 * a.dbsnum + 1 and pg_next != 0 into temp pp with no log; select b.dbsname database, b.tabname table from systabnames b, pp where partn = partnum; Superboer

↪ replying to Superboer

Superboer — 27 Jul 2005 00:16:50 -0700 — source: Usenet: comp.databases.informix

btw --Bit of a stupid question, but.. ahum there is only 1 stupid question; that is the one which is not asked..... Superboer.