WebSphere MQ Input Adapter

Adapter type: wsmq_in. The default WebSphere MQ Input adapter reads a string in CSV format.

Ensure the order of the data in the message matches the schema of the input stream to which the adapter is attached. The WebSphere MQ Input adapter applies stream names and opcode instructions (INSERT, DELETE, UPDATE, UPSERT) to CSV data pulled from a queue. See the expectStreamNameOpcode property.

Note: If you are reading data from WSMQ using the WebSphere MQ Input adapter, but publishing data using a JMS program rather than the WebSphere MQ Output adapter, set the following line in the JMS program: queue.setTargetClient(com.ibm.mq.jms.JMSC.MQJMS_CLIENT_NONJMS_MQ);.

To run the adapter successfully in Linux and UNIX installations, set the LD_LIBRARY_PATH to point to the MQ client libraries.

If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type. The type for this adapter is wsmq_in.

Note: To avoid data loss in the case of a server failure, Sybase recommends you attach a log store to an input window.

Property Label	Property ID	Type	Description
Queue Name	QueueName	`string`	(Required) The name of the queue on the server to send messages. This queue must be managed by the indicated Queue Manager Name. No default value.
Queue Manager Name	QueueManagerName	`string`	(Required) The name of the queue manager on the server to send messages to. No default value.
MQ System Name	SystemName	`string`	(Required) The name of the MQ server system. This may be a symbolic name or an IP address. No default value.
Port	Port	`string`	(Required) The port number on the MQ server system to which the MQ server queue listener is attached. No default value.
MQ Channel	Channel	`string`	(Required) The name of the MQ server channel associated with the queue. No default value.
Maximum Input Buffer Size	MaxBufferSize	`uint`	(Required) The maximum size of the buffer, in bytes. No default value.
Sync Point Commit Mode	syncpointmode	`boolean`	(Optional) Enables sync point commit mode. Set this to ensure guaranteed delivery of messages from the adapter to the Server. Default value is false.
Batch Size	batchsize	`uint`	(Optional) Specifies number of records in a batch to commit in sync point commit mode. Default value is 1.
CSV Delimiters	CsvSeparators	`string`	(Optional) The CSV field separators. Can be multiple characters. Default value is a comma ( , ).
CSV Escape Characters	CsvEscapeChars	`string`	(Optional) The character that escapes the meaning of special characters, including the delimiters, escape characters, and quote characters. Can be multiple characters. Default value is a backslash ( \ ).
CSV Quote Characters	CsvQuoteChars	`string`	(Optional) The characters to delineate the beginning and end of a field. Default value is double quotes ( " ).
Perform CSV Trimming	CsvTrimming	`boolean`	(Optional) If set to true, this trims leading and trailing whitespace from the beginning and end of each field. If true, a quoted field containing nothing but spaces is interpreted as NULL. Default value is true.
Stream Name, Opcode Expected	TimestampColumnFormat	`string`	(Optional) The format for timestamp values. Default value is YYYY-MM-DDTHH:MM:SS.SSS.
Timestamp Column Format	expectStreamNameOpcode	`boolean`	(Advanced) If true, the first two fields in CSV records are interpreted as stream name, opcode. Default value is false.
Date Column Name	DateColumnName	`string`	(Advanced) The format in which date values are stored in the file. 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.