gtpa3m16Application Requester User's Guide

SQL Commands Supported by TPFAR

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