Option
|
Description
|
---|---|
CATALOG
|
CATALOG=catalog-identifier; Specifies an arbitrary identifier for an SQL catalog, which groups logically related
schemas. Any identifier is valid (for example,
catalog=tera).
Note: You must specify a catalog.
|
DATABASE
|
DATABASE=database-name; Specifies the Teradata
database. If you do not specify DATABASE=, you connect to the default
Teradata database, which is often named the same as your user ID.
If the database value that you specify contains spaces or non-alphanumeric
characters, you must enclose it in quotation marks.
|
DRIVER
|
DRIVER=TERADATA; Identifies the data
service to which you want to connect, which is a Teradata database.
Note: You must specify the driver.
|
SERVER
|
SERVER=server-name; Specifies the Teradata
server identifier.
|
Option
|
Description
|
||||||
---|---|---|---|---|---|---|---|
ACCOUNT
|
ACCOUNT=account-ID; Specifies an optional
account number that you want to charge for the Teradata session.
|
||||||
CLIENT ENCODING
|
CLIENT_ENCODING=encoding-value Used to specify the
character set for the session. UTF8 is the default if encoding is
not specified. The character sets supported are:
ASCII EBCDIC EBCDIC273_0E EBCDIC277_0E EBCDIC037_0E KATAKANAEBCDIC KANJIEUC_0U LATIN9_0A THAI874_4A0 LATIN1250_1A0 CYRILLIC1251_2A0 LATIN1254_7A0 HEBREW1255_5A0 ARABIC1256_6A0 LATIN1258_8A0 TCHBIG5_1R0 SCHINESE936_6R0 KANJI932_1S0 HANGUL949_7R0 TCHINESE950_8R0 LATIN1252_3A0 SCHEBCDIC935_2IJ TCHEBCDIC937_3IB HANGULEBCDIC933_1II KANJIEBCDIC5035_0I KANJIEBCDIC5026_0I UTF8 UTF16 |
||||||
CT_PRESERVE
|
CT_PRESERVE = STRICT | SAFE | FORCE | FORCE_COL_SIZE Allows users to control how data types are mapped. Note that data type mapping is disabled when CT_PRESERVE is set to STRICT. If the requested type does not exist on the target database, an error is returned. The options are as follows:
|
||||||
DEFAULT_ATTR
|
DEFAULT_ATTR=(attr=value;...) Used to specify connection handle
or statement handle attributes supported for initial connect-time
configuration, where
attr=value corresponds
to any of the following options:
|
||||||
DRIVER TRACE
|
DRIVER_TRACE='API | SQL | ALL'; Requests tracing information, which logs transaction records to an external file that
can be used for debugging purposes. The SAS Federation Server driver writes a record
of each command that is sent to the database to the trace log based
on the specified tracing level, which determines the type of tracing information.
The tracing levels are as follows:
Default: Tracing
is not activated.
Note: If
you activate tracing, you must also specify the location of the trace
log with DRIVER_TRACEFILE=. Note that DRIVER_TRACEFILE= is resolved
against the TRACEFILEPATH set in ALTER SERVER. TRACEFILEPATH is relative
to the server's content root location.
(Optional) You can control trace
log formatting with DRIVER_TRACEOPTIONS=.
Interaction: You
can specify one trace level, or you can concatenate more than one
by including the | (OR) symbol. For example,
driver_trace='api|sql' generates tracing information for API calls and SQL statements.
|
||||||
DRIVER TRACE FILE
|
DRIVER_TRACEFILE=‘filename'; Used to specify the name of the
text file for the trace log. Include the filename and extension in
single or double quotation marks. For example:
driver_tracefile='\mytrace.log' Default: The
default TRACEFILE location applies to a relative filename, and it
is placed relative to TRACEFILEPATH.
Requirement: DRIVER_TRACEFILE
is required when activating tracing using DRIVER_TRACE.
Interaction: (Optional)
You can control trace log formatting with DRIVER_TRACEOPTIONS=.
|
||||||
DRIVER TRACE OPTIONS
|
DRIVER_TRACEOPTIONS=APPEND | THREADSTAMP | TIMESTAMP; Specifies options
in order to control formatting and other properties for the trace
log:
Default: The trace log is overwritten with no thread identification or time stamp.
|
||||||
MAXPARMSIZE
|
MAXPARMSIZE=size-in-bytes Specifies the maximum byte limit for parameter bindings for variable length data types
(VARCHAR, CHAR, VARBINARY, BINARY). Use this connection option if the number of required
parameters exceeds the driver’s limit of 64,256 bytes. The default value is 8K (8192
bytes). Alias: MPS
|
||||||
PASSWORD
|
PASSWORD=password; Specifies a Teradata
password. The password must correlate to your USER= value. The alias
is PWD=.
Note: You must specify the PASSWORD=
option.
|
||||||
ROLE
|
ROLE=security-role; Specifies a security
role for the session.
|
||||||
USER
|
USER=user-id; Specifies a Teradata
user ID. If the ID contains blanks or national characters, enclose
it in quotation marks. The alias is UID=.
Note: You must specify the USER=
option.
|