This chapter provides an overview of SQR Print and discusses how to:
Generate output from the command line.
Use SQR Print command-line flags.
Generate output in Microsoft Windows.
SQR Print enables you to create printer-specific reports for any of the file types that are supported by SQR. SQR Print converts portable printer-independent files (spfs) into printer-specific files. SQR and SQRT (or SQRWT, for Windows) create .spf files when you use the -KEEP and -NOLIS command-line flags.
To begin running SQR Print, enter the following command. (If you are in Microsoft Windows, invoke SQRWP rather than SQRP.)
SQRP [spf-file] [flags...]
The following table describes spf-file and flags.
SQR Print writes an .lis file with the same name as the .spf file, but with the lis extension. You can override this name with the -F command-line flag.
The -PRINTER command-line flag specifies the printer type. SQR offers several options:
Line printer
HP LaserJet
PostScript
HTML
Enhanced HTML
Adobe PDF
Enhanced HTML and Adobe PDF
If the report contains graphics and you select a line printer, SQR Print ignores graphic elements (such as lines, boxes, and charts) and prints only text.
The following table describes the SQR Print command-line flags:
Flag |
Description |
Appends the output to an existing output file of the same name. If the file does not exist, it creates a new one. This flag is useful when you want to run the same report more than once, but you want to create only one output file. |
|
Specifies the type of bursting to be performed. -BURST:T generates the table of contents file only. -BURST:S generates the report output according to the symbolic table of contents entries that are set in the program with the TOC-ENTRY command's LEVEL argument. In -BURST:S[ {l} ], l is the level at which to burst. The -BURST:S setting is equivalent to -BURST:S1. -BURST:P generates the report output by report page numbers. In -BURST:P[ {l} , {s} [, {s}] …] ] , l is the number of logical report pages that each .htm file contains and s is the page selection: {n}, {n}-{m}, -{m}, or n-. The -BURST:P setting is equivalent to -BURST:P0,1- when using -PRINTER:HT or -BURST:P1 when using -PRINTER:EH. Note. -BURST:P and -BURST:S require -PRINTER:EH or -PRINTER:HT. The page range selection feature of -BURST:P requires -PRINTER:HT.
|
|
(Non-Microsoft Windows) Displays the report output on the terminal at the same time that it is being written to the output file. The nn is the maximum number of lines is displayed before pausing. If you don't enter a number after -D, the displayed output scrolls continuously. The printer type must be LP or the no output is displayed. If the program is producing more than one report, only the first report is displayed. |
|
Directs error messages to the named file or to the default file, program.err. If no errors occur, no file is created. Note. The following -EH flags are applicable only when either the −PRINTER:EH or −PRINTER:EP flag is specified. |
|
Specifies the directory location of the enhanced HTML applets. The default directory for theses applets is IMAGES. |
|
Generates a {report}.bqd file from the report data. Also associates a BQD icon with {report}.bqd in the navigation bar. |
|
Associates the BQD icon with the specified file. |
|
Specifies the target browser. When set to ALL, SQR automatically determines which browser is being used, invokes a browser-specific file, and generates HTML that is designed for that browser. When set to BASIC, SQR generates HTML that is suitable for all browsers. When set to IE, SQR generates HTML that is designed for Microsoft Internet Explorer. When set to NETSCAPE, SQR generates HTML that is designed for Netscape. |
|
Generates a {report}.csv file from the report data. |
|
Associates the CSV icon with the specified file. |
|
Creates a CSV file, but does not create an HTML file. |
|
Switches between HTML 3.0 and HTML 3.2. When set to TRUE, SQR generates HTML 3.2. When set to FALSE, SQR generates HTML 3.0 |
|
Specifies the directory in which the HTML should find the referenced icons. |
|
Sets the language that is used for the HTML navigation bar. You can specify English, French, German, Portuguese, Spanish, Japanese, Simplified Chinese, or Korean. |
|
Associates a PDF icon with {report}.pdf in the navigation bar. |
|
Sets the scaling factor from 50 to 200. |
|
Overrides the default output file name, program.lis. The default action places program.lis 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 is actually printed on the page. If no data is printed, no output file is created. Specify these file names and directories for different operating systems:
|
|
Displays the copyright banner on the console. |
|
Directs log messages to the specified file or to programt.log if no file is specified. By default, the sqr.log file is used in the current working directory. |
|
(IBM MVS) Suppresses printer control characters from column 1. |
|
Causes SQR to use printer type xx when creating output files:
Types LP, HP, and PS produce files with the .lis extension. Types EH and HT produce .htm file output. On Microsoft Windows systems, the WP extension sends the output to the default Microsoft Windows printer. To specify a nondefault Microsoft Windows printer, enter -PRINTER:WP:{printer name}. The {printer name} is the name that is assigned to the printer. For example, to send output to a Microsoft Windows printer named NewPrinter, use -PRINTER:WP:NewPrinter.If your printer name has spaces, enclose the entire argument in quotes. If you also want to create an .spf file, use -KEEP. |
|
(Non-Microsoft Windows) Suppresses the SQR banner and the SQR.... End of Run message. |
|
Prevents SQR from creating the navigation bar in .htm files that are generated with -PRINTER:HT. This occurs when only a single .htm file is produced. Multiple .htm files that are generated from a single report always contain the navigation bar. |
|
Preserves the trailing blanks in a .lis file at the end of a line. |
|
Prevents SQR from generating the table of contents for the report. This flag is ignored when -PRINTER:EH or -PRINTER:HT is also specified. |
|
Sets the full path and name of the SQR initialization file, sqr.ini. |
|
Specifies the full path and name of the SQR error message file, sqrerr.dat. |
In Microsoft Windows, SQR Print's graphical user interface enables you to generate output from the Print dialog box. In addition to the previously mentioned SQR Print output options, you can also select a Microsoft Windows printer. This spools the SQR output to your default Microsoft Windows printer or print server.
To generate output in Microsoft Windows:
Select File, Print.
The Print dialog box appears.
Under Generate output for, select the option next to the type of output that you want.
Specify a file path.
Select the Print to file check box.
Click OK.