Parameters That Apply to Teradata Only

This section describes the Teradata SET CONNECTION_ATTRIBUTES command. The SET AUTOCLOSE command is also supported and is described in Controlling Connection Scope.

Teradata CONNECTION_ATTRIBUTES

The data adapter SET CONNECTION_ATTRIBUTES command enables users to identify themselves to the Teradata RDBMS. When users issue the command at the beginning of FOCUS sessions, the RDBMS verifies their authorization to access tables and views.

Note: DBCLOGON is a synonym for CONNECTION_ATTRIBUTES, supported for compatibility with earlier releases of the data adapter.

The SET CONNECTION_ATTRIBUTES command must be issued before any DBC/SQL commands or FOCUS requests that require Teradata services. Internally, the data adapter stores the Teradata logon ID and password in the user's virtual storage space and the DBC authorization process is deferred until a subsequent command for Teradata services is executed. The data adapter initiates the logon immediately prior to executing the user's request for Teradata services.

The SET CONNECTION_ATTRIBUTES command may be issued from the FOCUS command level or be included in the users' PROFILE FOCEXEC. The syntax is

SQL [SQLDBC] SET CONNECTION_ATTRIBUTES [tdpid/]tuserid,tpassword [;]

where:

tdpid

Is the Teradata Director Program ID (TDP ID). Valid values are site-specific and release-dependent:

Note:

tuserid

Is your Teradata user ID, up to 30 characters long.

tpassword

Is the associated Teradata password, up to 30 characters long.

If the SET CONNECTION_ATTRIBUTES command is rejected, a Teradata error message appears and the user should resubmit the command with correct information.

For additional security, a Dialogue Manager procedure may be designed as an alternative to the PROFILE FOCEXEC method. Using -CRTFORM or -PROMPT statements, data adapter users are prompted for the Teradata password and the value is stored in a variable. The -CRTFORM statement also provides a non-display option. For information about Dialogue Manager, see your documentation on developing applications.