Format Control Commands - 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 specify the way BTEQ presents information for screen-oriented and printer/printer-file oriented output:

 

Controlling Formats

 

Function

BTEQ Command

Reset the BTEQ format command options to their default configurations.

DEFAULTS

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

ECHOREQ

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

EXPORT

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

FOLDLINE

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

FOOTING

Enable the page-oriented format command options.

FORMAT

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

HEADING or RTITLE

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

IMPORT

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

INDICATORMODE or RECORDMODE or both

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

NULL

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

PAGELENGTH

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

QUIET

Control the spacing of UTF-8 report mode data.

REPORTALIGN

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

RETCANCEL

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

RETLIMIT

Resubmit requests that fail under certain error conditions.

RETRY

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

SEPARATOR

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

SIDETITLES

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

SKIPDOUBLE

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

SKIPLINE

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

SKIPLINE, then SKIPDOUBLE

Replace consecutively repeated values with blank character strings.

SUPPRESS

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

TITLEDASHES

Produce diagnostic status messages about table-change events.

TMSMMSG

Control the trimming of trailing spaces from field-mode response lines (which go to stdout or EXPORT REPORT file)

TRIMTRAILINGSPACES

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

UNDERLINE

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

WIDTH

See Chapter 5: “BTEQ Commands” for the complete syntax and description of each command.