Contents About this book vii Compound SQL(Embedded) 130 Who should use this book CONNECT (Type 1) How this book is structured CONNECT(Type 2 a brief overview of volume 1 CREATE ALIAS How to read the syntax diagrams viii CREATE BUFFERPOOL Common syntax elements CREATE DATABASE PARTITION GROUP 158 Function designator xi CREATE DISTINCT TYPE Method designator. CREATE EVENT MONITOR Procedure designator CREATE FUNCTION Conventions used in this manual xvi CREATE FUNCTION (External Scalar) Error conditions xvi CREATE FUNCTION(External Table)... 217 Highlighting convention xvi CREATE FUNCTION (OLE DB External Related documentation CREATE FUNCTION (Sourced or Template) 243 Chapter 1. Statements 1 CREATE FUNCTION (SQL Scalar, Table or How SQL statements are invoked R Embedding a statement in an application CREATE FUNCTION MAPPING program. 7 CREATE INDEX Dynamic preparation and execution CREATE INDEX EXTENSION Static invocation of a select-statement 9 CREATE METHOD Dynamic invocation of a select-statement. .9 CREATE NICKNAME Interactive invocation CREATE PROCEDURE SQL use with other host systems 9 CREATE PROCEDURE (External) SQL return codes CREATE PROCEDURE (SQL) 10 CREATE SCHEMA ALTER BUFFERPOOL 12 CREATE SEQUENCE ALTER DATABASE PARTITION GROUP 15 CREATE SERVER ALTER FUNCTION 19 CREATE TABLE ALTER METHOD 22 CREATE TABLESPACE ALTER NICKNAME CREATE TRANSFORM ALTER PROCEDURE CREATE TRIGGER ALTER SEQUENCE 32 CREATE TYPE(Structured) 427 ALTER SERVER 37 CREATE TYPE MAPPING ALTER TABLE CREATE USER MAPPING ALTER TABLESPACE CREATE VIEW ALTER TYPE( Structured) 83 CREATE WRAPPER ALTER USER MAPPING 92 DECLARE CURSOR ALTER VIEW 95 DECLARE GLOBAL TEMPORARY TABLE 488 ALTER WRAPPER DELETE BEGIN DECLARE SECTION DESCRIBE CALL DISCONNECT 509 CLOSE 512 COMMENT 109 END DECLARE SECTION COMMIT EXECUTE Compound SQL (Dynamic) EXECUTE IMMEDIATE 552 C Copyright IBM Corp 1993-2002Contents About this book . . . . . . . . . . vii Who should use this book . . . . . . . vii How this book is structured . . . . . . vii A brief overview of Volume 1 . . . . . vii How to read the syntax diagrams . . . . viii Common syntax elements . . . . . . . xi Function designator . . . . . . . . xi Method designator. . . . . . . . . xii Procedure designator. . . . . . . . xiv Conventions used in this manual. . . . . xvi Error conditions . . . . . . . . . xvi Highlighting conventions . . . . . . xvi Related documentation . . . . . . . . xvi Chapter 1. Statements . . . . . . . .1 How SQL statements are invoked . . . . .7 Embedding a statement in an application program. . . . . . . . . . . . . 7 Dynamic preparation and execution . . . 8 Static invocation of a select-statement . . . 9 Dynamic invocation of a select-statement. . 9 Interactive invocation . . . . . . . .9 SQL use with other host systems . . . .9 SQL return codes . . . . . . . . . 10 SQL comments . . . . . . . . . . 10 ALTER BUFFERPOOL . . . . . . . . 12 ALTER DATABASE PARTITION GROUP . . 15 ALTER FUNCTION . . . . . . . . . 19 ALTER METHOD . . . . . . . . . . 22 ALTER NICKNAME . . . . . . . . . 24 ALTER PROCEDURE . . . . . . . . . 28 ALTER SEQUENCE . . . . . . . . . 32 ALTER SERVER. . . . . . . . . . . 37 ALTER TABLE . . . . . . . . . . . 41 ALTER TABLESPACE . . . . . . . . . 75 ALTER TYPE (Structured) . . . . . . . 83 ALTER USER MAPPING. . . . . . . . 92 ALTER VIEW . . . . . . . . . . . 95 ALTER WRAPPER . . . . . . . . . . 97 BEGIN DECLARE SECTION . . . . . . 98 CALL . . . . . . . . . . . . . . 101 CLOSE . . . . . . . . . . . . . 107 COMMENT. . . . . . . . . . . . 109 COMMIT . . . . . . . . . . . . 120 Compound SQL (Dynamic) . . . . . . 123 Compound SQL (Embedded) . . . . . . 130 CONNECT (Type 1) . . . . . . . . . 134 CONNECT (Type 2) . . . . . . . . . 149 CREATE ALIAS . . . . . . . . . . 151 CREATE BUFFERPOOL. . . . . . . . 154 CREATE DATABASE PARTITION GROUP 158 CREATE DISTINCT TYPE . . . . . . . 161 CREATE EVENT MONITOR . . . . . . 172 CREATE FUNCTION . . . . . . . . 188 CREATE FUNCTION (External Scalar) . . . 190 CREATE FUNCTION (External Table) . . . 217 CREATE FUNCTION (OLE DB External Table) . . . . . . . . . . . . . . 235 CREATE FUNCTION (Sourced or Template) 243 CREATE FUNCTION (SQL Scalar, Table or Row) . . . . . . . . . . . . . . 254 CREATE FUNCTION MAPPING . . . . 263 CREATE INDEX . . . . . . . . . . 268 CREATE INDEX EXTENSION . . . . . 277 CREATE METHOD . . . . . . . . . 285 CREATE NICKNAME . . . . . . . . 295 CREATE PROCEDURE . . . . . . . . 296 CREATE PROCEDURE (External) . . . . 297 CREATE PROCEDURE (SQL) . . . . . . 311 CREATE SCHEMA . . . . . . . . . 318 CREATE SEQUENCE . . . . . . . . 322 CREATE SERVER . . . . . . . . . . 328 CREATE TABLE . . . . . . . . . . 332 CREATE TABLESPACE . . . . . . . . 395 CREATE TRANSFORM . . . . . . . . 405 CREATE TRIGGER . . . . . . . . . 414 CREATE TYPE (Structured) . . . . . . 427 CREATE TYPE MAPPING . . . . . . . 456 CREATE USER MAPPING . . . . . . . 461 CREATE VIEW . . . . . . . . . . 470 CREATE WRAPPER . . . . . . . . . 479 DECLARE CURSOR . . . . . . . . . 482 DECLARE GLOBAL TEMPORARY TABLE 488 DELETE . . . . . . . . . . . . . 497 DESCRIBE . . . . . . . . . . . . 504 DISCONNECT . . . . . . . . . . . 509 DROP. . . . . . . . . . . . . . 512 END DECLARE SECTION . . . . . . . 542 EXECUTE . . . . . . . . . . . . 544 EXECUTE IMMEDIATE. . . . . . . . 552 © Copyright IBM Corp. 1993 - 2002 iii