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
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

Transforms-off

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.