Standard LOGON Syntax
Single Sign-on LOGON Syntax
where the following is true:
- username
- If the database does not support EON feature, a user identifier can have up to 30 bytes.
- If the database supports EON feature, a user identifier can have up to 128 characters.
- password
- Password associated with the username.
- If the database does not support EON feature, a password can have up to 30 bytes.
- If the database supports EON feature, a password can have up to 128 characters.
- Passwords that contain special characters must be enclosed in double quotes.
- tdpid
- Optional character string that identifies the name of a TDP.
- The tdpid string can have from 1 to 8 characters.
- Workstation-attached systems: The tdpid string can have up to 256 characters and can be a domain name system (DNS) name.
- The tdpid is the name of the host entered in the network hosts file. If this field is not supplied, tdpid defaults to the TDP established for the user by the system administrator.
- Mainframe-attached systems: The tdpid string must be in the form:
- TDPn
- where n is the TDP identifier.
- acctid
- Account associated with the username
- If the database does not support EON feature, an account identifier can have up to 30 bytes.
- If the database supports EON feature, an account identifier can have up to 128 characters.
- If omitted, Teradata FastLoad uses the default account identifier defined when the user was created.