User manual IBM DB2

[. . . ] DB2 Version 9. 1 for z/OS Application Programming Guide and Reference for JavaTM SC18-9842-03 DB2 Version 9. 1 for z/OS Application Programming Guide and Reference for JavaTM SC18-9842-03 Note Before using this information and the product it supports, be sure to read the general information under "Notices" at the end of this information. Fourth edition (December 2008) This edition applies to DB2 Version 9. 1 for z/OS (DB2 V9. 1 for z/OS), product number 5635-DB2, and to any subsequent releases until otherwise indicated in new editions. Make sure you are using the correct edition for the level of the product. Specific changes are indicated by a vertical bar to the left of a change. A vertical bar to the left of a figure caption indicates that the figure has changed. [. . . ] The name of a column in the iterator must match, except for case, the name of a column in the result table. For online 286 Application Programming Guide and Reference for JavaTM checking during serialized profile customization to succeed, the data types of the columns in the iterator must be compatible with the data types of the columns in the result table. See Java, JDBC, and SQL data types for a list of compatible data types. Usage notes v An iterator declaration clause can appear anywhere in a Java program that a Java class declaration can appear. v When a named iterator declaration contains more than one pair of Java data types and Java IDs, all Java IDs within the list must be unique. Related concepts "Data retrieval in SQLJ applications" on page 123 Related tasks "Using a named iterator in an SQLJ application" on page 124 "Using a positioned iterator in an SQLJ application" on page 126 "Using scrollable iterators in an SQLJ application" on page 130 Related reference "SQLJ clause" on page 281 | | SQLJ executable-clause An executable clause contains an SQL statement or an assignment statement. An assignment statement assigns the result of an SQL operation to a Java variable. This topic describes the general form of an executable clause. Syntax context-clause statement-clause assignment-clause Usage notes v An executable clause can appear anywhere in a Java program that a Java statement can appear. v SQLJ reports negative SQL codes from executable clauses through class java. sql. SQLException. If SQLJ raises a run-time exception during the execution of an executable clause, the value of any host expression of type OUT or INOUT is undefined. Related concepts "SQL statement execution in SQLJ applications" on page 112 Related reference "SQLJ clause" on page 281 "SQLJ assignment-clause" on page 291 "SQLJ context-clause" on page 288 "SQLJ statement-clause" on page 288 Chapter 7. JDBC and SQLJ reference information 287 SQLJ context-clause A context clause specifies a connection context, an execution context, or both. You use an execution context to monitor and modify SQL statement execution. Syntax [ connection-context execution-context connection-context , ] execution context Description connection-context Specifies a valid Java identifier that is declared earlier in the SQLJ program. That identifier must be declared as an instance of the connection context class that SQLJ generates for a connection declaration clause. execution-context Specifies a valid Java identifier that is declared earlier in the SQLJ program. That identifier must be declared as an instance of class sqlj. runtime. ExecutionContext. Usage notes v If you do not specify a connection context in an executable clause, SQLJ uses the default connection context. v If you do not specify an execution context, SQLJ obtains the execution context from the connection context of the statement. Related tasks "Connecting to a data source using SQLJ" on page 103 "Controlling the execution of SQL statements in SQLJ" on page 142 Related reference "SQLJ executable-clause" on page 287 SQLJ statement-clause A statement clause contains an SQL statement or a SET TRANSACTION clause. Syntax { SQL-statement SET-TRANSACTION-clause } Description SQL-statement You can include SQL statements in Table 80 on page 289 in a statement clause. SET-TRANSACTION-clause Sets the isolation level for SQL statements in the program and the access mode for the connection. The SET TRANSACTION clause is equivalent to the SET TRANSACTION statement, which is described in the ANSI/ISO SQL standard of 1992 and is supported in some implementations of SQL. 288 Application Programming Guide and Reference for JavaTM | Table 80. Valid SQL statements in an SQLJ statement clause ALTER DATABASE ALTER FUNCTION ALTER INDEX ALTER PROCEDURE ALTER STOGROUP ALTER TABLE ALTER TABLESPACE CALL COMMENT ON COMMIT CREATE ALIAS CREATE DATABASE CREATE DISTINCT TYPE CREATE FUNCTION CREATE GLOBAL TEMPORARY TABLE CREATE INDEX CREATE PROCEDURE CREATE STOGROUP CREATE SYNONYM CREATE TABLE CREATE TABLESPACE CREATE TRIGGER CREATE VIEW DECLARE GLOBAL TEMPORARY TABLE DELETE DROP ALIAS DROP DATABASE DROP DISTINCT TYPE DROP FUNCTION DROP INDEX DROP PACKAGE DROP PROCEDURE DROP STOGROUP DROP SYNONYM DROP TABLE DROP TABLESPACE DROP TRIGGER DROP VIEW FETCH GRANT INSERT LOCK TABLE MERGE (does not apply to connections to IBM Informix Dynamic Server) REVOKE ROLLBACK SAVEPOINT SELECT INTO SET CURRENT APPLICATION ENCODING SCHEME SET CURRENT DEBUG MODE SET CURRENT DEGREE SET CURRENT LOCALE LC_CTYPE SET CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION SET CURRENT OPTIMIZATION HINT SET CURRENT PACKAGE PATH SET CURRENT PACKAGESET (USER is not supported) Chapter 7. Valid SQL statements in an SQLJ statement clause (continued) SET CURRENT PRECISION SET CURRENT REFRESH AGE SET CURRENT ROUTINE VERSION SET CURRENT RULES SET CURRENT SQLID SET PATH TRUNCATE UPDATE Usage notes v SQLJ supports both positioned and searched DELETE and UPDATE operations. v For a FETCH statement, a positioned DELETE statement, or a positioned UPDATE statement, you must use an iterator to refer to rows in a result table. [. . . ] See write to operator. | | | | XML lock A column-level lock for XML data. XML node The smallest unit of valid, complete structure in a document. For example, a node can represent an element, an attribute, or a text string. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | XML node ID index An implicitly created index, on an XML table that provides efficient access to XML documents and navigation among multiple XML data rows in the same document. XML pattern A slash-separated list of element names, an optional attribute name (at the end), or kind tests, that describe a path within an XML document in an XML column. [. . . ]