Parameters That Apply to Teradata Only

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

Teradata CONNECTION_ATTRIBUTES

The 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 adapter.

The SET CONNECTION_ATTRIBUTES command must be issued before any DBC/SQL commands or FOCUS requests that require Teradata services. Internally, the 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 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: Specifying a TDP ID may not be necessary at your site. Contact your database administrator for your site's requirements.

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, 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.

TRANSACTION

How to:

Set the Transaction Mode of a Teradata Connection

You can control the transaction mode of a Teradata connection by issuing the SET TRANSACTION command.

Top of page

Syntax: How to Set the Transaction Mode of a Teradata Connection

To set the transaction mode of a Teradata connection, issue the following command in any profile or in a procedure

SQL SQLDBC SET TRANSACTION [ANSI|BTET|DEFAULT]

where:

ANSI

Sets the Teradata connection to the ANSI transaction mode. This is the default for a CLI connection.

BTET

Sets the Teradata connection to the Teradata transaction mode (also known as the BTET transaction mode).

DEFAULT

For ODBC connections only. Sets the Teradata connection to the Teradata system default transaction mode. This is the default for an ODBC connection.

For more information about how the Teradata system default is determined, see your Teradata documentation.

Note: The connection scope is different when setting the transaction mode for ODBC and CLI connections.

For an ODBC Connection: The transaction mode can be set within an active connection. There is no need to disconnect.
For a CLI Connection: The transaction mode can be set only before the connection takes place. You must terminate the connection first using the SQL SQLDBC END SESSION command, if you want to change the transaction mode for a CLI connection. Failure to do so will return the following warning:
```
(FOC1722) WARNING: COULD NOT SET TRANSACTION MODE
```