Руководство Пользователя для Cisco Cisco Workload Automation 6.3
25
Defining JDBC Jobs
Adding a JDBC SQL Job
6.
Click the
JDBC Job
tab.
7.
Select the
SQL
job type from the
Type
list.
8.
If you did not select a database in the
Connection
Definition
dialog, you must select one from the
Database
drop-down menu.
If you did select a database in the
Connection Definition
dialog, it appears here on the
JDBC Job
tab as read-only
in the
Database
field.
9.
In the
SQL
tab field, type in one or more SQL statements with multiple statements separated by semicolons to
execute here.
To include parameters that are replaced at runtime, use unique parameter names of your choice preceded by a
colon, such as
colon, such as
:id.
10.
In the
Output format
drop-down menu, select how the query results are formatted.
—
XML
– Writes the query results in XML format.
—
Align Columns
– Displays the values in the most readable format.
—
CSV Format
– Separates values with commas.
—
Raw
– Separates values with a user-defined character.
11.
In the
Delimiter
field, specify the custom character to use for delimiting the column data from the query results if
Raw
or
CSV Format
is selected for
Output Format
.
12.
Select the
Include Headers
option to write out the column headers of the results as well.
13.
Select the
Include Warning
option to include notices and warnings generated during SQL execution in the output.
14.
If you are using parameters to be replaced at runtime, click the
Parameters
subtab.