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. |