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	Property ID	Type	Description
Delimiter	delimiter	`string`	(Required) Field delimiter. Default value is a comma (,).
Connection Factory	connectionFactory	`string`	(Required) Connection factory class name. No default value.
JNDI Context Factory	jndiContextFactory	`string`	(Required) Context factory for JNDI context initialization. No default value.
JNDI URL	jndiURL	`string`	(Required) JNDI URL. No default value.
Destination Type	destinationType	`choice`	(Required) Destination type. Valid values are: QUEUE TOPIC Default value is QUEUE.
Destination Name	destinationName	`string`	(Required) Destination name. No default value.
Subscription Mode	subscriptionMode	`choice`	(Optional) Specifies the subscription mode for TOPIC. Default value is NONDURABLE. Valid values are DURABLE and NONDURABLE.
Client ID	clientID	`string`	(Optional) Specifies the client identifier for the connection that is identifying durable subscription. No default value.
Subscription Name	subscriptionName	`string`	(Optional) Specifies a unique name identifying a durable subscription. No default value.
Batch Size	batchsize	`uint`	(Optional) Specifies number of records in a batch to commit in durable subscription mode. Default value is 1.
Stream Name Opcode Expected	expectStreamNameOpcode	`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	dateFormat	`string`	(Advanced) Date format. Default value is YYYY-MM-DDTHH:MM:SS.SSS.
Timestamp Format	timestampFormat	`string`	(Advanced) Timestamp format. Default value is YYYY-MM-DDTHH:MM:SS.SSS.
PropertySet	propertyset	`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.