17.10 - Transforms-off - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

Usage Notes

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

Language Variable Name
COBOL: TRANSFORMSOFF
C: DBCAREA.H: transformsOff
Routine Action Taken
DBCHINI: writes
DBCHCL: reads (RSUP: IRQ)
Used by Action Taken
application program writes
Possible value that can be set in this DBCAREA field is 'Y' and 'N'.
  • 'N' – the value of 'N' indicates that the flag is off and Structured UDTs are transformed into their external type.
  • 'Y' – the value of 'Y' indicates that the flag is on and Structured UDTs are to be returned from the server in the un-translated mode.