William -
The TEMPORARY tables were specifically developed to be used with
STATICDB on or off. I use PROJECT TEMPORARY tablename with STATICDB set to
ON in several applications. When STATICDB is on PROJECT will execute but
the table it produces is temporary. (That was a shock. I was looking for
the error message that would be produced when I discovered this.)
Bernie
=====================================
At 10:11 AM 6/14/01 -0700, you wrote:
>
>
>Per the Reference Manual, the PROJECT command creates a schema lock on a
database. Does anyone know if this is true when STATICDB is ON or if the
PROJECT explicitly states TEMPORARY?
>
>wm
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
><HTML><HEAD>
><META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
><META content="MSHTML 5.00.3315.2870" name=GENERATOR>
><STYLE></STYLE>
></HEAD>
><BODY bgColor=#ffffff>
><DIV><FONT face=Arial size=2> </FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>Per the Reference Manual, the PROJECT command
>creates a schema lock on a database. Does anyone know if this is true
when
>STATICDB is ON or if the PROJECT explicitly states TEMPORARY?</FONT></DIV>
><DIV> </DIV>
><DIV><FONT face=Arial size=2>wm</FONT></DIV></BODY></HTML>
>
