Additional Required and Optional Attributes:
|
Attribute
|
Optional/Required
|
Description.
|
|
AccountId
= 'acctid'
|
O
|
Optional
attribute that specifies the account associated with the specified user name.
|
|
DataEncryption
=
‘option’
|
O
|
Optional
attribute that enables full security encryption of SQL requests,
responses,
and data.
Valid
values are:
•
‘On’ = All SQL requests, responses, and data are encrypted.
•
‘Off’ = No encryption occurs (default).
|
|
DateForm
= 'datatype'
|
O
|
Optional
attribute that specifies the DATE data type for the SQL Selector operator
job.
The
values are:
• 'IntegerDate' = the integer DATE data type
(default)
• 'AnsiDate' = the ANSI fixed-length CHAR(10)
DATE data type
|
|
IsolationLevel
= ‘value’
|
O
|
Optional
attribute that specifies a lock access value that determines the isolation
level for all queries in a session.
Valid
values :
• RU
= read uncommitted
• SR
= (default) serializable
When
the database successfully changes the isolation level, the following message
is written to the private log:
Session
Isolation Level: RU
|
|
LobDirectoryPath
=
‘pathname’
|
O
|
Optional
attribute that specifies the complete path
name of an existing directory where all LOB data files will be written.
|
|
LobFileBaseName
=
‘filename’
|
O
|
Optional attribute that defines a character string
that will be prefixed to the names of LOB data files.
The
file names created by the SQL Selector operator are in the following
format:
<column-name>_<job-id>_p<#>_r<#>
where:
• #
that follows “p” is the identification of the SQL Selector copy
• #
that follows “r” is the row order returned from Teradata Database.
For
example, if we have the following schema:
DEFINE
SCHEMA <schema-name>
(
COL2
BLOB AS DEFERRED BY NAME,
COL3
<CLOB AS DEFERRED BY NAME>
);
where
LobFileBaseName has the value “my_test”,then the files names will be:
•
my_test_COL2_<job-id>_p1_r1
•
my_test_COL3_<job-id>_p1_r1
|
|
LobFileExtension
=
‘file-extension’
|
O
|
Optional attribute that specifies the extension
for LOB data file names.
Examples
of ‘file-extensions’ include:
•
‘jpg’: indicates that a file ‘ccc.jpg’ is a picture file.
•
‘gif’: indicates that the file ‘ddd.gif’ is a picture file.
•
‘html’: indicates that the file ‘aaa.html’ is an html file.
|
|
PrivateLogName
=
'logname'
|
O
|
Optional
attribute that specifies the name of a log that is maintained by the Teradata
PT Logger inside the public log.
The
private log can be viewed using the tlogview command as follows, where jobid
is the Teradata PT job name and privatelogname is the value for the operator
PrivateLogName attribute:
tlogview
-j jobid -f privatelogname
If
the private log is not specified, all of the output is stored in the public
log.
|
|
ReportModeOn
=
'mode'
|
O
|
Optional attribute that specifies whether or not
to use the field report mode.
This feature allows you to extract data from the
Teradata Database in character form, and then change it into the “delimited”
(VARTEXT) format using the DataConnector operator and save it to a text file.
When
the data is exported in character format (field report mode), columns defined
in the schema must be CHAR or VARCHAR.
The
values are:
•
'Yes' ('Y') = Report mode, returns data in character format
•
'No' ('N') = Indicator mode (default)
|
|
LogonMech
= ‘string’
|
O
|
Same
as in EXPORT operator.
|
|
LogonMechData
=
‘data’
|
O
|
Same
as in EXPORT operator.
|
|
LogSQL
= 'option'
|
O
|
Same
as in EXPORT operator.
|
|
QueryBandSessInfo
= 'Query Band
expression'
|
O
|
Same
as in EXPORT operator.
|
|
TraceLevel
= 'level'
|
O
|
Same
as in EXPORT operator.
|
|
WorkingDatabase =
‘dbname’
|
O
|
Same
as in EXPORT operator.
|
No comments:
Post a Comment