gtpa3m16 | Application Requester User's Guide |
This table lists all of SQL commands and whether they are supported by
TPFAR. See the DB2 SQL Reference for more information on the
use of each command.
Table 3. TPFAR SQL Command Subset
SQL Command | Supported | Comments |
---|---|---|
ALTER DATABASE | Yes |
|
ALTER INDEX | Yes |
|
ALTER STOGROUP | Yes |
|
ALTER TABLE | Yes |
|
ALTER TABLESPACE | Yes |
|
BEGIN DECLARE SECTION | Yes |
|
CLOSE | Yes |
|
COMMENT ON | Yes |
|
COMMIT | Yes |
|
CONNECT | Yes | TPF supports only the TO option because it does not have a default database manager. |
CREATE ALIAS | Yes |
|
CREATE DATABASE | Yes |
|
CREATE INDEX | Yes |
|
CREATE STOGROUP | Yes |
|
CREATE SYNONYM | Yes |
|
CREATE TABLE | Yes |
|
CREATE TABLESPACE | Yes |
|
CREATE VIEW | Yes |
|
DECLARE CURSOR | Yes |
|
DECLARE STATEMENT | Yes |
|
DECLARE TABLE | Yes |
|
DELETE | Yes |
|
DESCRIBE | Yes |
|
DROP | Yes |
|
END DECLARE SECTION | Yes |
|
EXECUTE | Yes |
|
EXECUTE IMMEDIATE | Yes |
|
EXPLAIN | Yes |
|
FETCH | Yes |
|
GRANT | Yes |
|
INCLUDE | Yes |
|
INSERT | Yes |
|
LABEL ON | Yes |
|
LOCK TABLE | Yes |
|
OPEN | Yes |
|
PREPARE | Yes |
|
REVOKE | Yes |
|
ROLLBACK | Yes |
|
SELECT INTO | Yes |
|
SET CURRENT PACKAGESET | No | CURRENT PACKAGESET register is not supported. |
SET CURRENT SQLID | No | TPF uses a fixed SQLID. |
SET HOST VAR | No | TPF does not support special registers. |
UPDATE | Yes |
|
WHENEVER | Yes |
|