You can use the Choose JDBC Connection dialog box to choose the JDBC connection via which to add a stored procedure or imported SQL to use for the dataset you are creating. This topic describes the options in the dialog box.
Designer displays the Choose JDBC Connection dialog box when you select <Add Stored Procedure...> or <Add Imported SQL...> in the dialog box where a stored procedure or imported SQL list is available and the specified catalog data source contains more than one connection.
You see the following options in the dialog box:
Connection drop-down list
This list contains all the JDBC connections you have created in the specified catalog data source. Select the JDBC connection you need.
<Add JDBC Connection...>
Select to set up a new JDBC connection in the Get JDBC Connection Information dialog box.
Select to use the specified JDBC connection and close the dialog box.
Select to quit choosing the connection and close the dialog box.
Select to view information about the dialog box.