Field | Description/Action |
Connection alias name | Name of the JMS connection alias configured on Integration Server. If the connection alias is a Broker Cluster configured with Multisend Guaranteed policy, you must add the watt property watt.art.notification.jmsSend.usePublicService and set it to true. Note: Adapter Runtime does not support LOCAL_TRANSACTION and XA_TRANSACTION type JMS connection alias. |
Destination name | Name of the destination from which you want the JMS trigger to receive messages. |
Destination type | Specify whether the destination is a Queue (default) or a Topic. |
Field | Description/Action |
Catalog Name | Name of the catalog. The default for the catalog name is current catalog. |
Schema Name | Name of the schema. The default for the schema name is current schema. Note: You can disable the lookup performed on the database for schema name by configuring the Schema Name parameter in the Configuration tab. |
Procedure Name Pattern | To save time, you can type all or part of the procedure name in this field to narrow your search. This is helpful when dealing with a large database that has a long list of procedures. Use % as a multi-character wildcard and _ (underscore) as a single character wildcard. Note: With DB2 databases, functions do not appear in the list of procedure names. Only procedures appear in the list. Note: If you disable the lookup performed on the database for stored procedure name by configuring the Procedure Name parameter in the Configuration tab, the value in the Procedure Name Pattern field is not taken into consideration OR is ignored. |
Procedure Name | Type or select the stored procedure name, depending on how you set the Procedure Name Pattern field. If you select <All Procedures>, this field lists all of the procedures in the selected catalog and schema. Note: You can disable the lookup performed on the database for stored procedure name by configuring the Procedure Name parameter in the Configuration tab. |
Publish Locally | Specifies whether to publish the notification's publishable document to the local Integration Server. By default, this option is not selected, that is, if the Broker is configured to Integration Server, the publishable document is published to the Broker; otherwise the publishable document is published to the local Integration Server. Selecting the Publish Locally option reduces performance problems, if Integration Server is connecting to a remotely located Broker that is in turn triggering a service on the local Integration Server. |
Field | Description/Action |
Parameter Name | Stored procedure parameter name. |
SQL Type | SQL data type of the database column. |
JDBC Type | JDBC data type of the stored procedure parameter. |
Parameter Type | Defines the parameter type as IN, INOUT, or OUT. If you select IN or INOUT, you may also set the input expression in the Expression field. |
Expression* | Sets the input for the IN or INOUT parameter types only. The RETURN or OUT parameters will appear automatically on the Call tab's bottom table. For a list of the allowable expression settings by parameter type, and how each parameter will map to the input or output fields, see the following table. |
Parameter Type | Expression | Input or Output Mapping? |
RETURN | Empty (default) | Output field |
OUT | Empty (default) | Output field |
IN | Default is empty, but it needs to be updated with a fixed value. | No mapping |
INOUT | Empty (default) | Output field |
ORACLE CURSOR (INOUT) | Empty (default) | Output field. Set the parameters in the ResultSet tab as described later in the procedure. |
Field | Description/Action |
Output Parameter Name | Stored procedure output parameter name. |
SQL Type | SQL data type of the database column. |
JDBC Type | JDBC data type of the output parameter. |
Output Field | Name of the output parameter. |
Output Field Type | Output parameter Java data type. For a list of JDBC to Java data type mappings, see
JDBC Data Type to Java Data Type
Mappings. |
Field | Description/Action |
Query Time Out | Query time out value in seconds. This value is the amount of time Adapter for JDBC waits for the notification to execute before stopping the SQL operation. The default value is -1. Use the default value to have the notification use the value indicated on the watt.adapter.JDBC.QueryTimeout property as the time out. If you specify a value equal to 0, or if the watt.adapter.JDBC.QueryTimeout property is not set, the notification executes without a time out. If you specify a value greater than 0, the notification executes with the specified value as the time out. Note: -1 is the only permissible negative value for this field. For more information about the watt.adapter.JDBC.QueryTimeout property, see
Forcing a Timeout During Long-Running SQL
Operations in Services and Notifications. |
Field Name | Use Lookup |
Schema Name | Performs a lookup on the database for schema name. Possible values are: true. Default. Performs a lookup on the database for schema name. false. Skips the lookup on the database for schema name. The Schema Name field is now editable and you can enter the value. |
Procedure Name | Performs a lookup on the database for procedure name. Possible values are: true. Default. Performs a lookup on the database for procedure name. false. Skips the lookup on the database for procedure name. The Procedure Name field is now editable and you can enter the value. Note: The value in the Procedure Name Pattern field is not taken into consideration/ignored. |
Field | Description/Action |
Result Set Index | An index is automatically assigned to each result set. The first row default value is 1. |
Result Set Name | The name of the result set you want to create. |
Result Set Name(from second row) | Select result set name. |
Column Name | The name of the column of the result set. |
JDBC Type | The JDBC data type of the result column. |
Output Type | The Java data type of the result column. For a list of JDBC to Java data type mappings, see
JDBC Data Type to Java Data Type
Mappings. |