Browsing Database Tables
Use the Browse Database Tables dialog box to dynamically
select a table from the current list of tables in the database specified
by the Endpoint.
Character Encodings
Set the character encoding at the database level, the table
level, or the column or parameter level.
MaxPooledStatements Parameter
The MaxPooledStatements parameter
is automatically defined and set with a default value for all types
of Database Endpoints.
Oracle, Sybase, DB2, and Informix Parameters
In the Additional Parameters table
of the Database Endpoint, define the connection parameters for Oracle,
Sybase, DB2, or Informix databases.
Retry Options For Inbound Database Activities
This section contains the procedure for configuring the retry
options for the following inbound database activities: Get Inserted
Rows activity, Get Updated Rows activity, Get Deleted
Rows activity, and Poll Table activity.
Retry Options For Outbound Database Activities
This section contains the procedure for configuring the retry
options for the following outbound database activities: Execute
Query activity, Insert Rows activity, Update Rows activity, Delete
Rows activity, and Call Procedure activity
Single-Table Inbound Database Activities
During run time, single-table inbound database activities
poll if a database operation has occurred on any rows in the specified
columns of a database table at the specified time interval.
Viewing Column Details
The View Column dialog box allows you to see detailed column
information for tables as you enter a SQL statement in the Enter
Query task of the Checklist for the Execute Query activity.
This task describes how to access the View Column Details dialog box.
Call Procedure Activity
During run time, the Call Procedure activity
runs a stored procedure in a database. The stored procedure must be
written and installed in the database before you can complete the
configuration of the Call Procedure activity
in Studio.
Execute Query Activity
During run time, the Execute Query activity
runs a select SQL statement.
Poll Table Activity
The Poll Table activity checks if
a database operation (insert or update) has occurred on any rows of
a database table by checking the status of a special flag column at
the specified time interval.