Format Control Commands - Basic Teradata Query

Function

BTEQ Command

Cancel a request when the value specified by the RETLIMIT command ROWS option is exceeded.

RETCANCEL

Control the spacing of UTF-8 report mode data.

REPORTALIGN

Display a row of dash characters before each report line summarized by a WITH clause.

TITLEDASHES

Display a row of dash characters whenever the value of a specified column changes.

UNDERLINE

Enable the echo required function that returns a copy of each Teradata SQL request and BTEQ command to the standard output stream.

ECHOREQ

Enable the page-oriented format command options.

FORMAT

Insert a blank line in a report whenever the value of a specified column changes.

SKIPLINE

Insert two blank lines in a report whenever the value of a specified column changes.

SKIPDOUBLE

Insert three blank lines in a report whenever the value of a specified column changes.

SKIPLINE, then SKIPDOUBLE

Limit BTEQ output displays to error messages and request processing statistics.

QUIET

Open a file with a specific format to transfer information to the Teradata Database.

IMPORT

Open a file with a specific format to transfer information from the Teradata Database.

EXPORT

Position summary titles to the left of the summary lines in a report.

SIDETITLES

Replace consecutively repeated values with blank character strings.

SUPPRESS

Reset the BTEQ format command options to their default configurations.

DEFAULTS

Resubmit requests that fail under certain error conditions.

RETRY

Specify a character or character string to represent null field values returned from the Teradata Database.

NULL

Specify a character string or width (in blank characters) to separate columns of a report.

SEPARATOR

Specify a footer to appear at the bottom of every page of a report.

FOOTING

Specify a header to appear at the top of every page of a report.

HEADING or RTITLE

Specify the response mode (Field Mode, Indicator Mode, or Record Mode) for data selected from the Teradata Database.

INDICATORMODE or RECORDMODE or both

Specify the maximum number of rows or columns or both displayed or written in response to a Teradata SQL request.

RETLIMIT

Specify the page length of printed reports, in lines per page.

PAGELENGTH

Specify the width of screen displays and printed reports, in characters for each line.

WIDTH

Split (fold) each line of a report into two or more lines.

FOLDLINE

Produce diagnostic status messages about table-change events.

TMSMMSG