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, 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'- DBC-NO for COBOL
- DBC_XFORMS_OFF_NO for PL/I
- DBC_XformsOffNo for C and C++
- DBRITON for Assembler
|
| indicates that Structured UDTs are not transformed. |
'Y'- DBC-YES for COBOL
- DBC_XFORMS_OFF_YES for PL/I
- DBC_XformsOffYes for C and C++
- DBRITOY for Assembler
|
The default setting is 'N'.