PPT Slide

* of 42

GRANT

GRANT (PLAN PRIVILEGES)

(SYSTEM PRIVILEGES)

(TABLE or VIEW PRIVILEGES)

(USE PRIVILEGES)

REVOKE

REVOKE (DATABASE PRIVILEGES)

(PLAN PRIVILEGES)

SYSTEM PRIVILEGES)

(TABLE or VIEW PRIVILEGES)

(USE PRIVILEGES)

SET CURRENT SQLID

DECLARE STATEMENT

EXPLAIN

EXECUTE

EXECUTE IMMEDIATE

PREPARE

ALTER INDEX

ALTER STOGROUP

ALTER TABLE

ALTER TABLESPACE

CREATE INDEX

CREATE STOGROUP

CREATE SYNONYM

CREATE TABLE

CREATE TABLEDSPACE

CREATE VIEW

DROP

CONNECT

DISCONNECT

DECLARE CURSOR

OPEN CURSOR

FETCH CURSOR

CLOSE CURSOR

SELECT INTO HOST VARIABLE

SELECT INTO ISPF TABLE

SELECT INTO STEM VARIABLE ARRAY

DELETE (Searched DELETE)

(Positioned DELETE) WHERE

CURRENT OF

INSERT

COMMIT

ROLLBACK

SQL Miscellaneous Statements

Previous slide Next slide Back to first slide View graphic version