I've download and installed Caché 2007.1, its running and all works well but what about the new features? The first thing i will check is "temp tables". The feature doc says "SQL Temporary Tables – This release adds support for SQL temporary tables." ... ok ... but how? The CREATE TABLE description says: Caché does not support TEMPORARY tables ?

Ok it is a field test, so the documentation is not complete, but some hints would be helpful to test the new features ;-)

So i try some syntax i remember:

The MS SQL Server syntax is:
CREATE TABLE #MyTable (TheID int,TheName char(30) )
or to make these into global temporary tables, just replace (#) with (##)
CREATE TABLE ##MyTable (TheID int,TheName char(30) )
these syntax doesn't work.

After some google search i found a more usual syntax (Oracle,DB2) :

CREATE GLOBAL TEMPORARY TABLE MyTable (TheID int,TheName char(30) )

and ... IT WORKS!

The ON COMMIT clause is not supported. If i try:

CREATE GLOBAL TEMPORARY TABLE MyTable (TheID int,TheName char(30) )
ON COMMIT PRESERVE ROWS

or

CREATE GLOBAL TEMPORARY TABLE MyTable (TheID int,TheName char(30) )
ON COMMIT DELETE ROWS

Caché send an SQLERROR -25