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.