DB Aliases

The following syntax is used to generate a statement for each exported DB Alias:

CREATE DBALIAS dbaliasname 
   [DESC //description//] 
   DIRDB {Y|N} TYPE type type VER version 
   [IDCASE {U|L|M}] CODEPAGE code page} 
   [DELIM delimitercharacter] [DECSEP decimalseparator] 
   CONNECT servername DBQUAL dbqualifier 
   [SPQUAL spqualifier] [NETSERVER netservername] 
   [TABLESPACE tablespacename]
   USEDFLTTBLSP {Y|N}
   DATABASE database
   USEDFLTDB {Y|N} [TABLEALLOC percentage]
   IDXTYPE idxtype [IDXCID creatorid]
   IDXTBLSPCTYPE idxtblspctype [IDXTBLSPC tablespacename]
   [INDEXALLOC percentage]

Keywords

The keywords correspond to values that can be specified for a DB Alias. For more information about an individual parameter, see Using the Editor.

DBALIAS dbaliasname
The name of the DB Alias, specified as a single string (dbaliasname), is required following the CREATE DBALIAS keyword.
DESC //description//
Description of the DB Alias, delimited by double slashes.

Long character strings such as description text entries are delimited by two forward slashes (//). Continuation characters are not used, and no spaces or indentations are added. If additional spaces or continuation characters are inserted, the string is imported incorrectly. The text continues for the complete length of the line width, wrapping to the next line until the forward slashes are reached, indicating the end of the text.

General

DIRDB {Y|N}
(Optim™ Directory Database) Indicates whether the DB Alias is the one used for the Optim Directory connection. This information is necessary to avoid conflicts during certain types of processing.
Y
The DB Alias is the one used for the Optim Directory connection.
N
The DB Alias is not the one used for the Optim Directory connection.
TYPE type
The database type:
Type Database
2 DB2MVS
C DB2CS
O Oracle
S Sybase ASE
I Informix®
G SQL Server
M ODBC
VER version
The version number of the DBMS (DBMS Version).
IDCASE {U|L|M}
Indicates the identifier case. This keyword is only valid for DBMS types that allow user control of object identifier case—i.e., Sybase ASE.
IDCASE value Case
U upper
L lower
M mixed
CODEPAGE code page
Indicates the code page selected for the DBMS interface to use for character data when communicating with the client. It does not indicate the code page of the data on the DBMS server. Not used for DB2® and Sybase ASE.
DELIM delimitercharacter
Indicates the delimiter needed to enclose strings with special characters or blanks.
DECSEP decimalseparator
Indicates the character needed to represent a decimal point in numeric strings.

Connection

CONNECT servername
Indicates the connection string required to access the DBMS Server.
DBQUAL dbqualifier
Indicates the string to use as a name qualifier that identifies the database that the DB Alias represents (Sybase ASE only).

Server

SPQUAL spqualifier
Indicates the name qualifier for the location of the Stored Procedure that Optim must execute to access the database.
NETSERVER netservername
Indicates the name of the Network Server where the database (identified in the Connection String) resides (Sybase ASE only).

Table Defaults

TABLESPACE tablespacename
The name of the default tablespace for objects created using the Create Utility.
USEDFLTTBLSP {Y|N}
Indicates whether default tablespace is used.
DATABASE database
The name of the default database if importing from MVS™ DB2.
USEDFLTDB {Y|N}
Indicates whether the default database is used.
TABLEALLOC percentage
Percentage of the source value storage (0-999) to be used for the target.

Index Defaults

IDXTYPE idxtype
Indicates what value to use for the qualifier, Index ID, when new indexes are created using the Create Utility. Specified as one of the following:

TABLE
SOURCE
CURRENT
EXPLICIT

IDXCID creatorid
Explicit value of the Owner ID. This is valid only if IDXTYPE is EXPLICIT.
IDXTBLSPCTYPE idxtblspctype
Indicates the value to use for the qualifier, Tablespace, when new indexes are created using the Create Utility. Specified as one of the following:

TABLE
SOURCE
EXPLICIT

IDXTBLSPC tablespacename
Explicit value of the Tablespace. This is valid only if IDXTBLSPCTYPE is EXPLICIT.
INDEXALLOC percentage
Percentage of the source value storage (0-999) to be used for the target.