Production Reporting Command-line Flags

Production Reporting command-line flags begin with a dash (‑). When a flag takes an argument, the argument must follow the flag with no intervening space.

Table 1. Production Reporting Command-line Flags






Appends output to a file with the same name as the source. If the file does not exist, a new one is created. Useful for running a report multiple times with a single output file.


  • Only works with LIS files. Does not work with SPF files.

  • Only applies to line printers (-PRINTER:LP). Ignored for other printer types and output formats.

  • Only applies to SQR and SQRP in non-Windows environments.




Defines the number of rows to buffer when retrieving data. The default is 10 rows. Regardless of the setting, all rows are retrieved. On the command line, -B controls the setting for all BEGIN‑SELECT commands. In a program, each BEGIN‑SELECT command can have its own -B flag for further optimization.


ODBC Oracle Sybase


Specifies the bursting type.

  • -BURST:T generates the Table of Contents.

  • -BURST:S generates report output according to the symbolic Table of Contents entries defined with the level argument in ???. In -BURST:S[ {l} ], {l} is the level at which to burst. -BURST:S is equivalent to ‑BURST:S1.

  • -BURST:P generates report output by report page numbers. In ‑BURST:P[ {l} , {s} [, {s}.…] ] , {l} is the number of logical report pages that each HTML file contains and {s} is the page selection: {n}, {n}-{m}, -{m}, or {n}-. -BURST:P is equivalent to ‑BURST:P0,1- when using -PRINTER:HT or ‑BURST:P1 when using ‑PRINTER:EH.

See “Bursting and Demand Paging” in Volume 1 of the Production Reporting DeveloperÕs Guide for more information.

Note: ‑BURST:P and ‑BURST:S require -PRINTER:EH or ‑PRINTER:HT. The Page range selection feature of -BURST:P requires ‑PRINTER:HT. ‑BURST:T requires -PRINTER:HT.




(Windows) Displays the Cancel dialog box while the program runs to terminate program execution.




(non-Windows) Displays the report output at the same time it is written to the output file. nn is the maximum number of lines to display before pausing. If no number is entered after ‑D, the display scrolls continuously.

Note: The printer type must be LP or the display is ignored. If the program produces multiple reports, the display is for the first report only.




Uses the specified database, which overrides any USE command in the Production Reporting program.




Directs error messages to the named file, or to the default file program.err. If no errors occur, no file is created.




Defines the directory for Enhanced HTML applets. (The default directory for applets is IMAGES.)

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Generates a {report}.bqd file from the report data and associates a BQD (Brio Query Format File) icon with {report}.bqd in the navigation bar.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Associates BQD icons with the specified file.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Defines the browser and generates the HTML.

  • BASIC—Generates HTML suitable for all browsers.

  • IE—Generates HTML for Internet Explorer.

  • NETSCAPE —Generates HTML for Netscape.

  • ALL—If necessary, Production Reporting generates Basic, IE, and Netscape HTML files. Report_frm.htm contains Javascript to “sense” the browser on the user’s machine and display the appropriate version. (In this case, the user’s machine is the machine of the person reading the report, not the person writing it.)

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP. Only recognized when combined with -EH_FULLHTML.




Generates a {report}.csv file from report data.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Associates the CSV icon with the specified file.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Creates a CSV file but does not create an HTML file.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Produces a DBG output file containing compiler and internal error messages.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Defines the directory where HTML should look for the referenced icons.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Defines the directory path for the GIF files used by the Navigation Bar.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Copies (does not move) the files when used in conjunction with ‑EH_ZIP.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Defines the HTML navigation bar language. You can specify English, French, German, Italian, Japanese, Korean, Portuguese, Spanish, SChinese, or TChinese.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Associates a PDF icon with {report}.pdf in the navigation bar.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Sets the scaling factor from 50 to 200.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Specifies to not remove the directory path from the IMAGE reference.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Associates an XML icon with a file.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Moves generated files to the specified file or {report}.zip if {file} is not specified.

Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP.




Overrides the default output file name, program.lis.

The default action places the program.lis file in the same directory as the program.sqr file. To use the current directory, specify -F without an argument. To change the name of the output file, specify -F with the new name. If the new name does not specify a directory, the file is created in the current directory. The output file is not created until data actually prints on the page. If no data prints, no output file is created.

The following shows how to specify file names and directories for different operating systems.




Operating System

Directory Character












(non-Windows) Displays the copyright banner.




Creates SPF files in addition to LIS files for each report generated. (See Chapter 28, “Printing Issues,” in Volume 1 of the Production Reporting DeveloperÕs Guide for more information on LIS and SPF files.)




Prevents the creation of all Production Reporting output file types. SPF output is created instead.




Directs log messages to the specified file or to program.log if no file is specified. By default, the file sqr.log is used in the current working directory.




Retains trailing blanks in column data.




