DBAppender Connection Options for DB2

The following is an example of the basic syntax for specifying options in the ConnectionString parameter of a DBAppender configuration for a DB2 database. If you need additional details, contact SAS Technical Support.

Valid in:	ConnectionString parameter of DBAppender configuration
See:	DBAppender

Table of Contents

Syntax

CATALOG=catalog-identifier;
DATABASE=database-specification;
DRIVER=DB2;
PWD=password;
UID=user-id;
CONOPTS=(valid-DB2-compliant-database-connection-string);

Syntax Description

The data source connection options for a DB2 database include the following:

CATALOG=catalog-identifier

specifies an arbitrary identifier for an SQL catalog, which groups logically related schemas. Any identifier is valid (for example, catalog=db2).

Requirement

You must specify a catalog. For the DB2 database, this is a logical catalog name to use as an SQL catalog identifier.

DATABASE=database-specification

Specifies the name of the DB2 database.

Alias

DB=

DRIVER=DB2;

identifies the data source to which you want to connect, which is a DB2 database.

Requirement

You must specify the driver.

PWD=password;: specifies the DB2 password.

UID=user-id;: specifies the DB2 login user ID.

CONOPTS=(valid-DB2-compliant-database-connection-string);

specifies, within parentheses, a DB2 connection string. This parameter enables you to specify connection options that cannot be specified with the other ConnectionString parameters.

For example, you can use this parameter as follows to specify a DSN called logdata:

CONOPTS=(DSN=logdata);

Example: Connection String for DB2

DRIVER=DB2;DB=SAMPLE;UID=User1;PWD=Password1;CATALOG=db2;