Controlling SQL - Basic Teradata Query

Basic Teradata Query Reference

Product
Basic Teradata Query
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

Use the following BTEQ commands to control SQL:

 
 

SQL Function

BTEQ Command

Override the precision specified by a CLI System Parameter Block (SPB) max_decimal_returned entry, or if that entry does not exist, indicate what the precision should be for decimal values associated with subsequently issued SQL requests for non-Field Mode responses.

DECIMALDIGITS

Enable users to specify whether the values of any fields associated with Identity Data are returned in response to an SQL Insert operation.

AUTOKEYRETRIEVE