Required and Optional Attributes|SQL Selector Operator - Required and Optional Attributes - Parallel Transporter

If omitted, it defaults to the account identifier of the immediate owner database.

Valid values are:

• 'Y’ or ‘Yes' = The Selector operator adds the appropriate UTF BOM at the beginning of an XML, JSON or CLOB output data file.
• 'N’ or ‘No' = The Selector operator does not prefix the appropriate UTF Byte-Order-Mark (BOM) at the beginning of an XML (JSON or CLOB) output data file (default).

AddBOMToFile can only be used when following two conditions are met:

1. The job schema has one or more XML, JSON, or CLOB column(s) defined AS DEFERRED BY NAME.
2. The client character set for the load job is the Unicode character set.

If these two conditions are not met, the values specified in the attribute are ignored.

For information on connection string, see Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems, B035-2418.

• 'integerDate' = the integer DATE data type (default)
• 'ansiDate' = the ANSI fixed-length CHAR(10) DATE data type

When the database successfully changes the isolation level, the following message is written to the private log:

Session Isolation Level: RU

The file names created by the SQL Selector operator are in the following format:

<column-name>_c<#>_<job-id>_p<#>_r<#>

For example, if we have the following schema:

DEFINE SCHEMA <schema-name>
  (
    COL2 BLOB AS DEFERRED BY NAME,
    COL3 CLOB AS DEFERRED BY NAME,
    COL4 XML AS DEFERRED BY NAME,
    COL5 JSON(1000000) AS DEFERRED BY NAME,
  );

where LobFileBaseName has the value “my_test”,

The default value is 38.

If the attribute has a value of q where 38≥q≥1, then any returned DECIMAL (n[,m]) data item with n>q is implicitly CAST to DECIMAL; overflows are handled the same as an explicit CAST.

On mainframe-attached platforms, it is recommended that the MaxDecimalDigits attribute not exceed 31 to avoid representations that exceed the capacity of the native instruction set.

INTEGER OutLimit = 1000

If specified, the OutLimit value must be greater than 0.

If OutLimit is not specified, the number of records processed is not limited.

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 the output is stored in the public log.

For more information about the tlogview command, see Teradata PT Utility Commands.

The queryBandExpression is a set of name=value pairs, separated by a semicolon and ending with a semicolon. The user defines the Query Band expression, which will look similar to the following example:

‘org=Finance;load=daily;location=west;’

QueryBandSessInfo may also be specified as an ARRAY attribute.

For information on the rules for creating a Query Band expression, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144 and Teradata Vantage™ - SQL Data Definition Language Detailed Topics, B035-1184.

The value of the QueryBandSessInfo attribute is displayed in the SQL Selector operator private log.

This feature allows you to extract data from the 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 VARCHAR.

Optional attribute that implements security in a database environment. The operator will prepend the value with "SET ROLE ". The syntax will be sent to the database as follows:

SET ROLE <role name>;

For example:

SET ROLE All;

For details of "SET ROLE" command use, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

The VARCHAR ARRAY can specify more than one value, for example:

VARCHAR ARRAY RoleName = ['role name1', 'role name2'],

The operator will send the request to the database on the SQL session after the session is connected.

The SQL Selector operator can submit a single SELECT statement or multiple SELECT statements. All specified SELECT statements are treated as a single request to be sent to the database. The entire request cannot be larger than 1 MB (Vantage limitation).

The dbcName can be up to 256 characters and can be a domain server name.

If you do not specify value for the TdpId attribute, the operator uses the default TdpID established for the user by the system administrator.

When you provide a value for this attribute, the operator will build the SET TIME ZONE <timeZoneValue>; SQL request.

The operator will send the request to the database on the SQL session after the session is connected.

For more information on SET TIME ZONE SQL, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

The VARCHAR ARRAY can specify more than one value, for example:

VARCHAR TraceLevel = 'CLI'
VARCHAR TraceLevel = 'OPER'
VARCHAR ARRAY TraceLevel = [ 'CLI' ]
VARCHAR ARRAY TraceLevel = [ 'CLI', 'OPER' ]

SET TRANSFORM GROUP FOR TYPE <udt name> <transform group name>;

"SET TRANSFORM GROUP FOR TYPE JSON CHARACTER SET LATIN TD_JSON_VARCHAR;"

VARCHAR ARRAY TransformGroup = ['JSON CHARACTER SET LATIN TD_JSON_VARCHAR',
                                'ST_GEOMETRY TD_GEO_VARCHAR'],

The operator will send the request to the database on the SQL session after the session is connected.