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.00
Published
June 2020
Language
English (United States)
Last Update
2021-04-19
dita:mapPath
xen1544831946512.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.