The following syntax is used to generate a statement for
each exported DB Alias:
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.