DB_URL Statement—Specify Database Resource Location

The DB_URL statement specifies the database resource location for a database job.

Supported Job Types

This statement is optional for the following job types:

Syntax

This statement has the following format:

DB_URL url

url

Specifies a JDBC database resource location for a job. Use the appropriate format for your database type:

For an Oracle database:

DB_URL jdbc:oracle:thin:@host:port:dbname

For a Microsoft SQL Server database:

DB_URL jbdc:sqlserver://host:port;DatabaseName=dbname

Limits: Up to 256 characters; case-sensitive

Notes:

Enclose values that contain delimiters (such as spaces) in double quotation marks.
If you do not specify this statement, a default database resource location must be defined in the db.default.url parameter in the agent's agentparm.txt file.
The DB_URL statement overrides the default resource location specified in the agent's agentparm.txt.
HOST is an alias of DB_URL.

Example: Specify an Oracle Database

This example uses the Oracle database named ORDERS that is reachable on port 1433 on host 172.31.255.255.

AGENT CYBDB1
SQL 'SELECT * from NEWORDS'
DB_URL jdbc:oracle:thin:@172.31.255.255:1433:ORDERS

Example: Specify a Microsoft SQL Server Database

This example uses the MS SQL Server database named ORDERS that is reachable on port 1433 on a host named myhost.

AGENT CYBDB1
SQL 'SELECT * from NEWORDS'
DB_URL 'jdbc:sqlserver://myhost:1433;DatabaseName=ORDERS'

Example: Specify an IBM DB2 Database

This example updates a record in the STAFF table under the user entadm. The job changes the years to 3 for the employee with the name Jonson.

AGENT DB_AGENT
USER entadm
DB_URL jdbc:db2://172.31.255.255:50000/SAMPLE
SQL 'UPDATE ENTADM.STAFF SET YEARS=3 where NAME=''Jonson'''