Parcel Data - Director Program

Teradata Director Program Reference

Product
Director Program
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2416
lifecycle
previous
Product Category
Teradata Tools and Utilities

Table 20 provides field information for the Logon parcel.

 

Table 20: Logon Parcel Field Information

Flavor Field

Body Parcel Length

Parcel Body Fields

36

1 to 6916

LogonString: 1 to 6916

Field Notes

LogonString is a character string containing the following elements:

userid, password[, ‘account’]

where

The userid is the user’s identification. It must consist of at least one character and can consist of as many as 6916characters. Each character might require 1, 2, or 3 bytes, depending on the character set used. The userid can be enclosed in apostrophes, each of which requires 1 byte (2 bytes if Unicode®).

Note that SQL terminal symbols (such as apostrophes) must always come from the shortest repertoire; that is 1 byte. Terminal symbols are never 3 bytes.

The userid and password must be separated by a comma.

The password is the user’s password. It must consist of at least one character, and can consist of as many as 6916 characters. Each character might require 1, 2, or 3 bytes, depending on the character set used. The password can be enclosed in quotation marks, each of which requires 1 byte (2 bytes if Unicode®).

Note that SQL terminal symbols (such as quotation marks) must always come from the shortest repertoire; that is 1 byte. Terminal symbols are never 3 bytes.

If the account is not omitted, the password and account must be separated by a comma.

The userid, password, and account name each consists of characters from the session character set.

When supported by the session character set, double-byte characters can be included by preceding each contiguous group of them with the Shift-out control character, X’0E’, and following this group with the Shift-in control character, X’0F’.

Neither commas nor blanks can be specified as double-byte characters.

Note: The password is usually required, but it might be optional in the logon string submitted by the application if the site has an exit routine that validates the userid.

The account (optional) is the account under which the user is logging on. The account can consist of as many as 6916 characters, and it must be enclosed in apostrophes. Any apostrophe in the account name must be represented by two apostrophes. The second apostrophe is not counted toward the limit of 6916 characters. Each character might consist of 1, 2, or 3 bytes, depending on the character set used. If the account string consists of 6916 apostrophes, and is encoded in Unicode® (2-byte terminal symbols), 124 bytes are necessary to specify the field.

The userid and password must satisfy the lexical characteristics of Teradata SQL words.

See the description of lexical characteristics in SQL Fundamentals (B035-1141) or Database Design (B035-1094).