SQLJ statement-clause

A statement clause contains an SQL statement or a SET TRANSACTION clause.

Syntax

Read syntax diagramSkip visual syntax diagram{ SQL-statementSET-TRANSACTION-clause }

Description

SQL-statement
You can include SQL statements in Table 1 in a statement clause.
SET-TRANSACTION-clause
Sets the isolation level for SQL statements in the program and the access mode for the connection. The SET TRANSACTION clause is equivalent to the SET TRANSACTION statement, which is described in the ANSI/ISO SQL standard of 1992 and is supported in some implementations of SQL.
Table 1. Valid SQL statements in an SQLJ statement clause
Statement Applicable data sources
ALTER DATABASE 1, 2
ALTER FUNCTION 1, 2, 3
ALTER INDEX 1, 2, 3
ALTER PROCEDURE 1, 2, 3
ALTER STOGROUP 1, 2
ALTER TABLE 1, 2, 3
ALTER TABLESPACE 1, 2
CALL 1, 2, 3
COMMENT ON 1, 2
COMMIT 1, 2, 3
Compound SQL (BEGIN ATOMIC…END) 2
CREATE ALIAS 1, 2
CREATE DATABASE 1, 2, 3.a
CREATE DISTINCT TYPE 1, 2, 3
CREATE FUNCTION 1, 2, 3
CREATE GLOBAL TEMPORARY TABLE 1, 2
CREATE TEMP TABLE 3
CREATE INDEX 1, 2, 3
CREATE PROCEDURE 1, 2, 3
CREATE STOGROUP 1, 2
CREATE SYNONYM 1, 2, 3
CREATE TABLE 1, 2, 3
CREATE TABLESPACE 1, 2
CREATE TYPE (cursor) 2
CREATE TRIGGER 1, 2, 3
CREATE VIEW 1, 2, 3
DECLARE GLOBAL TEMPORARY TABLE 1, 2
DELETE 1, 2, 3
DROP ALIAS 1, 2
DROP DATABASE 1, 2, 3.a
DROP DISTINCT TYPE 1, 2
DROP TYPE 3
DROP FUNCTION 1, 2, 3
DROP INDEX 1, 2, 3
DROP PACKAGE 1, 2
DROP PROCEDURE 1, 2, 3
DROP STOGROUP 1, 2
DROP SYNONYM 1, 2, 3
DROP TABLE 1, 2, 3
DROP TABLESPACE 1, 2
DROP TRIGGER 1, 2, 3
DROP VIEW 1, 2, 3
FETCH 1, 2, 3
GRANT 1, 2, 3
INSERT 1, 2, 3
LOCK TABLE 1, 2, 3
MERGE 1, 2
REVOKE 1, 2, 3
ROLLBACK 1, 2, 3
SAVEPOINT 1, 2, 3
SELECT INTO 1, 2, 3
SET CURRENT DEBUG MODE 1
SET CURRENT DEFAULT TRANSFORM GROUP 2
SET CURRENT DEGREE 1, 2
SET CURRENT EXPLAIN MODE 2
SET CURRENT EXPLAIN SNAPSHOT 2
SET CURRENT ISOLATION 1, 2
SET CURRENT LOCALE LC_CTYPE 1
SET CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION 1, 2
SET CURRENT OPTIMIZATION HINT 1, 2
SET CURRENT PACKAGE PATH 1
SET CURRENT PACKAGESET (USER is not supported) 1, 2
SET CURRENT PRECISION 1, 2
SET CURRENT QUERY ACCELERATION 1
SET CURRENT QUERY OPTIMIZATION 2
SET CURRENT REFRESH AGE 1, 2
SET CURRENT ROUTINE VERSION 1
SET CURRENT RULES 1
SET CURRENT SCHEMA 2
SET CURRENT SQLID 1
SET PATH 1, 2
TRUNCATE 1
UPDATE 1, 2, 3
Note: The SQL statement applies to connections to the following data sources:
  1. Db2® for z/OS®
  2. Db2 on Linux®, UNIX, and Windows systems
  3. IBM® Informix®
    1. IBM Informix, for the SYSMASTER database only.

Usage notes

  • SQLJ supports both positioned and searched DELETE and UPDATE operations.
  • For a FETCH statement, a positioned DELETE statement, or a positioned UPDATE statement, you must use an iterator to refer to rows in a result table.