1.0

• IDENTITY attribute in copy-options
• AS (fullselect) DEFINITION ONLY
• NOT LOGGED ON ROLLBACK PRESERVE ROWS
• IN tablespace-name
• PARTITIONING KEY
• WITH REPLACE
Example
set schema testSchema;
create table test (col1 int, col2 varchar(100));
-- The SESSION qualification is redundant here because
temporary
-- tables can only exist in the SESSION schema.
declare global temporary table SESSION.test_temp(col1 int)
not logged;
-- The temporary table is not qualified here with SESSION
because temporary
-- tables can only exist in the SESSION schema.
declare global temporary table check2(col2 int) not logged;
-- SESSION qualification is mandatory here if you want to use
-- the temporary table, because the current schema is
"testSchema"
insert into SESSION.test_temp values (1);
-- This select statement is referencing the
"testSchema.test_temp" physical
-- table since the table was not qualified by SESSION.
select * from test_temp;
DELETE
Delete rows from a table.
Syntax
{
DELETE FROM table-name [ [AS] correlation-name ]
[ WHERE clause ]
}
Description
This form is called a searched delete, removes all rows identified by the table name and WHERE clause.
Statement dependency system
A searched delete statement depends on the table being updated, all of its conglomerates (units of storage such
as heaps or indexes), and any other table named in the WHERE clause.
A CREATE or DROP INDEX statement for the target table of a prepared searched delete statement invalidates
the prepared searched delete statement.
vFabric SQLFire User's Guide472
vFabric SQLFire Reference