For Field Mode only, to ensure printability of columnar reports, BTEQ translates certain control characters found in database response data to spaces, based on the OS platform and the encoding of the output. The following table reflects which characters will get translated.
Field Mode output can be written to either stdout or an export report file.
| Platforms | Control Characters Translated to Spaces |
|---|---|
| Workstation | For non-UTF16 encodings, the following control characters are translated to spaces (0x20):
For a UTF16 encoding, the following control characters are translated to spaces (U+0020):
Exception: The horizontal tab character (0x09 and U+0009) is translated to a space only for data rows, and not for title rows, regardless of the output encoding. |
| z/OS | For non-Unicode encodings, the following control characters are translated to spaces (0x40). This is always the case for SYSPRINT:
For a UTF8 export report, the following control characters are translated to spaces (0x20):
For a UTF16 export report, the following control characters are translated to spaces (U+0020):
|
- For encodings that support multi-byte characters, individual bytes within those characters are not subject to space translations. For example, in UTF16, the U+CF00 character is not converted to U+CF20 because the 0x00 byte is part of a valid multi-byte character.
- Use TRANSLATECTRLSTOSPACES OFF to inhibit the translation of control characters to spaces for Field Mode columnar report's data rows (non-title) bound for stdout or an EXPORT REPORT file. For more information, see TRANSLATECTRLSTOSPACES (TCTS).
- Use TRANSLATECTRLSTOSPACES OFF ALL to turn off the translation for Field Mode report's data rows as well as title rows bound for stdout or an EXPORT REPORT file. For more information, see TRANSLATECTRLSTOSPACES (TCTS).