Iterator - iterate through JDBC result set

Description - SQL Select Iterator; Send out one row at a time to the flow

Runtime Class - com.ibi.agents.XDIterSQLSelect

Parameter Groups

	Parameter	Type	Description
*	Select SQL:	string	SQL Select statement to get rows to pass into the flow
	Isolation Level:	string	Transaction isolation level to be set if possible Select from one of the following options: As Is {asis} - Leave the isolation level as defined in the data base Read Uncommitted {readUncommitted} - Allows reading of a record that may be rolled back later Read Committed {readCommitted} - Will never read data that another application has changed and not yet committed, but does not ensure that the data will not be changed before the end of the transaction Repeatable Read {repeatableRead} - Dirty reads and nonrepeatable reads cannot occur; all data used in the query is locked, and other transactions cannot update the data Serializable {serializable} - Most restrictive isolation level. Phantom values cannot occur; prevents other users from updating or inserting rows into the data set until the transaction is completed

* - denotes required

	Parameter	Type	Description
	Base 64:	boolean	If set, all fields are checked for base64 (this is expensive)
	SQLAgent Format:	boolean	If true, the generated rows are formatted according to SQLAgent field schema
	Inline xLOBs:	boolean	If true, character and boolean large objects are inline in the select results. BLOBs are enclosed in base64() tags.
*	Input Encoding:	string	The IANA character set to be used for the input data base. Select from the standard list or enter an encoding name. Select from one of the following options: Leave {leave} - Make no changes (input document carries encoding) Platform {platform} - Use platform's encoding, not inbound message encoding US-ASCII - Seven-bit ASCII, a.k.a. ISO646-US, a.k.a. the Basic Latin block of the Unicode character set CP-037/EBCDIC {CP037} - Eight but EBCDIC encoding ISO-8859-1 - ISO Latin Alphabet No. 1, a.k.a. ISO-LATIN-1 UTF-8 - Eight-bit UCS Transformation Format UTF16-BE {UTF-16BE} - Sixteen-bit UCS Transformation Format, big-endian byte order UTF16-LE {UTF-16LE} - Sixteen-bit UCS Transformation Format, little-endian byte order UTF16 {UTF-16} - Sixteen-bit UCS Transformation Format, byte order identified by [optional] byte order mark
	Three Part Name:	boolean	If true, names will be presented as full three part names if supported by the data base

* - denotes required

	Parameter	Type	Description
	Document:	string	Whether output document emitted should be the original input document (original) or a status document (status) Select from one of the following options: Status Document {status} - An exit-appropriate status document Input Document {input} - The original input document Loop Accumulation {accumin} - Accumulation of the input loop elements sent from the flow back into the iterator at each pass. The loop may have modified the document passed to the accumulation. For XML, the root name will be the node name. Use of accumulation can result in significant use of memory. Iterated Accumulation {accumout} - Accumulation of the output iterated elements of each pass; these are the documents that the loop services receive from the iterator. For XML, the root name will be the node name. Use of accumulation can result in significant use of memory.

* - denotes required

Output Events

Name	Description
OnCancelled	The service has responded to a cancellation request.
OnParseError	Could not parse a document.
OnFailedOperation	Could not perform the operation requested.
fail_operation_source	Could not perform the inbound operation.
fail_connect_source	Failed creating inbound connection.