Equivalent to the +t flag. Causes aggregates to occur over rounded values for any floating point column whose format has been specified in a .format statement as numeric F or template. The value is a blank string. Each value is rounded to the precision given in its format, based on displayed data rather than on internal database values.

Syntax:

Equivalent to the -f flag. Directs the formatted report (output) to the file name specified by the value. If you do not specify a file name, the report is written to the file specified in output; if you do not specify a filename in either place, the report is displayed on the screen.

Equivalent to the -h flag. Creates headers and footers even when the report contains no data, executing all .header and .footer sections and suppressing the detail section. The value is a blank string. Allows an .if statement in report footer to verify that no rows were found. See Character-based Querying and Rporting Tools User Guide for details.

Syntax:

Equivalent to the +b flag. Forces form feeds at page breaks, overriding report-formatting commands. The value is a blank string.

Syntax:

Equivalent to the -m flag. Specifies the mode. Values: tabular, wrap, and block. Use the mode parameter with the name parameter only; mode has no effect when used with the report parameter.

If you do not specify a style, Report-Writer creates a default report based on the width of your report. Use pagewidth to change the default.

If you do not use the mode parameter, RBF takes one of the following actions:

Equivalent to the -q flag. Sets the maximum length of the query specified in the .query command to the specified number of characters following all substitutions for runtime parameters. Only needed for very long queries. The value is an integer.

Equivalent to the -w flag. Sets the specified number as the maximum number of lines within any block. The value is an integer. Default : 300.

Names a database table or view for the default report

Indicates the parameters for the report. The value is a quoted parameter string or the name of a field containing the parameter string.

Use the format pname='value' and separate the string with blanks or tabs (with no blanks around the equals sign.) Enclose nonnumeric values passed in an element in standard quotes, with the following exception.

If pname is a character report parameter, enclose value in double quotes within single quotes (' " " '). Place a backslash (\) before embedded double quotes.

VMS: If pname is a character report parameter, enclose value in a set of double quotes. (Note that it is easier to pass a parameter by calling a report frame.)

Equivalent to the -t flag. Causes aggregates to occur over internal database values rather than on the displayed data for any floating point column whose format has been specified in a .format statement as numeric F or template. The value is a blank string.

Syntax:

Equivalent to the -b flag. Suppresses form feeds, overriding report-formatting commands. The value is a blank string.

Equivalent to the -v flag. The value is an integer. Sets the page length, overriding .pagelength commands in the report. Default: 61 lines per page if report is written to a file, and your terminal length per page if written to the terminal.

Equivalent to the -l flag. Sets the page width, overriding .pagewidth commands in the report. Defaults depend on style of report: block: 80; wrap: 100; tabular and column: no default. Needed only for reports with very long lines. The value is an integer.

Equivalent to the -o flag. Specifies that the value is a printer name (overrides the default printer). Additional memory is required to print large reports.

VMS: Initializes the printer queue to print a job flag page.

Equivalent to the -n flag. Lets you specify the number of copies to be printed. The value is an integer. Default: 1 copy.

Equivalent to the -r flag. Indicates that the value is a report, rather than a table or view, and displays the report. The value is a report name.

Equivalent to the -s flag. Suppresses some informational messages, but not prompts. The value is a blank string.

Syntax:

Equivalent to the -i flag. Requests that the report specification be read from a source file outside the Reports Catalog. With this flag, the specified source file is not saved in the database. To save the report specification in the database, use the sreport command. You cannot use this flag in conjunction with the -m or -r flags. You can specify only one filename. Do not specify a report, table, or view on the command line.

Requests report compatibility with Ingres release 5. Use with brkfmt option to ensure compatibility. Displays month of current_date in capitals if no format is specified. With -5 set, the date appears as dd-MMM-yyyy.

Requests that all distinct rows be reported when the following reports are executed: SQL default reports, SQL reports that contain .data, .table, .view, or .sort statements. Without -6, duplicate rows are reported in these SQL reports. Does not apply to QUEL reports.

Specifies the flags in effect. The value is a list of flags. Includes most system-level command line flags (except -u). Separate items in the list with a blank or tab.