The following table describes the things to consider when using the LOGON command.
Topic | Usage Notes |
---|---|
Command Frequency and Placement | A LOGON command is required for each invocation of the FastExport utility. One LOGON command is allowed for each invocation of the FastExport utility, and it must precede any other FastExport commands except RUN FILE command and LOGTABLE command. |
Logon Parameters | For standard LOGON, the parameters (tdpid, username, password, and acctid) are used in all sessions established with the database. The LOGON command may occur only once. For single sign-on LOGON, if the Gateway to the database is configured to use single sign-on (SSO), and the database client machine has already been logged on, the machine name, user name, and password are not required in the LOGON command. The user name and password combination specified when the database client machine was logged on are authenticated via network security for a SSO such that valid Teradata users will be permitted to log on to the database. The use of SSO is strictly optional, unless the Gateway has been configured to accept only SSO-style logons. To connect to a database other than the one currently logged on, the TDPid must be included in the LOGON command. If the TDPid is not specified, the default contained in clispb.dat will be used. For information about setting defaults, see Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems, B035-2418. To be interpreted correctly, the TDPid must be followed by the slash separator (‘/’), to distinguish the TDPid from a database username. For example, to connect to slugger, enter one of the following: .LOGON slugger/; .LOGON slugger/,,'acctinfo'; If an account ID is to be used, the optional account ID must be specified in the LOGON command. |
Using LOGON With the LOGTABLE Command | Both the LOGON and LOGTABLE commands are required. LOGON and LOGTABLE commands may appear in any order, but must precede other commands except RUN FILE commands used to identify the file containing the LOGON command. If the LOGON command is entered first, FastExport warns that the LOGTABLE command is also required.
|