Sqr sample program

Running an SQR Program To run the sample program: Change to the directory in which you saved the program using the command that is appropriate to your operating system. Enter sqr or sqrw, the SQR program name, and the connectivity string, all on one line, using this syntax: [sqr or sqrw] [program] [connectivity] [flags Command Line Examples Here are some examples for running SQR from the command line for different databases and platforms.

SQR Prints a graph of the forecasted and actual sales for a given employee. SQR Prints a graph of the forecasted and actual sales for a month or quarter. SQR Prints a graph of the planned and actual sales for a given employee. SQR Prints a graph of the planned and actual sales for month or quarter. SQR Prints a list of all of the customers, bursted by page. SQR Demonstrates printing mailing labels within columns. SQR Demonstrates the use of arrays. SQR Demonstrates dynamic queries to enable the user to qualify a report as it runs.

SQR Prints a group of information about each customer in the customer table. SQR Demonstrates the flat file output for magnetic tape or other postprocessing. DAT Needed for append. SQR Prints a list of all of the employees, bursted by page. SQR Calculates each employee's commission, based on sales.

SQR Lists all employee quotas for a given month or quarter. SQR Demonstrates the use of printing envelope with proper bar codes. SQR Demonstrates a floating bar chart. SQR Creates a sales forecast for a given customer, grouped by month or quarter. SQR Creates a sales forecast for a given employee, grouped by month or quarter. SQR Creates a sales forecast for a given product, grouped by month or quarter.

SQR Creates a sales forecast for a given region, grouped by month or quarter. SQR Creates a table of projected product sales with links to more information. SQR Demonstrates form letters by using a document paragraph. SQR Demonstrates a high-low-close chart. SQR Demonstrates a histogram chart. SQR Demonstrates creating multiple reports, printing invoices, and printing envelopes. SQR Demonstrates creating multiple reports. SQR Demonstrates nesting procedures. SQR Lists all of the orders and the order lines that are associated with them.

SQR Lists all orders for a given month and groups them by employee number. SQR Lists all orders for a given month or quarter. The high-level programming capabilities of SQR enable you to add procedural logic and to control data source calls. You can use SQR to write other types of applications, such as those for database manipulation and maintenance, table loading and unloading, and interactive querying and displaying.

SQR for PeopleSoft processes source code from a standard text file and generates a report. The following examples show the general structure of SQR:. The following table describes the SQR syntax conventions:. Ellipses indicate that the preceding parameter can be repeated. A vertical bar separates alternatives inside brackets, braces, or parentheses. An exclamation point begins a single-line comment that extends to the end of the line.

Each comment line must begin with an exclamation point. A single quote starts and ends a literal text constant or any argument with more than one word.

If you correctly replace username, password, and servername with the appropriate information, you should have a command line like this:. To produce the output file for this exercise, the example uses the -KEEP flag, which is defined later in this guide.

See Enterprise PeopleTools 8. Here are some examples for running SQR from the command line for different databases and platforms. The output file has the same file name as the SQR file that created it, but the file extension is different. The output files should appear as soon as your program has finished running. Invoke the SQR Viewer by entering sqrw at the command line.

Use the command that is appropriate to your system to view or print the. It is the form-feed character that ejects the last page. This guide does not show the form-feed characters.

A vertical bar separates alternatives within brackets, braces, or parentheses. Information and values that you must supply appear in variable style.