Re: About my latest Question (lock temp table) (fwd)
List box was full! Sorry if this is repost for some!
---------- Forwarded message ----------
Date: Thu, 26 Sep 1996 20:36:33 -0500 (CDT)
From: Cheryl Kendricks <cherylk@prod1.jcdc.doleta.gov>
To: Informix List on WWW <informix-list@rmy.emory.edu>
Subject: Re: About my latest Question (lock temp table)
It could run out of system locks. Depends on the level of locking you use,
Number of rows being inserted and the max number of locks defined in the
configuration file for you "ONLINE" DB.
-------------------------------------------------------------------------
Cheryl Kendricks
Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov
DTSI, Inc.
Database Administrator - DOL Job Corps San Marcos, Texas
------------------------------------------------------------------------
On Thu, 26 Sep 1996, Manel Falco wrote:
>
> I expose this example about my lastest question:
>
> create temp table tt
> (aa any_type);> begin work;
>
> lock table tt in share mode; { Is necessary this lock. ??? }
>
> { Might it run out of system locks ??? }
>
> insert into tt { !!!! }
> select any_value from any_big_table;> commit work;
>
>
>
>
>