SQL statements (P-Z)

The following sections define the syntax information for SQL statements P-Z.

See also

PARAMETERS statement [Interactive SQL]
PASSTHROUGH statement [SQL Remote]
PREPARE statement [ESQL]
PREPARE TO COMMIT statement
PRINT statement [T-SQL]
PUT statement [ESQL]
RAISERROR statement
READ statement [Interactive SQL]
READTEXT statement [T-SQL]
REFRESH MATERIALIZED VIEW statement
REFRESH TEXT INDEX statement
REFRESH TRACING LEVEL statement
RELEASE SAVEPOINT statement
REMOTE RESET statement [SQL Remote]
REMOVE EXTERNAL OBJECT statement
REMOVE JAVA statement
REORGANIZE TABLE statement
RESIGNAL statement
RESTORE DATABASE statement
RESUME statement
RETURN statement
REVOKE statement
REVOKE CONSOLIDATE statement [SQL Remote]
REVOKE PUBLISH statement [SQL Remote]
REVOKE REMOTE statement [SQL Remote]
REVOKE REMOTE DBA statement [SQL Remote]
ROLLBACK statement
ROLLBACK TO SAVEPOINT statement
ROLLBACK TRANSACTION statement [T-SQL]
ROLLBACK TRIGGER statement
SAVE TRANSACTION statement [T-SQL]
SAVEPOINT statement
SELECT statement
SET statement
SET statement [T-SQL]
SET CONNECTION statement [Interactive SQL] [ESQL]
SET DESCRIPTOR statement [ESQL]
SET OPTION statement
SET OPTION statement [Interactive SQL]
SET REMOTE OPTION statement [SQL Remote]
SET SQLCA statement [ESQL]
SETUSER statement
SIGNAL statement
START DATABASE statement
START ENGINE statement [Interactive SQL]
START EXTERNAL ENVIRONMENT statement
START JAVA statement
START LOGGING statement [Interactive SQL]
START SUBSCRIPTION statement [SQL Remote]
START SYNCHRONIZATION DELETE statement [MobiLink]
STOP DATABASE statement
STOP ENGINE statement
STOP EXTERNAL ENVIRONMENT statement
STOP JAVA statement
STOP LOGGING statement [Interactive SQL]
STOP SUBSCRIPTION statement [SQL Remote]
STOP SYNCHRONIZATION DELETE statement [MobiLink]
SYNCHRONIZE SUBSCRIPTION statement [SQL Remote]
SYSTEM statement [Interactive SQL]
TRIGGER EVENT statement
TRUNCATE statement
TRUNCATE TEXT INDEX statement
UNION clause
UNLOAD statement
UPDATE statement
UPDATE (positioned) statement [ESQL] [SP]
UPDATE statement [SQL Remote]
VALIDATE statement
WAITFOR statement
WHENEVER statement [ESQL]
WHILE statement [T-SQL]
WINDOW clause
WRITETEXT statement [T-SQL]