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. The type for this adapter is jms_csv_in.

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 the following 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. Default value is false.
Note: An empty string is a valid value.
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 (a group of properties and values) you want to use 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:

Parent topic: JMS Adapter
Related concepts
Guaranteed Delivery