1 Version 4.0 -- 1/15/89 runrpt
______________________________________________________________________
NAME: runrpt
FUNCTION:
Stand-alone utility for running reports from the operating sys-
tem.
SYNTAX:
runrpt [db.owner.]reportname [optional_parameters]
Optional parameters:
[ -r reportparameter ]...
[ -f file | -p printer ] [ -s start_page_number ]
runrpt Version 4.0 -- 1/15/89 2
______________________________________________________________________
[ -e end_page_number ] [ -n number_on_first_page]
[ -E errorfile] [ -U username] [ -P password]
[ -S server] [ -I interfaces_file]
PARAMETERS:
-r reportparameter - specify report parameter. Use this flag
once for each report parameter. Report parameters are
optional.
-f file - specify operating system file destination for the
finished report. The report will overwrite an existing file.
If -f is not specified, the report will go to the printer
defined in the user's environment with the PRINTER environ-
ment variable (or to the printer specified with the -p flag).
-p printer - specify printer for the finished report. If -p is
not specified, the report will go to the printer defined in
the user's environment (or to the file specified with the -f
flag).
3 Version 4.0 -- 1/15/89 runrpt
______________________________________________________________________
-s start_page_number - specify start page number for the report.
The default starting page is 1.
-e end_page_number - specify end page number for the report.
The default ending page is the last page.
-n number_on_first_page - specify page number to print on the
first page of the report. Subsequent pages will be numbered
in sequence. The default is the actual page number of the
first page of the report.
-E errorfile - specify report writer error file. Default is
standard error.
-U username - allows the user to specify a login name. If no
login name is specified, the current user's login name is
assumed. Login names are case sensitive.
-P password - allows the user to specify a password. If -P has
no argument, runrpt uses the default password (NULL); put -P
by itself at the end of the command line. If -P is not
given, the user is prompted for a password. Passwords are
runrpt Version 4.0 -- 1/15/89 4
______________________________________________________________________
case sensitive.
-S server - specify the name of the SQL Server (the name defined
for DSQUERY). Server names are case sensitive, and they are
usually in upper case.
-I interfaces_file - specify the full file specification for the
location of the interfaces file.
COMMENTS:
o The runrpt program is invoked directly from the operating sys-
tem. Runrpt provides a non-interactive way of running reports
that have been created with the Data Workbench ReportWriter and
stored in the database. The formatted report can be sent to a
host file or to a printer.
o Values specified for report parameters should be enclosed in
quotation marks if they contain characters that could be signi-
ficant to the shell, or if they contain embedded blanks.
5 Version 4.0 -- 1/15/89 runrpt
______________________________________________________________________