17.10 - Trusted-request - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

Usage Notes

Trusted-request is a one byte ASCII field that indicates whether the request is trusted to use the Teradata SQL SET QUERY_BAND='PROXYUSER=...' statement to change the session userid. So unless the application accepts SQL requests from an outside source, this option has no use.

Language Variable Name
COBOL: TRUSTEDREQUEST
C: DBCAREA.H: trustedRequest
Routine Action Taken
DBCHINI: writes
DBCHCL: reads (RSUP: IRQ)
Used by Action Taken
application program writes
Possible value that can be set in this DBCAREA field is 'Y' and 'N'.
  • 'N' – the value of 'N' indicates that this is not a trusted request. If the trusted user possesses the trust-only attribute, this setting will prevent "SET QUERY_BAND PROXYUSER..." from being affected.
  • 'Y' – the value of 'Y' indicates that this is a trusted request. If the trusted user possesses the trust-only attribute, this setting will allow "SET QUERY_BAND PROXYUSER..." to be affected.