Database Stored Procedure
You should test your database connection and SQL statements using the Database Test utility, before you make or schedule stored procedure tasks.
Stored Procedure Name
Enter the name of the
stored procedure. This field also supports dynamic
variables.
Stored Procedure parameters
Enter
the parameters for the stored procedure separated by , . The
parameters should be entered in the same order that they are declared
in the database stored procedure. Leave this field blank if your
stored procedure does not require parameters. This field also
supports dynamic variables.
Example:
Consider
the stored procedure:
addNameAge (IN name varchar(25), IN age
varchar(3))
To: pass the values for Jim aged 75, you would enter
for the parameters field:
Jim,75
Directory to place Results
Enter the full
pathname of the directory where you need to put the SQL query
results. Note that the pathname is case sensitive on Unix
systems.
Results Filename
Enter the filename for query
results. If no filename is entered, a default filename of your
Task Title is used. This field also supports dynamic
variables. Using dynamic variables, you can save the file
to a customized name based on date/time or username etc...
Append to Filename
To
save each query to a different filename, based on current time/date,
choose an append file option.
Database JDBC driver
For your database, you need
to obtain the JDBC driver from your database vendor or other 3rd
party vendor. Many of the database vendors have free JDBC
drivers available at their web site. The JDBC driver is
generally in the form of a .zip or .jar file. You
need to place the JDBC driver in the following folder, depending on
your installation method. Then restart the engine and the user
interface.
For installs including JVM :
...[Install_Folder]/jre/lib/ext
For installs without JVM
: ...jre/1.4/lib/ext or
JDK1.4/jre/lib/ext.
Driver class name
Enter the class name for the
driver. This information will be available in the driver
documentation. For Microsoft Access database, simply enter
"access". Also, the JDBC driver required for MSAccess
is included within Java itself.
Database Url
Enter the Url connection
information. This information will be available with the Java
JDBC driver documentation.
The Url format will vary with vendor.
The format includes the server name, port, database name, username,
and password.
Authorization
If your database requires
authentication, then select this option and enter your username and
password.
Username
Enter your username if required for
database access. It is case sensitive.
Password
Enter your password if required for
database access. It is case sensitive.