Nonstop Database, HiRDB Version 9 UAP Development Guide
The following table lists the SQL statements that can be used in SQLJ.
Table 19-3 SQL statements that can be used in SQLJ
Type | SQL statement | Usability | Alternate means | |
---|---|---|---|---|
Standard interface edition | Native interface edition | |||
Definition SQL statement | All | Y | Y | None |
Data manipulation SQL statements | ASSIGN LIST statement | N (SQLJ) | N (SQLJ) | Use JDBC. |
CALL statement | Y | Y | None | |
CLOSE statement | N (SQLJ) | N (SQLJ) | Use an iterator. | |
DECLARE CURSOR | N (SQLJ) | N (SQLJ) | ||
DELETE statement | Y | Y | None | |
DESCRIBE statement | N (JDBC) | N (JDBC)# | Use JDBC. | |
DESCRIBE TYPE statement | N (JDBC) | N (JDBC)# | ||
DROP LIST statement | N (JDBC) | N (JDBC)# | ||
EXECUTE statement | N (JDBC) | N (JDBC)# | ||
EXECUTE IMMEDIATE statement | N (JDBC) | N (JDBC)# | ||
FETCH statement (Format 1 or 3) | Y | Y | None | |
FETCH statement (Format 2) | N | N | None | |
INSERT statement | Y | Y | None | |
OPEN statement (Format 1) | N (SQLJ) | N (SQLJ) | Use an iterator. | |
OPEN statement (Format 2) | N (SQLJ) | N (SQLJ) | Use JDBC. | |
PREPARE statement | N (SQLJ) | N (SQLJ) | ||
PURGE TABLE statement | Y | Y | None | |
Single-row SELECT statement | Y | Y | None | |
Dynamic SELECT statement | N (JDBC) | N (JDBC)# | Use JDBC. | |
UPDATE statement | Y | Y | None | |
Control SQL statements | COMMIT statement | Y | Y | None |
COMMIT statement (RELEASE specified) | N (SQLJ) | N (SQLJ) | Split into COMMIT and DISCONNECT. | |
CONNECT statement | N | Y | None | |
DISCONNECT statement | N | Y | None | |
LOCK statement | Y | Y | None | |
ROLLBACK statement | Y | Y | None | |
ROLLBACK statement (RELEASE specified) | N (SQLJ) | N (SQLJ) | Split into ROLLBACK and DISCONNECT. | |
SET SESSION AUTHORIZATION statement | N | N | None | |
Embedded language syntax | BEGIN DECLARE SECTION | N | N | None |
END DECLARE SECTION | N | N | None | |
ALLOCATE CONNECTION HANDLE | N (SQLJ) | N (SQLJ) | Use a connection context. | |
DECLARE CONNECTION HANDLE | N (SQLJ) | N (SQLJ) | ||
FREE CONNECTION HANDLE | N (SQLJ) | N (SQLJ) | ||
GET CONNECTION HANDLE | N | N | None | |
COPY | N | N | None | |
GET DIAGNOSTICS | N | N | None | |
WHENEVER | N (SQLJ) | N (SQLJ) | Implement using try ... catch. |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.