16.20 - Trusted-request - Teradata Tools and Utilities

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

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

Trusted-request is a one byte EBCDIC 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.

In this language... The variable name for Trusted-request is...
COBOL TRUSTED-REQUEST
PL/I TRUSTED_REQUEST
C, C++ trustedRequest
IBM Assembler DBRITRQ
This routine... Does this for Trusted-request...
DBCHINI writes
DBCHCL reads (RSUP; IRQ; IWPF)
Trusted-requests is used by... To...
applications write

One of the following values may be set before initiating a request:

If... Then set Trusted-request to...
indicates the request may not use the Teradata SQL SET QUERY_BAND='PROXYUSER=...' statement to change the session userid. 'N'
  • DBC-NO for COBOL
  • DBC_TRUST_RQST_NO for PL/I
  • DBC_TrustRqstNo for C and C++
  • DBRITRQN for Assembler
indicates the request may use the Teradata SQL SET QUERY_BAND='PROXYUSER=...' statement to change the session userid. 'Y'
  • DBC-YES for COBOL
  • DBC_TRUST_RQST_YES for PL/I
  • DBC_TrustRqstYes for C and C++
  • DBRITRQY for Assembler

The default setting is 'N'.