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.

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

Property Label	Description
Queue Name	Property ID: QueueName Type: `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	Property ID: QueueManagerName Type: `string` (Required) The name of the queue manager on the server to send messages to. No default value.
MQ System Name	Property ID: SystemName Type: `string` (Required) The name of the MQ server system. This may be a symbolic name or an IP address. No default value.
Port	Property ID: Port Type: `string` (Required) The port number on the MQ server system to which the MQ server queue listener is attached. No default value.
MQ Channel	Property ID: Channel Type: `string` (Required) The name of the MQ server channel associated with the queue. No default value.
Maximum Input Buffer Size	Property ID: MaxBufferSize Type: `uint` (Required) The maximum size of the buffer, in bytes. No default value.
Sync Point Commit Mode	Property ID: syncpointmode Type: `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	Property ID: batchsize Type: `uint` (Optional) Specifies number of records in a batch to commit in sync point commit mode. Default value is 1.
CSV Delimiters	Property ID: CsvSeparators Type: `string` (Optional) The CSV field separators. Can be multiple characters. Default value is a comma ( , ).
CSV Escape Characters	Property ID: CsvEscapeChars Type: `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	Property ID: CsvQuoteChars Type: `string` (Optional) The characters to delineate the beginning and end of a field. Default value is double quotes ( " ).
Perform CSV Trimming	Property ID: CsvTrimming Type: `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	Property ID: TimestampColumnFormat Type: `string` (Optional) The format for timestamp values. Default value is YYYY-MM-DDTHH:MM:SS.SSS.
Timestamp Column Format	Property ID: expectStreamNameOpcode Type: `boolean` (Advanced) If true, the first two fields in CSV records are interpreted as stream name, opcode. Default value is false.
Date Column Name	Property ID: DateColumnName Type: `string` (Advanced) The format in which date values are stored in the file. Default value is YYYY-MM-DDTHH:MM:SS.SSS.
Delay Between Reconnection Attempts	Property ID: reconnectAttemptDelayMSec Type: `int` (Advanced) Number of milliseconds between attempts to reconnect to the WebSphere MQ server. Default value is 1000.
Maximum Number of Reconnection Attempts	Property ID: maxReconnectAttempts Type: `int` (Advanced) Number of attempts at reconnecting to the WebSphere MQ server before stopping. Use -1 to retry an unlimited number of times. Default value is 1.
PropertySet	Property ID: propertyset Type: `string` (Advanced) Specifies the name of the property set. Property sets are reusable sets of properties that are stored in the project configuration file. Using these sets allows you to move adapter configuration properties out of the CCL file and into the CCR 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.