JMS CSV Input Adapter

Adapter type: jms_csv_in. The JMS CSV Input adapter subscribes to text messages formatted as a delimited list of values, and writes them as stream records.

If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.

When the delimiter is set to a comma (,) and the expectStreamNameOpcode is set to true, the JMS CSV Input adapter expects the input stream to be formatted as:

aaa,11,111,1.100000,2008-03-13T08:19:30,111.1111,2008-03-13T08:19:30.123,false,FF00FE05FF,2008-03-13T08:19:30.123456,64000,922.0,337.000000000000000

The stream contains these columns:

stringCol
int32Col
int64Col
doubleCol
dateCol
moneyCol
timestampCol
booleanCol
binaryCol
bigdatetimeCol
intervalCol
money1Col
money15Col

<RecordType name="StreamIn_rec">
	<Column datatype="string" key="true" name="stringCol" />
	<Column datatype="integer" key="false" name="int32Col" />
	<Column datatype="long" key="false" name="int64Col" />
	<Column datatype="float" key="false" name="doubleCol" />
	<Column datatype="date" key="false" name="dateCol" />
	<Column datatype="money" key="false" name="moneyCol" />
	<Column datatype="timestamp" key="false" name="timestampCol" />
	<Column datatype="boolean" key="false" name="booleanCol" />
	<Column datatype="binary" key="false" name="binaryCol" />
	<Column datatype="bigdatetime" key="false" name="bigdatetimeCol" />
	<Column datatype="interval" key="false" name="intervalCol" />
	<Column datatype="money(1)" key="false" name="money1Col" />
	<Column datatype="money(15)" key="false" name="money15Col" />                     
</RecordType>

Property Label	Description
Delimiter	Property ID: delimiter Type: `string` (Required) Field delimiter. Default value is a comma (,).
Connection Factory	Property ID: connectionFactory Type: `string` (Required) Connection factory class name. No default value.
JNDI Context Factory	Property ID: jndiContextFactory Type: `string` (Required) Context factory for JNDI context initialization. No default value.
JNDI URL	Property ID: jndiURL Type: `string` (Required) JNDI URL. No default value.
Destination Type	Property ID: destinationType Type: `choice` (Required) Destination type. Valid values are: QUEUE TOPIC Default value is QUEUE.
Destination Name	Property ID: destinationName Type: `string` (Required) Destination name. No default value.
Subscription Mode	Property ID: subscriptionMode Type: `choice` (Optional) Specifies the subscription mode for TOPIC. Default value is NONDURABLE. Valid values are DURABLE and NONDURABLE.
Client ID	Property ID: clientID Type: `string` (Optional) Specifies the client identifier for the connection that is identifying durable subscription. No default value.
Subscription Name	Property ID: subscriptionName Type: `string` (Optional) Specifies a unique name identifying a durable subscription. No default value.
Batch Size	Property ID: batchsize Type: `uint` (Optional) Specifies number of records in a batch to commit in durable subscription mode. Default value is 1.
Stream Name Opcode Expected	Property ID: expectStreamNameOpcode Type: `boolean` (Advanced) If true, the first two fields in CSV records are interpreted as stream name, and opcode. An empty string is a valid value. Default value is false.
Date Format	Property ID: dateFormat Type: `string` (Advanced) Date format. Default value is YYYY-MM-DDTHH:MM:SS.SSS .
Timestamp Format	Property ID: timestampFormat Type: `string` (Advanced) Timestamp format. Default value is YYYY-MM-DDTHH:MM:SS.SSS.
PropertySet	Property ID: propertyset Type: `string` (Advanced) Specifies the name of the property set from the project configuration file. If you specify the same properties in the project configuration file and the ATTACH ADAPTER statement, the values in the property set override the values defined in the ATTACH ADAPTER statement. No default value.

Known limitations:

If the connection to the message broker is lost, the adapter does not attempt to reconnect.