Trusted-request - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-12
dita:mapPath
dsu1527114222346.ditamap
dita:ditavalPath
dsu1527114222346.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

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