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

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

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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

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'

  • DBRITRQN for Assembler
  • DBC_TrustRqstNo for C
  • DBC‑NO for COBOL
  • DBC_TRUST_RQST_NO for PL/I
  • indicates the request may use the Teradata SQL SET QUERY_BAND='PROXYUSER=...' statement to change the session userid.

    'Y'

  • DBRITRQY for Assembler
  • DBC_TrustRqstYes for C
  • DBC‑YES for COBOL
  • DBC_TRUST_RQST_YES for PL/I
  • The default setting is 'N'.