Adapter type: toolkit_jms_csv_input. Set these properties for the JMS CSV Input adapter in the ESP Studio adapter properties dialog.
If you use the CCL ATTACH ADAPTER statement to attach an adapter, you must supply the adapter type.
| Property Label | Description |
|---|---|
| Column Delimiter |
Property ID: csvDelimiter Type: string (Advanced) Specify the symbol used to separate the columns. |
| Date Format |
Propterty ID: csvDateFormat Type: string (Advanced) Specify the format for parsing date values. |
| Timestamp Format |
Property ID: csvTimestampFormat Type: string (Advanced) Specify the format for parsing timestamp values. |
| Has Header |
Property ID: csvHasHeader Type: boolean (Advanced) Indicate whether the first line of the file contains the description of the CSV fields. |
| Steam name, opcode expected |
Property ID: csvExpectStreamNameOpcode Type: boolean (Optional) If set to true, the adapter interprets the first two fields of the incoming CSV line as stream name and opcode. The adapter discards messages with unmatched values. |
| Connection Factory |
Property ID: connectionFactory Type: string (Required) Connection factory name. |
| JNDI Context Factory |
Property ID: jndiContextFactory Type: string (Required) Context factory for JDNI context initialization. |
| JNDI URL |
Property ID: jdniURL Type: string (Required) JDNI URL. |
| JMS Destination Type |
Property ID: destinationType Type: string (Required) Specify the destination type. Valid values: QUEUE, TOPIC. |
| Destination Name |
Property ID: destinationName Type: string (Required) Specify the destination name. |
| Subscription Mode |
Property ID: subscriptionMode Type: string (Optional) Specify the subscription mode. Valid values: DURABLE, NONDURABLE. |
| Scan Depth |
Property ID: scanDepth Type: int (Advanced) Specify the depth of the schema discovery. The adapter reads the number of rows specified by this parameter value when discovering the input data scheme. |
| Client ID |
Property ID: clientID Type: string (Advanced) Specify the client identifier (required when durable subscription is enabled). |
| Subscription Name |
Property ID: subscriptionName Type: string (Advanced) Specify a unique name identifying a durable subscription. |
|
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. |