Transforms-off - Call-Level Interface Version 2

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
ft:locale
en-US
ft:lastEdition
2024-11-15
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
lifecycle
latest
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.