1.1

• SelectExpressions
• subqueries
Note: Cursors are read-only by default. To produce an updatable cursor besides meeting the requirements
listed above, the concurrency mode for the ResultSet must be ResultSet.CONCUR_UPDATABLE or the
SELECT statement must have FOR UPDATE in the FOR clause (see FOR UPDATE clause).
Note: Explicit naming of a cursor is not supported.
Statement dependency system
The SELECT depends on all the tables and views named in the query and the conglomerates (units of storage
such as heaps and indexes) chosen for access paths on those tables.
CREATE INDEX does not invalidate a prepared SELECT statement.
A DROP INDEX statement invalidates a prepared SELECT statement if the index is an access path in the
statement. If the SELECT includes views, it also depends on the dictionary objects on which the view itself
depends (see CREATE VIEW statement).
Any prepared UPDATE WHERE CURRENT or DELETE WHERE CURRENT statement against a cursor of
a SELECT depends on the SELECT. Removing a SELECT through a java.sql.Statement.close request invalidates
the UPDATE WHERE CURRENT or DELETE WHERE CURRENT.
The SELECT depends on all synonyms used in the query. Dropping a synonym invalidates a prepared SELECT
statement if the statement uses the synonym.
Example
-- lists the customer ID and expression
-- LOANLIMIT-AVAILLOAN as REMAINING_LIMIT and
-- orders by the new name REMAINING_LIMIT
SELECT CID, LOANLIMIT-AVAILLOAN AS REMAINING_LIMIT
FROM TRADE.NETWORTH ORDER BY REMAINING_LIMIT
-- creating an updatable cursor with a FOR UPDATE clause
-- to update the SINCE date
-- column in the CUSTOMERS table
SELECT SINCE FROM TRADE.CUSTOMERS FOR UPDATE OF SINCE
SET ISOLATION
Change the transaction isolation level for the connection.
Syntax
SET [ CURRENT ] ISOLATION [ = ]
{
UR | DIRTY READ | READ UNCOMMITTED
CS | READ COMMITTED | CURSOR STABILITY
RESET
}
vFabric SQLFire User's Guide514
vFabric SQLFire Reference