Release Notes - Teradata Tools and Utilities

Teradata Tools and Utilities Release Definition

Product
Teradata Tools and Utilities
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-02
dita:mapPath
xjo1488824663486.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2029
lifecycle
previous
Product Category
Teradata Tools and Utilities
BTEQ Release Notes
Issue/Enhancement Description
BTEQ-10619 BTEQ now has a TRANSLATECTRLSTOSPACES command, which when set to OFF, inhibits the translation of control characters to spaces from Field Mode columnar report's data rows (non-title) bound for stdout or an EXPORT REPORT file.
By default, TRANSLATECTRLSTOSPACES is ON, which means BTEQ will translate certain control range characters to spaces in following output areas of a Field Mode response:
  • BTEQ titles (headers/footers)
  • DBS titles (column titles appearing on top as well as sides)
  • Data rows (Field Mode column data)
Setting TRANSLATECTRLSTOSPACES to OFF will inhibit the translation of any control range characters to spaces in following output areas of a Field Mode response:
  • Data rows (Field Mode column data)
However, TRANSLATECTRLSTOSPACES OFF will still lead to the translation for following output areas of a Field Mode response:
  • BTEQ titles (headers/footers)
  • DBS titles (column titles appearing on top as well as sides)

An exception to the above is the TAB character, where TABs are never translated to spaces in the BTEQ titles and DBS titles.

BTEQ-11780 BTEQ supports the transfer of non-deferred LDOs (Large Data Objects) up to the database maximum (7MB). The 7MB limit pertains to a single LDO and to the cumulative LDO bytes in a given record.