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. [. . . ] dataSource For a connection context, specifies the logical name of a separately-created DataSource object that represents the data source to which the application will connect. This option is available only for the IBM Data Server Driver for JDBC and SQLJ. Usage notes v The value on the left side of a with element must be unique within its with clause. v If you specify updateColumns in a with element of an iterator declaration clause, the iterator declaration clause must also contain an implements clause that specifies the sqlj. runtime. ForUpdate interface. v If you do not customize your SQLJ program, the JDBC driver ignores the value of holdability that is in the with clause. Instead, the driver uses the JDBC driver setting for holdability. Related concepts "SQLJ and JDBC in the same application" on page 139 Related tasks "Connecting to a data source using SQLJ" on page 103 "Performing positioned UPDATE and DELETE operations in an SQLJ application" on page 114 "Using scrollable iterators in an SQLJ application" on page 130 Related reference "SQLJ connection-declaration-clause" on page 285 284 Application Programming Guide and Reference for JavaTM SQLJ connection-declaration-clause The connection declaration clause declares a connection to a data source in an SQLJ application program. Syntax context Java-class-name Java-modifiers implements-clause with-clause Description Java-modifiers Specifies modifiers that are valid for Java class declarations, such as static, public, private, or protected. Java-class-name Specifies a valid Java identifier. During the program preparation process, SQLJ generates a connection context class whose name is this identifier. implements-clause See SQLJ implements-clause for a description of this clause. In a connection declaration clause, the interface class to which the implements clause refers must be a user-defined interface class. with-clause See SQLJ with-clause for a description of this clause. Usage notes v SQLJ generates a connection class declaration for each connection declaration clause you specify. SQLJ data source connections are objects of those generated connection classes. v You can specify a connection declaration clause anywhere that a Java class definition can appear in a Java program. 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. An iterator contains the result table from a query. SQLJ generates an iterator class for each iterator declaration clause you specify. An iterator is an object of an iterator class. 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. Java-class-name Any valid Java identifier. During the program preparation process, SQLJ generates an iterator class whose name is this identifier. [. . . ] 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. The pattern is a restrictive form of path expressions, and it selects nodes that match the specifications. XML patterns are specified to create indexes on XML columns in a database. XML publishing function A function that returns an XML value from SQL values. [. . . ]