Save a Report Specification with the Sreport Command
The
sreport command (see
sreport Command—Store Report Definition in a Database) is used to compile and store the report specification in the database. The sreport command reads the text file containing your report specification statements and performs the following tasks:
• Performs rudimentary syntax checking
• Loads the report specifications into your Ingres database from your base text file, including any additional Report-Writer code in files specified in .include statements
Note: If your database and database server reside on another system called the remote host, whenever you specify a database, indicate the v_node (virtual node) name of the remote host.
• Enters the report name in the Reports Catalog
If a report of the same name does not already exist in the Reports Catalog, sreport adds the specification into the database. If a report with the specified name already exists, sreport replaces the old report specification with the new one. The sreport command only adds or replaces a report if it detects no errors.
After you have stored a report specification with sreport, it appears in the RBF Report Catalog frame under the report name in your specification. You can run the report from RBF to produce it, but it cannot be edited from RBF.
Note: The sreport command compiles and stores a report, but does not run it. You execute a report with the report command, as described in the next section.