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

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, 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'
  • DBC-NO for COBOL
  • DBC_XFORMS_OFF_NO for PL/I
  • DBC_XformsOffNo for C and C++
  • DBRITON for Assembler
indicates that Structured UDTs are not transformed. 'Y'
  • DBC-YES for COBOL
  • DBC_XFORMS_OFF_YES for PL/I
  • DBC_XformsOffYes for C and C++
  • DBRITOY for Assembler

The default setting is 'N'.