Database protocols user interface
The Inbound (Outbound) SQL Statement Configurator is composed of Options and SQL panels.
Clicking Inbound (Outbound) SQL Statement Configurator enables , , and Condition.
on theThe Table Selection dialog box contains a list of all tables in the current database connection.
- Clicking Select Column dialog box. This lists all the column names of the currently selected table/view. beside opens the
- Clicking Condition displays the Configure
Condition dialog box.
The Outbound staging Fields list box contains all the field addresses in the currently selected Outbound Staging Message format.
beside
In the Options panel, the Table/View Schema list displays all the column names in the selected table/view as defined in the Inbound (Outbound) SQL Statement Configurator dialog box.
Double-clicking or selecting an item in the Outbound Staging Message fields list or Table/View Columns list appends the item to the cursor position in the Condition text area. The name is enclosed with angle brackets.
Database Outbound protocol: VRL
You can use the Database Outbound Protocol dialog box to select VRL or Table Schema as the data format. This also applies to the Inbound (Outbound) SQL Statement Configurator dialog box.
The Stored Procedure Configurator dialog box is used to select VRL or Table Schema as the data format. The Columns list supports both VRL field names and Database columns.
SQL Configuration: All database tables support
The Inbound (Outbound) SQL Statement Configurator dialog box can access all tables and views in the current database connection.
Lookup Table: Stored Procedure support
In the Stored Procedure Out Parameters dialog box.
configuration, you can make free text edits to the database statements. and are used to indicate the type of database statement. Clicking enables theThis dialog box contains check boxes that you can use to define the expected return from the stored procedure:
One of these must be selected. All are selected by default.
Database Configuration: Connect success
You can manually enter SQL statements to be run upon a successful connection. Global variable substitution is supported for the SQL statements. If the SQL fails to successfully run, then the thread enters an error state. Errors are logged and added to the protocol error field in thread statistics.
The Database protocol Testing Tool is supported.