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 4. Production Reporting Command-line Flags
Flag | Description | Program | Database | ||
|---|---|---|---|---|---|
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. Restrictions:
| Production Reporting Server Production Reporting Execute Production Reporting Print | All | |||
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. | Production Reporting Server Production Reporting Execute | ODBC Oracle Sybase | |||
Specifies the bursting type.
See “Bursting and Demand Paging” in Volume 1 of the Hyperion SQR 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. | Production Reporting Server Production Reporting Execute Production Reporting Print | All | |||
(Windows) Displays the Cancel dialog box while the program runs to terminate program execution. | Production Reporting Server Production Reporting Execute | All | |||
(Windows, Callable Production Reporting) Forces the communication box to be used. | Production Reporting Server | All | |||
(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. | Production Reporting Server Production Reporting Execute Production Reporting Print | All | |||
Uses the specified database, which overrides any USE command in the Production Reporting program. | Production Reporting Server Production Reporting Execute | Sybase | |||
Compiles lines preceded by #DEBUG. Without this flag, Production Reporting ignores these lines. | Production Reporting Server | All | |||
Defines the default behavior for numeric variables. The value for xx can be INTEGER, FLOAT, DECIMAL, or V30. To specify a precision for DECIMAL, append it with a colon delimiter (:)—for example, ‑DNT:DECIMAL:20. See the DEFAULT argument for DECLARE-VARIABLE for a detailed explanation. If used, the DEFAULT argument in DECLARE‑VARIABLE takes precedence. | Production Reporting Server | All | |||
Directs error messages to the named file, or to the default file program.err. If no errors occur, no file is created. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
Defines the directory for Enhanced HTML applets. (The default directory for applets is IMAGES.) | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
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. | Production Reporting Execute Production Reporting Print | ||||
Production Reporting Server Production Reporting Execute Production Reporting Print | |||||
Defines the browser and generates the HTML.
Note: Only applicable with -PRINTER:EH or ‑PRINTER:EP. Only recognized when combined with -EH_FULLHTML. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
Production Reporting Server Production Reporting Execute Production Reporting Print | |||||
Production Reporting Server Production Reporting Execute Production Reporting Print | |||||
Production Reporting Server Production Reporting Execute Production Reporting Print | |||||
Produces a DBG output file containing compiler and internal error messages. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
Defines the directory where HTML should look for the referenced icons. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
Defines the directory path for the GIF files used by the Navigation Bar. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
Copies (does not move) the files when used in conjunction with ‑EH_ZIP. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
Defines the HTML navigation bar language. You can specify English, French, German, Italian, Japanese, Korean, Portuguese, Spanish, SChinese, or TChinese. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
Associates a PDF icon with {report}.pdf in the navigation bar. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
Production Reporting Server Production Reporting Execute Production Reporting Print | |||||
Specifies to not remove the directory path from the IMAGE reference. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
Production Reporting Server Production Reporting Execute Production Reporting Print | |||||
Moves generated files to the specified file or {report}.zip if {file} is not specified. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
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. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
Production Reporting Server Production Reporting Execute Production Reporting Print | |||||
Specifies the directories that Production Reporting searches when processing the #INCLUDE directive if the include file does not exist in the current directory and no path was specified for the file. The directory names must be separated by either commas (,) or semicolons (;). In UNIX, if your shell uses semicolons as command delimiters, precede each semicolon with a backslash (\). Always append the directory character to the end of each directory name. See the -F flag for a list of directory characters by operating system. For example, under UNIX: | Production Reporting Server | ||||
Creates SPF files in addition to LIS files for each report generated. (See Chapter 28, “Printing Issues,” in Volume 1 of the Hyperion SQR Production Reporting Developer's Guide for more information on LIS and SPF files.) | Production Reporting Server Production Reporting Execute | ||||
LOAD-LOOKUP: s = SQR, d = DB, c = case-sensitive, i = case‑insensitive (See LOAD‑LOOKUP ) | Production Reporting Server | ||||
Prevents the creation of all Production Reporting output file types. SPF output is created instead. | Production Reporting Server Production Reporting Execute | ||||
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. | Production Reporting Server Production Reporting Execute | ||||
Production Reporting Server Production Reporting Execute | |||||
Production Reporting Server Production Reporting Execute Production Reporting Print | |||||
xx | Printer Type | Example | |||
Enhanced HTML | -PRINTER:EH | ||||
Enhanced HTML/PDF | -PRINTER:EP | ||||
‑GD_DRIVER:name defines the name of the Generic Output Driver. ‑GD_OPTION:opts defines optional parameters to pass to the Generic output Driver. (The optional parameters are used to pass command line data to your personal application. The parameters entered depend on your application.) | Generic Output Driver | -PRINTER:GD To generate Excel documents, enter: -PRINTER:GD ‑GD_DRIVER:EXCEL To generate Word documents, enter: -PRINTER:GD -GD_DRIVER:WORD To generate Power Point documents, enter: -PRINTER:GD -GD_DRIVER:PP 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. | |||
Note: Production Reporting does not support color for ‑PRINTER:HP (HP PCL) output generation. | |||||
| |||||
Sets the TDS (Tabular Data Stream) packet size to the specified value. | Production Reporting Server Production Reporting Execute | ||||
Saves the program in a run-time file. The program is scanned, compiled, and checked for correct syntax. Queries are validated and compiled. Then, the executable version is saved in a file with the name program.sqt. Note that Production Reporting does not prompt for ASK variables after compilation. | Production Reporting Server | ||||
Uses the run-time file saved with -RS. Skips syntax and query checking and begins processing immediately. Note that Production Reporting does not prompt for ASK variables after compilation. | Production Reporting Server | ||||
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. | Production Reporting Server Production Reporting Execute | ||||
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. | Production Reporting Server Production Reporting Execute | ||||
Production Reporting Server Production Reporting Execute | |||||
Trims trailing zeros from the decimal portion of numeric columns. | Production Reporting Server Production Reporting Execute | ||||
| -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". | ||||
Production Reporting Server Production Reporting Execute | |||||
(non-Windows) Suppresses the Production Reporting banner and the “Production Reporting... End of Run” message. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
(Callable Production Reporting) Suppresses the database commit when the report finishes running. | Production Reporting Server | ||||
(Windows) Defines to not use the communication box. Requests for input are made in Windows dialog boxes. | Production Reporting Server Production Reporting Execute | ||||
Prevents Production Reporting from creating a frame in HTML files generated with -PRINTER:EH. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
Prevents user interaction during a program run. If ASK or INPUT requires user input, an error displays and the program ends. | Production Reporting Server Production Reporting Execute | ||||
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. | Production Reporting Server Production Reporting Execute | ||||
Production Reporting Server Production Reporting Execute | |||||
(Windows) Disables error message display so programs can run without interruption by error messages/warnings generated by Production Reporting, or by user generated messages (SHOW/DISPLAY). All messages still go to their designated output files (SQR.ERR or ‑E{filename} / SQR.LOG or ‑O{filename}) | Production Reporting Server | ||||
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. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
Prevents Production Reporting from creating temporary stored procedures. See BEGIN-SELECT for more information. | Production Reporting Server Production Reporting Execute | ||||
Preserves trailing blanks in LIS files at the end of a line. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
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. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
Production Reporting Server Production Reporting Execute Production Reporting Print | |||||
Sets the full path and name of the SQR initialization file, SQR.INI. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
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. | Production Reporting Server Production Reporting Execute | ||||
Defines the full path and name of the Production Reporting error message file, sqrerr.dat. | Production Reporting Server Production Reporting Execute Production Reporting Print | ||||
(DDO) Sets the full path and name of an alternate registry.properties file. Following is a common default path to the registry.properties file on a Windows system: c:\program files\hyperion\properties\registry.properties The registry.properties file lists datasources that Production Reporting can access. The information in the registry.properties file makes it possible for Production Reporting to access datasources for which DDO drivers have been loaded and configured. | Production Reporting Server Production Reporting Execute | ||||