.spf - SQR Portable Format. The SPF data files are related to PeopleTools. SPF file is an SQR Portable Format data. SQR is a specialized language for database processing and reporting. SQR allows you to create a printer-independent output file, when you choose printer-independent output, SQR creates a file in SPF (SQR Portable Output File) format. On opening an.SPF, the SQR viewer displays. 'Can not find ‘C: WINDOWS TEMPORARY’ Can not open file' Internet Explorer has it’s default directory set to 'C: WINDOWS TEMPORARY INTERNET FILES' and older versions of the SQRiBE SPF Viewer ('SQRWV.EXE') don’t like spaces in filenames or directories (up to 4.0.3). On opening an.SPF, the SQR viewer displays. 'Can not find ‘C:WINDOWSTEMPORARY’ Can not open file' Internet Explorer has it’s default directory set to 'C:WINDOWSTEMPORARY INTERNET FILES' and older versions of the SQRiBE SPF Viewer ('SQRWV.EXE') don’t like.
- Sqr Viewer Spf Download Torrent
- Sqr Viewer Spf Download For Windows
- Sqr Viewer Spf Download Windows 7
- Spf File Viewer
SQR is a programming language specifically designed for SQL database reporting and information processing. It includes a unique blend of procedural and structured programming constructs (if, while, begin-procedure, etc.) and features to facilitate report writing (on-break, next-column, next-listing, new-report).
SQR runs on a variety of operating platforms (MS-Windows, many flavors of Unix, VMS, MVS, VM, etc.) and SQL databases (Oracle, Sybase, DB2, Informix, SQLBase, etc.). For this reason, it is a popular tool among database application vendors (such as PeopleSoft) as a way of allowing their applications to be implemented in a variety of technical environments.
SQR is developed and marketed by Oracle.
Sqr Viewer Spf Download Torrent
SQR was originally marketed by SQRIBE Technologies until that company was acquired by Brio in August 1999.Then Hyperion acquired Brio in late 2003, and Oracle acquired Hyperion in April 2007.
Included below are links to documents, utility programs, libraries, procedures, and even links to other resources.Feel free to use these on your projects. Suggestions welcomed.Let us know what you find to be useful.
Documents
- SQR Programmer Reference Card, v11.1.1Don Mellen, Editor, Ray Ontko & Co.
- SQR Programmer Reference Card, v9.xDon Mellen, Editor, Ray Ontko & Co.
- SQR Programmer Reference Card, v8.xDon Mellen, Editor, Ray Ontko & Co.
- SQR Programmer Reference Card, v6.xDon Mellen, Editor, Ray Ontko & Co.
- SQR Programmer Reference Card, v5.xDon Mellen, Editor, Ray Ontko & Co.
- SQR Programmer Reference Card, v4.xDon Mellen, Editor, Ray Ontko & Co.
- SQR Programmer Reference Card, v3.xDon Mellen, Editor, Ray Ontko & Co.
- SQR Programmer Reference Card, v2.xDon Mellen, Editor, Ray Ontko & Co.
- SQR Coding Standards and Naming ConventionsRay Ontko, Editor, Ray Ontko & Co.
- Ray's Top n SQR FeaturesRay Ontko, Editor, Ray Ontko & Co.
- Ray's Top n Uses for SQRRay Ontko, Editor, Ray Ontko & Co.
- Ray's Top n Suggested Enhancements for SQRRay Ontko, Editor, Ray Ontko & Co.
Libraries
- hp.sqh
hp printer support routine library.Contributed by Ray Ontko, Ray Ontko & Co. - csv.sqh
CSV file procedure library. Contributed by Ray Ontko, Ray Ontko & Co. - sylk.sqc
SYLK file procedure library. Contributed by James Womeldorf, Fastenal Company. - cgi-lib.sqh
Library that allows SQR to be called from a webserver using the Common Gateway Interface (CGI).Contributed by Eric Dimick Eastman, Ray Ontko & Co. - config.sqh
Config file procedure library. Contributed by Eric Dimick Eastman, Ray Ontko & Co.
Utilities
- bmp_to_hpg.sqr
SQR program to convert BitMaP (.bmp) image files to HP/GL (.hpg) files suitable for use with SQR. Thisallows you to use DECLARE-IMAGE and PRINT-IMAGE when you specify -printer:hp on the sqr command line.- Sample input .bmp file: test.bmp.
- Sample output .hpg file: test.hpg.
- Sample program: hpgl.sqr.
- lis_to_spf.sqr
SQR program to convert files in mainframe format to text/SPF/etc.format (e.g. in order to publish them using Brio Portal (formerly ReportMart)). As it converts, it can perform bursting based on text found at a particularlocation on each page. Bursting can cause multiple files to be generatedand/or (with SQR 4.1 and above) a Table-Of-Contents entry to be generatedin the output SPF file. (It can run under SQR3 with somewhatreduced functionality.)Contributed by Nathan Stratton Treadway, Ray Ontko & Co. - ora_doc.sqr
a report program which produces documentation about an ORACLE schema.It lists columns, constraints, indexes and comments for all tables owned by a user.Contributed by Ray Ontko, Ray Ontko & Co. - sqrsh.sqr
sqr shell program that does everything you ever wanted (autodoc, trace, profile, pretty, libr, etc).Contributed by Ray Ontko, Ray Ontko & Co.
Editor Config Files
- Ultra-Edit syntax file for SQR
A syntax file for Ultra-Edit updated to version 6.1.4 of SQR. The groupings have been re-arranged and named in a manner that made more sense to theauthor. Contributed by Don Mellen, Ray Ontko & Co. - VIM syntax file for SQR
A syntax file for VIM, based on the Ultra-Edit syntax file above.Contributed by Nathan Stratton Treadway, Ray Ontko & Co.
Examples
These are tiny, trival programs that illustrate something non-obvious about the SQR language.
- Recursion
Sometimes, especially if the data is organized in a hierarchical or tree structure, it makes sense to have a procedure call itself. This is known as a recursive call. SQR, unlike most languages, does not have a call stack. So, in order for the recursion to work as expected we have to emulate one in the SQR code itself. It gets even a bit more complicated if we need 'begin-select' sections in the recursive procedure. If SQR encounters the 'begin-select' line again before the previous cursor is closed it will just fetch the next row. Below are two examples, each with a correct program and one that you might think would work at first glance.- Fibonacci Sequence: Each number is the sum of the two previous numbers. So, the sequence starts: 1,1,2,3,5,8,13,21,34 . . . fib_right.sqrfib_wrong.sqr
- Family Tree: This example descends a family tree starting with an ancestor. recurse_right.sqrrecurse_wrong.sqr
- Vertical Printing
SQR doesn't directly support rotating text or other elements, but some of its output formats do. Here are a couple examples using PostScript. We have successfully used GhostScript to generate PDF from the PostScript.rotate_text.sqrrotate_text.pdf | rotate_barcode.sqrrotate_barcode.pdf
Procedures
- print_center.sqr centers proportionally spaced text on a position for printer=ps.Contributed by Mike Hill, Copyright Clearance Center, Inc.
Links
- Books
- SQR Programmer Reference by Don Mellen.
- SQR in PeopleSoft and Other Applications by Galina and Vlad Landres.
- Mailing Lists
- sqr-users SQR-Users list at sqrug.org
- sqr-jobs SQR job seekers' and recruiters' list
- rm-users ReportMart-Users list at sqrug.org (for the product now called 'Brio Portal')
- peoplesoft-fans at YahooGroups.com
- MAXIMO at YahooGroups.com
- MaximoAtlanta at YahooGroups.com
- a1a-peoplesoftjobs at YahooGroups.com (moderated)
- a1a-psjobs at YahooGroups.com (moderated)
- Brio Users Group for help with Brio's solutions
- Brio Reporting Tool List a discussion list for users of the Brio (Intelligence) reporting tool
- User Groups
- SQRUG SQR User Group
- IOUG International Oracle User Group
- Brio Users a Brio Intelligence user group
- Brio Enterprise NT Club a user club for Brio Intelligence NT users
- SLERP, a PeopleSoft- and SAP-orientedsite with a number of forums.
- SQR Programmer Resources
- SqrPlus by SRI Technologies
- SQR Tools VS by Textile Computer Systems.
- RJ's SQRW Developer by RJ Solutions.
- SQR Runner by CON+DEV Consulting und Development GmbH
- SQR Express, by Business Computing Solutions LLC
- HPPCL escape sequences (Link contributed by David Resh)
- Applications
- CSS HRizon, from ADP
- Maximo, from MRO Software (formerly named PSDI)
- Databases
- Informix (now owned by IBM)
- Ingres, from Computer Associates
- Red Brick (now owned by IBM)
- File Viewers
- PCL Viewer, by SoftCase
- Ghostview, PostScript and PDF viewer software
- Adobe Acrobat Reader, PDF viewer software
- Excel 97/2000 Viewer, by Microsoft, for viewing CSV output.
- Source Code Management
- CCC/Harvest, from Computer Associates (who purchased CCC/Harvest's prior owner, Platinum).
- MKS Source Integrity, from Mortice Kern Systems, Inc.
- PVCS, from Merant (formerly named Intersolv).
- Microsoft Visual Source Safe, from Microsoft.
- Mainsoft Visual Source Safe for Unix, from Mainsoft.
- Perforce.
- Report Repository Tools
- Brio Portal (formerly ReportMart), from Brio Software (formerly Brio Technology, who merged ReportMart's owner, SQRIBE Technologies).
- Report2Web (or alternate site), from Redwood Software (who merged with the company named Report2Web).
- products,from Mobius (makers of InfoPac).
Introducing a Sample Structured Query Report Program
This chapter discusses how to:
- Use this guide.
- Set up the sample database.
- Understand the sample program for printing a text string.
- Create and run a sample Structured Query Report (SQR) program.
- View SQR output.
Using This Guide
Initial sections of this guide teach the basic uses of SQR. You learn how to:
- Create a variety of reports, such as tabular, cross-tabular, and master and detail reports.
- Produce mailing labels, form letters, and envelopes.
- Enhance your reports with typeset-quality fonts and graphics.
- Produce graphs and charts that help you present data and trends visually.
Subsequent sections describe the advanced features and uses of SQR. You learn how to:
- Create HTML output and publish reports on the internet, an intranet, or an extranet.
- Create reports that can be easily ported between different systems and databases and that support different printer and display types.
- Create reports that format dates, numbers, and money according to local preferences.
- Integrate SQR with other software packages, such as front-end user interface tools and spreadsheets.
- Extend SQR with procedures and functions that are written in C.
- Test and debug programs.
- Tune programs for optimum performance.
The code examples demonstrate standard SQR programming style. Use this standard style to make your code easier for other SQR programmers to understand.
You can run the program examples in this guide without modification against the Oracle, Sybase, and Informix databases, and you can run them against other databases with minor modifications.
Audience
This guide was written for programmers who develop reports for relational databases. To use this guide effectively, you need a working knowledge of SQL and experience writing software programs. You also must be familiar with your particular database and operating system.
How to Use SQR for PeopleSoft Developers
Ultimate traffic 2 2013 edition fsx torrent. You can just read this book and study the sample programs. However, Oracle encourages you to try these programs for yourself and to experiment with them. Make some changes to the sample programs and see how they run.
To use the sample programs, you must first install SQR for PeopleSoft. SQR for PeopleSoft installs automatically when you install PeopleTools.
If you installed all of the program components, the sample programs are located in the TUTORIAL directory underneath <PS_HOME>binsqr<database_platform>.
You can run the sample programs on any hardware platform, but you may find it easier to review SQR program results from the Microsoft Windows platform by using the SQR Viewer or a web browser to verify your results.
Note. You can set up the sample database and run the sample programs with any username and password, although you may want to use an account that does not hold important data.
Related Documents
In addition to this developer’s guide, SQR for PeopleSoft includes SQR for PeopleSoft Language Reference, a complete reference to SQR commands, arguments, and command-line flags.
For information about supported database platforms, see Supported Platforms on My Oracle Support. You can also consult the PeopleTools Hardware and Software Requirements guide for a snapshot of current requirements.
Syntax Conventions
Syntax and code examples use the following conventions:
Convention | Description |
{ } | Braces enclose required items. |
[ ] | Square brackets enclose optional items. |
.. | Ellipses indicate that the preceding parameter can be repeated. |
| | A vertical bar separates alternatives within brackets, braces, or parentheses. |
' | A single quote starts and ends a literal text constant or any argument that has more than one word. Important! If you are copying code directly from the examples in the PDF file, make sure that you change the slanted quotes to regular quotes; otherwise, you will receive an error message. |
, | A comma separates multiple arguments. |
( ) | Parentheses must enclose an argument or element. |
UPPERCASE | SQR commands and arguments are uppercase within the text but lowercase in the code examples. (Note that these commands are not case-sensitive.) |
Variable | Information and values that you must supply appear in variable style. |
hyphen versus underscore | Many SQR commands, such as BEGIN-PROGRAM, use a hyphen, whereas procedure and variable names use an underscore. Procedure and variable names can contain either a hyphen or underscores, but using underscores in procedure and variable names to distinguish them from SQR commands is best. It also prevents confusion when you mix variable names and numbers in an expression, where hyphens could be mistaken for minus signs. |
Setting Up the Sample Database
To run the sample programs in this guide, you must create a sample database. To do so, run the loadall.sqr program:
- Change to the SAMPLE (or SAMPLEW for Microsoft Windows) directory under <PS_HOME>binsqr<database_platform>.
- At the command line, enter:
If SQR is installed on Microsoft Windows, you can run loadall.sqr by double-clicking the Loadall icon. If your system does not display this icon, run loadall.sqr from the SAMPLEW directory of SQR for PeopleSoft.
If an individual table already exists, you are prompted to enter:
- A: Abort the load.
- S: Skip the specified table.
- R: Reload the specified table.
- C: Reload all tables.
You can also run this as a batch program by entering the preferred option (A,S,R, or C) at the command-line. For example:
Considerations for DBX
The following considerations apply for DB2 on AIX and DB2 on ZOS.
DB2 on AIX
The DB2CLI.INI file (on Windows with the DB2 ODBC connection) should have the following entry.
This file is typically located in C:AppsDBDb2 directory.
DB2 on ZOS
The PSSQR.UNX or PSSQR.INI file should have the following line:
Understanding the Sample Program for Printing a Text String
The first sample program is the simplest SQR program. It prints a text string:
Note. For your convenience, all of the program examples and their output files are included with the installation. As mentioned, these samples are in the SQR for PeopleSoft directory <PS_HOME>binsqr<database_platform>SAMPLE (SAMPLEW for Microsoft Windows).
Take another look at the sample program. This program contains three lines of code, starting with BEGIN-PROGRAM and ending with END-PROGRAM. These two commands and the code between them make up the PROGRAM section, which is used to control the order of processing. The PROGRAM section is required, and you can have only one. It typically goes at or near the top of the program.
The PROGRAM section contains a PRINT command, which in this case prints the text Hello, World. This text is enclosed in single quotation marks ('), which are used in SQR to distinguish literal text from other program elements.
The last element of the PRINT command indicates the position on the output page. An output page can be thought of as a grid of lines and columns. The pair (1,1) indicates line 1, column 1, which is the upper-left corner of the page.
Note. In SQR, you must place each command on a new line. You can indent SQR commands.
Creating and Running a Sample SQR Program
This section discusses how to:
- Create an SQR program.
- Run an SQR program.
Creating an SQR Program
To create an SQR program:
- Open a text editor and enter the code in the sample program exactly as shown or open the ex1a.sqr file from the TUTORIAL directory.
- If you are writing the sample program, save your code with the name ex1a.sqr.SQR programs usually have a file extension of .sqr.
Running an SQR Program
Sqr Viewer Spf Download For Windows
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 the appropriate SQR program command at the system command prompt (UNIX/Linux or Microsoft Windows) or from within the graphical user interface (GUI) of the SQR application, where available (Microsoft Windows only).If you are using the command line, use SQR (UNIX/Linux) or SQRW (Microsoft Windows) to invoke SQR. Enter sqr or sqrw, the SQR program name, and the connectivity string, all on one line, using this syntax:
In a common configuration, you may be running SQR on Microsoft Windows against an Oracle database that is located on another machine in the network. Use this command format:
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 PeopleTools 8.52: SQR Language Reference for PeopleSoft.
See Specifying Output File Types by Using SQR Command-Line Flags.
Command Line Examples
Here are some examples for running SQR from the command line for different databases and platforms.
DB2 on Microsoft Windows
Sybase on Microsoft Windows
Sybase on Unix
Informix
Oracle on Unix
Microsoft SQL Server on Microsoft Windows
Sqr Viewer Spf Download Windows 7
Viewing SQR Output
SQR normally places the SQR program output files in the directory from which you run the program. 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. If you specified the -KEEP argument, one output file is in SQR Portable Format (recognizable by its .spf extension). SQR Portable Format is discussed later in this guide, but for now, you can view the sample program .spf file output, <filename>.spf, on Microsoft Windows platforms with the SQR Viewer GUI (sometimes referred to as an SPF Viewer). Invoke the SQR Viewer by entering sqrw at the command line.
On Microsoft Windows and UNIX/Linux systems, the program also produces an output file with an .lis extension. You can view this output file type from the command line with such commands as TYPE on Microsoft Windows systems or CAT, MORE, and VI on UNIX/Linux systems. Use the command that is appropriate to your system to view or print the .lis file.
The output for the example program looks like this for all platforms:
You may also see a character such as ^L or <FF> at the end of this output file. It is the form-feed character that ejects the last page. This guide does not show form-feed characters.