Logon Pointer - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

Logon Pointer

Usage Notes

The Logon Pointer field specifies the address of the logon string for the session.

 

Language

Variable Name

COBOL:

DBCAREA-LOGON-PTR

C: DBCAREA.H:

logon_ptr

 

Routine

Action Taken

DBCHINI:

writes

DBCHCL:

reads (CON)

 

Used by

Action Taken

application program

writes

Before calling DBCHCL for the Connect function, the application program must build a logon string and provide its address in Logon Pointer. A logon string has the following format:

[tdpid[.domain][:port]/][userid,password][,'acctid']

where

 

The variable...

Is...

tdpid

one of the dbcnames in the network‑attached client’s host file on the network. Both ip address and ip port format in tdpid are supported. Examples are listed as follows:

"ipaddress/username,passwd..."

"ipaddress:port/username,passwd..."

"dbcname:port/username,passwd..."

Simple machine names that are used as TDPids should be unique across multiple domains (that is, the high-level qualifier in the fully-qualified domain name should be unique).

For example, bteqdev.sandiegoca.teradata.com and bteqdev.northpole.hellokitty.com should not be used in the same job.

When a simple machine name is supplied and there is no corresponding entry in the local hosts file, gethostbyname() appends the default domain name as found in /etc/resolv.conf (for UNIX) or in Advanced TCP/IP Settings (for Windows). This is done to obtain a valid IP address from DNS.

If tdpid is omitted, CLI uses the default for dbcname in the SPB
(see
Chapter 4: “System Parameter Block (SPB) Processing”).

userid

the user’s id on the corresponding database computer. Maximum length of userid is 30 bytes (alpha characters are not case specific; dollar sign ($), pound sign (#), and underscore (_) are allowed anywhere in userid; numbers are allowed but the first character may not be numeric).

The Logon Pointer field supports Teradata Wallet keywords. See “Teradata Wallet Support” on page 117.

password

the password on the corresponding database computer. Maximum length of password is 30 bytes (alpha characters are not case specific; dollar sign ($), pound sign (#) and underscore (_) are allowed anywhere in userid; numbers are allowed but the first character may not be numeric).

The Logon Pointer field supports Teradata Wallet keywords. See “Teradata Wallet Support” on page 117.

acctid

the account to be charged on workstation-attached clients. Maximum length of acctid is 30 bytes.

Note: Do not end the logon string with a semicolon.

Logon Pointer always points to the beginning of the logon string.

Teradata Wallet Support

This application supports the secure storage of passwords and other logon string information using Teradata Wallet. For detailed information on using Teradata Wallet, see the most recent version of Security Administration (B035‑1100).

For detailed information on Teradata Wallet installation and setup options, see the Teradata Tools and Utilities Installation Guide for the appropriate operating system.

Kanji Support

Kanji characters used in userid, password and acctid are limited to a maximum of 30 bytes. Because Kanji characters may be double or triple bytes, the maximum length when counted in Kanji characters should be less than 30. For example, if the userid contains only double byte Kanji characters, the maximum length for userid should be 15 Kanji characters.

Kanji characters are only allowed in userid, password and acctid. Blanks, commas and slashes must be single byte characters.