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
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
ggf1488824663364.ditamap
dita:ditavalPath
Audience_PDF_include.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.