Saturday, 9 November 2013

8.2 Teradata Parallel Transporter - SQL selector - Additional Attributes



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