SQL Controls - Basic Teradata Query

Basic Teradata Query Reference

Basic Teradata Query
Release Number
May 2017
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

The following commands control attributes, modes and techniques for submission of SQL requests and for the responses and data that the database subsequently sends back.

BTEQ Command Function
AUTOKEYRETRIEVE Enables users to specify whether the values of any fields associated with Identity Data are returned in response to a SQL Insert operation
COMPILE Defines (creates or replaces) an SQL stored procedure in the database using an SPL input file.
DECIMALDIGITS Indicates what the precision should be for decimal values associated with subsequently issued SQL requests for non-Field Mode responses.
ENCRYPTION Toggles request-level Full-Stream Encryption ON or OFF.
INDICATORMODE Specifies Indicator Mode is to be used to return data rows from the Teradata Database in response to SQL data-returning requests. The data format includes indicator bit bytes for identifying null values.
LARGEDATAMODE Enables the use of the Teradata Database Multipart Indicator response mode. This can help for the retrieval of Large Data Objects (LDOs), such as CLOB, BLOB, JSON, and XML data types.
PACK Enables sending multiple import file records with an SQL request.
RECORDLENGTH Specifies the maximum record length for the current session. This affects imports, exports, and stdout hex-dump output.
RECORDMODE Specifies Record Mode is to be used to return data rows from the Teradata Database in response to SQL data-returning requests. Each row is presented in the same representation as it was returned in by the database, as specified by the SQL, using byte ordering appropriate for the client system. Null values, data types and data lengths are implicit.
RETRY Specifies whether requests that fail under certain error conditions should be resubmitted.
RETCANCEL Cancels a request when the value specified for rows by the RETLIMIT command is exceeded.
RETLIMIT Specifies the maximum number of rows and columns displayed on the terminal or written to a file in response to a Teradata SQL statement.
SESSION SQLFLAG Toggles issue of warnings in response to syntax errors in accordance with FIPS Publications 127-2 and 127-3 for ANSI compliance.
SESSION TRANSACTION Specifies whether transaction boundaries are determined by Teradata SQL semantics or ANSI standards.
STATEMENTINDEPENDENCE Specifies the database should treat certain data-related as statement-level errors which on their own will not cause an entire multi-statement request to fail. Also enables automatic cleansed retries.