Revision History - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
16.00
Published
November 2016
Language
English (United States)
Last Update
2018-04-25
dita:mapPath
hyz1479325149183.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following changes were made to this book in support of the current release. For a complete list of changes to the product, see the Teradata Tools and Utilities Release Definition (B035-2029) associated with this release.

Date Release Description
November 2016 16.00
  • In chapter 5, for the ERRORLEVEL command, updated the description of the “n” syntax element and Usage Notes.
  • In Chapter 5, for the IF...THEN... command, updated the “n” syntax element description’s ERRORLEVEL content.
  • In Chapter 5, removed the QUIT command description, consolidating that information under the new heading “EXIT and QUIT”.
  • In Chapter 4 replaced section “Printing Output on z/OS” with new section “Field Mode Translation of Control Characters”.
  • Updated Chapter 5 and Appendix C to reflect BTEQ support for non-BMP Unicode characters, and the database’s Unicode Pass Through feature.
  • In Chapter 5, updated the WIDTH command description to clarify its use as a display limit of bytes, characters, or printwidth spaces.
  • In Chapter 5, updated NOTIFY command section.
  • In Chapter 5, updated the EXITONDELAY command description to reflect that it can now be used jointly with CLI's Automatic Redrive feature, thus allowing a query to possibly complete if the DBS happens to go down but comes back up before the EXITONDELAY timeout period expires.
  • Updated content throughout to correct and improve.
  • In Chapter 1, an example of batch mode result blocks has been added. In Chapter 3, the description of return code 2 has been clarified.
  • Updated content to reflect BTEQ support for using 1MB size responses for Field Mode use, and to add new syntax options.
  • Updated content to reflect BTEQ support for import records up to 1MB in size.
  • Updated Chapter 5 to reflect support for the database's new limit for Maximum Packed Records.
  • Updated Chapters 1 and 5 to reflect that the REPORTALIGN setting now determines the spacing used for Unicode, not UTF-8 output.
  • In Chapter 5, updated the "modname" element description for the EXPORT and IMPORT commands.
  • In Chapters 1 and 5, removed content supporting HP-UX PA-RISC.
  • Documented support for multi-condition IF statements and added ERRORONDBSWARNING command.
  • In Chapter 5, updated the "Backdoor Exports" section of the EXPORT command with z/OS-specific information.