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 schema lookup performed on the database 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: The Procedure Name Pattern field value is not considered if you disable the store procedure lookup performed on the database. |
Procedure Name | Select the stored procedure name, depending on the 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 store procedure lookup performed on the database by configuring the Procedure Name parameter in the Configuration tab. |
Specific Name (Only for DB2 and DB2AS400) | Select the specific name for a stored procedure in a DB2 or DB2 AS/400 database after specifying the Procedure Name. |
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) | Input field |
Fixed value | No mapping | |
INOUT | ? (default) | Input and output field |
Empty | Output field | |
ORACLE CURSOR (INOUT) | Empty (default) | Output field |
Field | Description/Action |
Input Parameter Name | Stored procedure input parameter name. |
SQL Type | The SQL data type of the database column. |
JDBC Type | JDBC data type of the input parameter. |
Input Field | Name of any input parameters. |
Input Field Type | Input parameter Java data type. For a list of JDBC type to Java data type mappings, see
JDBC Data Type to Java Data Type
Mappings. |
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 service to execute before stopping the SQL operation. The time out specified in the Query Time Out field is not guaranteed but depends on the implementation specific to the driver vendor. The JDBC standard Statement.SetQueryTimeout() method relies on the Statement.cancel() method. When execution takes longer than the specified time-out interval, the monitor thread calls Statement.cancel(). In some cases, because of a limitation in the Statement.cancel() method, the time out does not free the thread that invoked the Statement.execute() method and this may lead to higher waiting times. The default value is -1. Use the default value to have the service 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 service executes without a time out. If you specify a value greater than 0, the service 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: ![]() ![]() |
Procedure Name | Performs a lookup on the database for procedure name. Possible values are: ![]() ![]() Note: The value in the Procedure Name Pattern field is not considered. |
Field | Description/Action |
Result Set Index | An index is automatically assigned to each result set. The first row default value is 1. Note: When using for Oracle database, this field is not required. |
Result Set Name | Name of the result set you want to create. Note: When using for Oracle database, this field is not required. |
Result Set Name (from second row) | Select result set name. |
Column Name | Name of the column of the result set. |
JDBC Type | JDBC data type of the result column. |
Output Type | 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. |