Transforms-off - Teradata Tools and Utilities

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Tools and Utilities
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-11-17
dita:mapPath
oxw1641281447623.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
vfj1470443597526
Product Category
Teradata Tools and Utilities

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