15.10 - Transforms-off - 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

Transforms‑off is a one byte EBCDIC field that indicates whether SQL Structured User Defined Types (UDTs) are transformed into their external data type or left as their constituent attributes.

 

In this language...

The variable name for Transforms‑off is...

COBOL

TRANSFORMS‑OFF

PL/I

TRANSFORMS_OFF

C

transformsOff

IBM Assembler

DBRITO

 

This routine...

Does this for Transforms‑off...

DBCHINI

writes

DBCHCL

reads (RSUP; IRQ; IWPF)

 

Transforms‑off is used by...

To...

applications

write

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

 

If...

Then set Transforms‑off to...

indicates that Structured UDTs are transformed into their external type.

'N'

  • DBRITON for Assembler
  • DBC_XformsOffNo for C
  • DBC‑NO for COBOL
  • DBC_XFORMS_OFF_NO for PL/I
  • indicates that Structured UDTs are not transformed.

    'Y'

  • DBRITOY for Assembler
  • DBC_XformsOffYes for C
  • DBC‑YES for COBOL
  • DBC_XFORMS_OFF_YES for PL/I
  • The default setting is 'N'.