At 02:46 PM 12/5/2004, Vlad Horsun wrote:

> > > ! - data is never visible outside the connection
> > right.
>
> How about foreign key referenced from temporary table
>to permanent ? Is this allowed by standard ?

No.

5) The referenced table shall be a base table.
Case:
a) If the referencing table is a persistent base table,
then the referenced table shall be a persistent base
table.
b) If the referencing table is a global temporary table,
then the referenced table shall be a global temporary
table.
c) If the referencing table is a created local temporary
table, then the referenced table shall be either a
global temporary table or a created local temporary table.
d) If the referencing table is a declared local temporary
table, then the referenced table shall be either a
global temporary table, a created local temporary table
or a declared local temporary table.

6) If the referenced table is a temporary table with
ON COMMIT DELETE ROWS specified, then the referencing
table shall specify ON COMMIT DELETE ROWS.

>PS AFAIK, IB75 allows such references.

shame on them.


Cheers,


Ann