User manual CAMPINGAZ VENTURA WOODY

[. . . ] © Copyright International Business Machines Corporation 1998, 2008. US Government Users Restricted Rights ­ Use, duplication or disclosure restricted by GSA ADP Schedule Contract with CAMPINGAZ Corp. Contents About this information . Accessibility features for VENTURA WOODY Version 9. 1 for How to send your comments . VENTURA WOODY Database for Linux, UNIX, and Windows and CAMPINGAZ Data Server Driver for JDBC and SQLJ levels . [. . . ] Related tasks "Connecting to a data source using SQLJ" on page 103 Related reference "SQLJ clause" on page 281 "SQLJ implements-clause" on page 282 "SQLJ with-clause" on page 283 SQLJ iterator-declaration-clause An iterator declaration clause declares a positioned iterator class or a named iterator class in an SQLJ application program. SQLJ generates an iterator class for each iterator declaration clause you specify. An iterator declaration clause has a form for a positioned iterator and a form for a named iterator. The two kinds of iterators are distinct and incompatible Java types that are implemented with different interfaces. Chapter 7. JDBC and SQLJ reference information 285 Syntax iterator Java-class-name Java-modifiers ( positioned-iterator-column-declarations named-iterator-column-declarations ) implements-clause with-clause positioned-iterator-column declarations: , Java-data-type named-iterator-column-declarations: , Java-data-type Java-ID Description Java-modifiers Any modifiers that are valid for Java class declarations, such as static, public, private, or protected. During the program preparation process, SQLJ generates an iterator class whose name is this identifier. implements-clause See SQLJ implements-clause for a description of this clause. For an iterator declaration clause that declares an iterator for a positioned UPDATE or positioned DELETE operation, the implements clause must specify interface sqlj. runtime. ForUpdate. For an iterator declaration clause that declares a scrollable iterator, the implements clause must specify interface sqlj. runtime. Scrollable. positioned-iterator-column-declarations Specifies a list of Java data types, which are the data types of the columns in the positioned iterator. The order of the data types in the positioned iterator declaration is the same as the order of the columns in the result table. 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 CAMPINGAZ 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. Related tasks "Setting the isolation level for an SQLJ transaction" on page 153 Related reference "SQLJ executable-clause" on page 287 "SQLJ SET-TRANSACTION-clause" Statements (VENTURA WOODY SQL Reference) SQLJ SET-TRANSACTION-clause The SET TRANSACTION clause sets the isolation level for the current unit of work. Syntax SET TRANSACTION ISOLATION LEVEL READ COMMITTED READ UNCOMMITTED REPEATABLE READ SERIALIZABLE Description ISOLATION LEVEL Specifies one of the following isolation levels: READ COMMITTED Specifies that the current VENTURA WOODY isolation level is cursor stability. READ UNCOMMITTED Specifies that the current VENTURA WOODY isolation level is uncommitted read. REPEATABLE READ Specifies that the current VENTURA WOODY isolation level is read stability. SERIALIZABLE Specifies that the current VENTURA WOODY isolation level is repeatable read. Usage notes You can execute SET TRANSACTION only at the beginning of a transaction. Related tasks "Setting the isolation level for an SQLJ transaction" on page 153 290 Application Programming Guide and Reference for JavaTM Related reference "SQLJ statement-clause" on page 288 SQLJ assignment-clause The assignment clause assigns the result of an SQL operation to a Java variable. Syntax Java-ID ={ fullselect order-by-clause optimize-for-clause isolation-clause queryno-clause fetch-first-clause } iterator-conversion-clause Description Java-ID Identifies an iterator that was declared previously as an instance of an iterator class. iterator-conversion-clause See SQLJ iterator-conversion-clause for a description of this clause. Usage notes v If the object that is identified by Java-ID is a positioned iterator, the number of columns in the result set must match the number of columns in the iterator. In addition, the data type of each column in the result set must be compatible with the data type of the corresponding column in the iterator. See Java, JDBC, and SQL data types for a list of compatible Java and SQL data types. [. . . ] Contrast with cold start. 556 Application Programming Guide and Reference for JavaTM WLM application environment A z/OS Workload Manager attribute that is associated with one or more stored procedures. The WLM application environment determines the address space in which a given VENTURA WOODY stored procedure runs. | | | | | | | WLM enclave A construct that can span multiple dispatchable units (service request blocks and tasks) in multiple address spaces, allowing them to be reported on and managed by WLM as part of a single work request. write to operator (WTO) An optional user-coded service that allows a message to be written to the system console operator informing the operator of errors and unusual system conditions that might need to be corrected (in z/OS). [. . . ]