SET USERID - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
bvb1608578422774.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2416
Product Category
Teradata Tools and Utilities

Purpose

Changes the database system user ID that TDP uses to establish its internal sessions. The default value for the TDP user ID character set is EBCDIC.

Syntax



The SE abbreviation is deprecated.

where:

name
Name of a database userid consisting of characters from the TDP character set, specified by the SET CHARSET command.
When supported by the character set, you can include EBCDIC double-byte characters if you:
  • Precede each contiguous group of characters with the Shift-out control character, X’0E’, and
  • Follow the group with the Shift-in control character, X’0F’
The database processes the userid characters left to right, even for character sets normally associated with right to left languages such as Hebrew or Arabic.

Usage Notes

Unless this command is specified, TDPUSER is assumed. The specified name is used when TDP internal sessions are next established (either when the CPs are initially started or as the result of an ENABLE IRF command).

The current character set for the TDP userid can be displayed using the DISPLAY TDP command.

The existence of the TDP character set in the database is not validated during the execution of this command. Such errors are reported when the information is subsequently used in attempting to establish TDP internal sessions. The specified userid must already exist in the database and have the following privileges:
  • SELECT on the DBC.InDoubtLog view
  • DELETE on the DBC.InDoubtLog view
  • EXECUTE on the DBC.TwoPCRule macro
  • With NULL Password

Example 1: SET USERID

SET USERID ANOTHERUSERID

Example 2: SET USERID

SET USERID TDPUSER

Completion Message

TDP0393 TDP USERID HAS BEEN SET TO name

Error Messages

Possible error messages are:

TDP0504 UNKNOWN TDP COMMAND NAME: text
TDP0506 UNKNOWN OPERAND TO THE ‘SET’ COMMAND: text
TDP0535 TOO FEW OPERANDS FOR THE ‘SET USERID’ COMMAND
TDP0536 TOO MANY OPERANDS FOR THE ‘SET USERID’ COMMAND
TDP0502 LENGTH INCORRECT FOR ‘SET USERID’ VALUE