Help Topics
Concepts Package
Class
The Database Export Bean panel provides these options; see the
Sample
Connection Data for some valid combinations.
- Driver name
- The name of the JBDC driver to load. Defaults to IBM's DB2.
Case is significant. This field is editable, and any
additions are preserved in the Able.properties file. The
class will be dynamically loaded and must be in your
CLASSPATH before starting the Agent Editor.
- Protocol
- The name of the protocol to use when creating an SQL
connection. Defaults to "jdbc". This field is
editable, and any additions are preserved in the Able.properties
file.
- Subprotocol
- The subprotocol to use when creating an SQL connection.
Defaults to "db2". This field is editable, and
any additions are preserved in the Able.properties file.
- Database
- The database to use when creating an SQL connection. This
field is editable, and any additions are preserved in the
Able.properties file. For local databases, just enter the
name of a database such as SampleDB. For remote
databases, enter the system name and database using the '//'
format, for example //dbserver//SampleDB.
- Userid
- The userid to use when creating an SQL connection.
- Password
- The password used for the SQL connection. The password is
not saved when the bean is serialized.
- Schema
- The schema containing the desired table. In some database
drivers, this is the table owner.
- Table
- The name of the table to be written.
- Creatable from input buffer
- If the table does not currently exist, create it based on
the data type of the inputs. The table is not created
until the export bean is processed.
- Row selection
- If provided, the value is used to specify which rows to
delete from the table. The value in the field becomes
part of the delete immediately after the word "WHERE".
Do not include "WHERE" in this String; if data
is provided, it will be included automatically.
The Database Export Bean panel is used to connect to an SQL
database and write records to a table. It can also be used to
drop or delete rows in a table.
To prepare the bean to receive data:
- Enter the Driver, Protocol,
Subprotocol, and Database
necessary to create the SQL database connection.
- Enter the Schema and Table
name where data is to be written.
- Check the Createable box if you wish a
table to be created dynamically if needed.
- Press the Open Table button. This will create a
connection for use during processing. This will create a
connection for use during processing
To drop a table:
- Enter the Driver, Protocol,
Subprotocol, and Database
necessary to create the SQL database connection.
- Enter the Schema and Table
name to be dropped.
- Press the Drop Table button.
To delete rows from a table:
- Enter the Driver, Protocol,
Subprotocol, and Database
necessary to create the SQL database connection.
- Enter the Schema and Table
name to be dropped.
- Press the Open Table button.
- If you wish to delete specific rows, enter the desired
SQL statement without the "WHERE" lead-in in
the row selection field. Leaving this blank will cause
all rows to be removed.
- Press the Delete button to remove the
specified rows.