Uses printer type xx when creating output files.





Printer Type




Enhanced HTML




Enhanced HTML/PDF




‑GD_DRIVER:name defines the name of the Generic Output Driver.

‑GD_OPTION:opts defines optional parameters to pass to the Generic output Driver.

Generic Output Driver


To generate Excel documents, enter:


To generate Word documents, enter:


To generate Power Point documents, enter:


These commands create Office HTML files that can be opened by Word 2003, Word XP, Power Point 2003, Power Point XP, Excel 2003, and Excel XP. (For Office 2000 products, you can download a Microsoft tool to convert Office HTML files into something that Office 2000 products can open.)

Note: You can use the -F flag to change the output file name to report.doc, report.ppt, or report.xls.



HP LaserJet


Note: Production Reporting does not support color for ‑PRINTER:HP (HP PCL) output generation.



Line Printer
















  • LP, HP, and PS produce files with the .lis extension.

  • EH and HT produce .htm file output.

    • HT is controlled by the PrinterHT setting in the [Default-Settings] section of SQR.INI. If PrinterHT is set to standard, HT produces version 2.0 HTML files with the report content inside <PRE></PRE> tags. If PrinterHT is set to enhanced, HT is mapped to EH.

    • EH produces reports fully formatted with version 1.1 XHTML tags.

  • PD produces PDF 1.3 compliant files. When ‑PRINTER:PD is used, PRINT-DIRECT, PRINT …Code, and Print with CODE-PRINTER commands are processed but ignored.

  • On Windows systems, WP sends output to the default Windows printer. To specify a non-default Windows printer, use -PRINTER:WP:{Printer Name}. The {Printer Name} can be the name assigned to a printer; or, if the operating system permits it, the UNC name (i.e.\\Machine\ShareName). For example, to send output to a Windows printer named NewPrinter, you could use ‑PRINTER:WP:NewPrinter. If your printer name has spaces, enclose the entire command in double quotes.



Sets the TDS (Tabular Data Stream) packet size to the specified value.




Displays the status of all cursors at the end of the report run. Status includes the text of each SQL statement, the number of times each was compiled and executed, and the total number of rows selected. The output goes directly to the screen. This information can be used for debugging SQL statements and enhancing performance and tuning.




Specifies that you want to test your report for nn pages. To save time during testing, Production Reporting ignores all ORDER BY clauses in SELECT statements. For multiple reports, Production Reporting stops after the specified number of pages defined for the first report.




Trims trailing blanks from database character columns.


DB2 Sybase ODBC Teradata


Trims trailing zeros from the decimal portion of numeric columns.


DB2 Teradata

-U{priv_connectivity}, Directs SQR to connect to a privileged user and then proxy as the "user" from the normal connectivity piece.

sqr {program} {connectivity} -Upriv_connectivity [flags] [args]

For example:

sqr scott {prg} -Upriv/priv@instance

Logs in in as "priv/priv@instance" and then proxies to user "scott". All access is then be based "scott" and not "priv".



Uses the named server.




(non-Windows) Suppresses the Production Reporting banner and the “Production Reporting... End of Run” message.




(Windows) Defines to not use the communication box. Requests for input are made in Windows dialog boxes.




Prevents Production Reporting from creating a frame in HTML files generated with -PRINTER:EH.




Prevents user interaction during a program run. If ASK or INPUT requires user input, an error displays and the program ends.




Prevents Production Reporting from logging onto the database. Programs run in this mode cannot contain any SQL statements. ‑XL lets you run Production Reporting without accessing the database. You still must supply at least an empty slash (/) on the command line as a placeholder for the connectivity information.

For example: sqr myprog / -xl




Prevents trailing form feed.




Prevents Production Reporting from creating the Navigation Bar in HTML files generated with -PRINTER:HT and -PRINTER:EH. This occurs when only a single HTML file is produced. Multiple HTML files generated from a single report always contain the Navigation Bar.




Prevents Production Reporting from creating temporary stored procedures.




Preserves trailing blanks in LIS files at the end of a line.




Prevents Production Reporting from generating the Table of Contents for the report. This flag is ignored when ‑PRINTER:HT or -PRINTER:EP is also specified.




Sets the default encoding name.




Sets the full path and name of the SQR initialization file, SQR.INI.




Invokes the SPF Viewer after generating the program.spf file. Implicitly invokes -KEEP to create program.spf. For multiple output files, only the first report file passes to the Production Reporting Viewer.




Defines the full path and name of the Production Reporting error message file, sqrerr.dat.




(DDO) Sets the full path and name of an alternate file. Following is a common default path to the file on a Windows system:

c:\program files\hyperion\properties\

The file lists datasources that Production Reporting can access. The information in the file makes it possible for Oracle's Hyperion® SQR® Production Reporting to access datasources for which DDO drivers have been loaded and configured.