| Subject | FB 2.1: GTT explanation |
|---|---|
| Author | Tetram Corp |
| Post date | 2008-04-21T10:26:55Z |
Hi,
I'm reading release notes, and I saw this about GTT:
"references between persistent and temporary tables are forbidden"
So it isn't possible to do something like this? if yes, is it possible
to know the reason?
create table t1 (
field integer unique
);
create global temporary table gtt (
field integer references t1(field)
);
or is there only a restriction about static tables referencing temporary?
I'm reading release notes, and I saw this about GTT:
"references between persistent and temporary tables are forbidden"
So it isn't possible to do something like this? if yes, is it possible
to know the reason?
create table t1 (
field integer unique
);
create global temporary table gtt (
field integer references t1(field)
);
or is there only a restriction about static tables referencing temporary?