RE: Script needed
FYI. The routines to perform field length computation etc. are written in
4gl and stashed in dbdiff2.sh at the iiug site.
cheers
j.
> -----Original Message-----
> From: Luis Carlos Diaz Otero [mailto:luiscarlosdiazo@yahoo.com]
> Sent: Thursday, February 01, 2001 5:57 PM
> To: Maxine E. Sarjeant; informix-list@iiug.org
> Subject: Re: Script needed
>
>
>
> --- "Maxine E. Sarjeant" <btimes@uis.doleta.gov>
> escribi': > I realize I didn't say we're using IDS
> 7.3, etc.
> > but now I've got the information I needed using the
> > following:
> >
> > database uidb;
> > select systables.tabname,
> > count (syscolumns.colname),
> > sum (syscolumns.collength)
> > from systables,
> > syscolumns
> > where syscolumns.tabid > 99
> > and syscolumns.tabid = systables.tabid
> > group by tabname;> >
>
> It will not work properly if there are DECIMAL, MONEY,
> VARCHAR, and other types of columns. I. e, if there
> is a DECIMAL column there is a routine to calculate
> the integer portion length (before the dot) and the
> decimal portion length.
>
> DEFINE a FLOAT,
> tcol LIKE syscolumns.*,
> b,c INTEGER
> ..
> ..
> ..
> DECLARE alpha CURSOR FOR SELECT * INTO tcol.*
> FOREACH alpha
> LET a=tcol.collength*2/512
> LET b=a
> LET c=(b/2+1)*512-512-tcol.collength
> # b is the integer portion (before the dot)
> # c is the decimal portion length (after the dot)
> .
> .
> .
> END FOREACH
> .
> .
> .
>
> >
> > > In article <95c918$22e$1@nnrp1.deja.com>,
> > > Maxine E. Sarjeant <btimes@uis.doleta.gov> wrote:
> > > Hello all,
> > > I need to report on all the tables in our
> > production database and
> > > break down the information per table to include
> > the number of
> > > columns and the total record length. I was going
> > to use the syscolumns
> > > table to generate the column and record length
> > information and was
> > > wondering if anyone out there already has a
> > similar script written.
> > > TIA,
> > > Maxine E. Sarjeant
> > >
> > > Sent via Deja.com
> > > http://www.deja.com/
> > >
> >
> > --
> > ============================================
> > work: btimes@uis.doleta.gov, aim: max1nes
> > home: msarjeant@yahoo.com, aim: mesarjeant
> > homepage: http://www.geocities.com/msarjeant/
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>
> =====
> ______________________________________
> Luis Carlos D'az Otero
> ALCANOS DE COLOMBIA S.A. E.S.P
> Carrera 9 # 7-25
> Neiva (Huila (Colombia))
>
> _________________________________________________________
> Do You Yahoo!?
> Obtenga su direcci'n de correo-e gratis @yahoo.com
> en http://correo.espanol.yahoo.com
>