Use the following BTEQ commands to specify the way BTEQ presents information for screen-oriented and printer/printer-file oriented output:
DEFAULTS |
PAGEBREAK |
SIDETITLES |
ECHOREQ |
PAGELENGTH |
SKIPDOUBLE |
EXPORT |
QUIET |
SKIPLINE |
FOLDLINE |
RECORDMODE |
SUPPRESS |
FOOTING |
REPORTALIGN |
TITLEDASHES |
FORMAT |
RETCANCEL |
TMSMMSG |
HEADING |
RETLIMIT |
TRIMTRAILINGSPACES |
IMPORT |
RETRY |
UNDERLINE |
INDICATORMODE |
RTITLE |
WIDTH |
NULL |
SEPARATOR |
|
OMIT |
SHOW CONTROLS |
|
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.