The default output WebSphere MQ adapter publishes a string in CSV format. The WebSphere MQ adapter does not produce a header line because the schema of the stream publishing to the adapter determines the order and data types of the fields. Columns are published in the default display format for the appropriate data type.
Ensure the WebSphere MQ output adapter is pointing to the $SYCEP location, /remote/supreme2/SYCEP/SybaseC8/server/SybaseC8Repository/examples/FeatureExamples/Data/stock-trades.csv.
Configure the following properties as necessary to customize the output string of your WebSphere MQ Adapter:
| Property Name (screen) | Property Name (Attach Adapter) | Type | Description | Required? |
| Queue Name | QueueName | String | The name of the queue on the server to send messages. This queue must be managed by the indicated Queue Manager Name. | Required |
| Queue Manager Name | QueueManagerName | String | The name of the queue manager on the server to send messages. | Required |
| MQ System Name | SystemName | String | The name of the MQ server system. This may be a symbolic name or an IP address. | Required |
| Port | Port | String | The port number on the MQ server system to which the MQ server queue listener is attached. | Required |
| MQ Channel | Channel | String | The name of the MQ server channel associated with the queue. | Required |
| CSV Field Separator | CsvSeparatorChar | String | The CSV field separator. Must be a single character. Defaults to a comma. | No |
| CSV Escape Character | CsvEscapeChar | String | The character to escape the meaning of special characters, including the field separator, escape character, and quote character. Defaults to a backslash. | No |
| CSV Quote Character | CsvQuoteChar | String | The character to delineate the beginning and end of a field, which can include anything. Any embedded quote characters are escaped. Defaults to a double quote. | No |
| Timestamp Column Format | TimestampColumnFormat | String | The format for timestamp values. See "Timestamp Format Codes" in the Sybase CEP CCL Reference for more information. If omitted, defaults to "YYYY/MM/DD HH24:MI:SS.FF". If blank, timestamps are published as the number of microseconds since No 7 the epoch (midnight, January 1, 1970). | No |
Note: This adapter uses TCP/IP for transfers. If you want to use other protocols, you must determine the appropriate configuration and interface parameters for those protocols.