Controlling SQL - Basic Teradata Query

Basic Teradata Query Reference

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

Controlling SQL

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