Transforms-off - Call-Level Interface Version 2

Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

Product
Call-Level Interface Version 2
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

Transforms‑off

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

 

In this language...

The variable name for Transforms‑off is...

COBOL

TRANSFORMS‑OFF

PL/I

TRANSFORMS_OFF

C

transformsOff

IBM Assembler

DBRITO

 

This routine...

Does this for Transforms‑off...

DBCHINI

writes

DBCHCL

reads (RSUP; IRQ; IWPF)

 

Transforms‑off is used by...

To...

applications

write

One of the following values may be set before initiating a request:

 

If...

Then set Transforms‑off to...

indicates that Structured UDTs are transformed into their external type.

'N'

  • DBRITON for Assembler
  • DBC_XformsOffNo for C
  • DBC‑NO for COBOL
  • DBC_XFORMS_OFF_NO for PL/I
  • indicates that Structured UDTs are not transformed.

    'Y'

  • DBRITOY for Assembler
  • DBC_XformsOffYes for C
  • DBC‑YES for COBOL
  • DBC_XFORMS_OFF_YES for PL/I
  • The default setting is 'N'.