If you use the version >= 6
then update shouldn't cause growing (DECIMAL(18,0) is stored as INT64).

_a_x_e_ wrote:

> Hello Lev,
>
> the table metadata is:
>
> /* Table: IPAC, Owner: SYSDBA */
>
> CREATE TABLE "IPAC"
> (
> "IP" INTEGER NOT NULL,
> "NDATE" INTEGER NOT NULL,
> "INOUT" SMALLINT NOT NULL,
> "VAL1" DECIMAL(18, 0),
> "VAL2" DECIMAL(18, 0),
> "IP_STR" VARCHAR(15),
> CONSTRAINT "PK_IPAC" PRIMARY KEY ("IP", "NDATE", "INOUT")
> );
>
> the insert statement i use:
>
> $dbh->do("INSERT INTO IPAC (IP, NDATE, INOUT, VAL1, VAL2) VALUES
> ($ip,$ndate,$inout,$val1,$val2)");
>
> the update statement i use:
>
> $dbh->do("UPDATE IPAC SET VAL1=VAL1+$val1, VAL2=VAL2+$val2 WHERE
> (IP=$ip AND NDATE=$ndate AND INOUT=$inout)");
>
> thanks for help
>
> alex
>
> --- In ib-support@y..., Lev Assinovsky <lev@p...> wrote:
> > To help you, I need to know
> > the data types, the indexes in updated tables.
> > What the columns are get updated?
> > "Multi-version records" are freed when all transactions are done.
> >
>
> > --
> > Lev Assinovsky Peterlink Web
> > Programmer St. Petersburg, Russia
> > Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7�
> > E-mail: lev@p...
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
Lev Assinovsky Peterlink Web
Programmer St. Petersburg, Russia
Tel/Fax: +7 812 3275343 197022 ul.Chapigina 7�
E-mail: lev@...




[Non-text portions of this message have been removed]