We had a recent hosting glitch that prevented the Specific SQR Topics page from displaying. It's all better now. Sorry for the inconvenience.

When Oracle absorbed the hyperion.com site, and later when it switched the PeopleSoft information from Customer Connection to MetaLink, a number of SQR-related items were moved or (apparently) dropped completely. We have been attempting to track these down and either update the links or remove them as appropriate.

The ERPCommunity and PeopleSoft Fans discussion boards seem to be offline now and links to them have been removed. The Yahoo! Group named "PeopleSoft Fans" is still active.

The name "SQR" is generally no longer used by Oracle for the Hyperion version; it is now part of the Production Reporting component of Hyperion System 9 BI+. "SQR" is still used for the PeopleSoft version.

Are you an
independent contractor?
(Or need one?)

Tap into our network.

Protallian, the Professional Talent Alliance, is a self-referred network of independent contract consultants and engineers. We are in beta and currently inviting independent contractors specializing in SQR and/or PeopleSoft to join the network.

Member site: www.protallian.net
Client site: www.protallian.com

Yahoo! Groups > PeopleSoft-Fans Group
A moderated email list covering PeopleSoft topics, including SQR for PeopleSoft.

SQR Users Group > SQR-Users List
An active email list for SQR programming questions. Page also links to archives of past discussion topics.

SQR Users Group > Library
Sample code and tools.

Oracle MetaLink 3 Knowledge Base: SQR
Information on SQR for PeopleSoft. (Requires MetaLink 3 login.)

PeopleSoft SQR
Blog by Steven Alexander covering both PeopleSoft-related and general SQR topics.

Also see our Specific SQR Topics page

Hyperion Production Reporting (SQR) Language Reference
Designing Reports with The Production Reporting Language
Language and developer references for the current Hyperion version of SQR.

PeopleBooks > SQR Language Reference for PeopleSoft
PeopleBooks > SQR for PeopleSoft Developers
The PeopleBooks library contains the reference for the current PeopleSoft version of SQR, plus other related PeopleSoft components such as Process Scheduler.

SQR programmer's reference card
A comprehensive syntax reference for versions 2.x-8.2. (Marked as in progress. Previous version of the card: Versions 2.x-6.x)

Oracle Technology Network
Oracle's technical directory.

SQL Server Developer Center
Microsoft's technical directory for SQL Server.

DB2 Technical Resources
IBM's technical directory for DB2 UDB.

Sybase Developer Network
Sybase's technical directory.

SQR in PeopleSoft and Other Applications Second Edition: PeopleSoft v.8
By Galina Landres and Vlad Landres

SQR Programmer Reference, Second Edition
By Don Mellen

PeopleSoft 8.4 SQR Cheat Sheet
By Joseph Weessies

Related Titles

Essential Guide to PeopleSoft Development and Customization
By Tony DeLia, Galina Landres, Isidor Rivera and Prakash Sankaran

PeopleSoft HRMS Reporting
By Adam T. Bromwich

[Reciprocal Link] SP Debugger for SQR
A GUI-based, interactive SQR debugger.

[Reciprocal Link]SQR Express
A full-featured Integrated Development Environment designed specifically for SQR programmers.

Axis Computer Consulting Services > Downloads > Source Code > SQR/SQC
A number of SQR tools for printing, creating SQL, and scanning PeopleSoft databases.

Ray Ontko & Co. > Library > SQR Library
Editor configuration files, SQR utilities, SQR procedure libraries and links.

PSoftPros > Scripts > SQR Page 1 | 2 | 3
Many SQR code samples and utilities.

SQR Tools
Includes a function library and two code analyzers, along with other SQR information.

SQR Users Group > Library
Sample code and tools.

SqrParser Plugin for the jEdit Editor
Parses SQR programs to produce a structure tree.

SQR Tree
Produces an expandable tree of procedures and included files.

SQR to XML Spreadsheet
Library of SQR procedures to create Excel spreadsheets (including formulas and cell formatting) from within SQR programs.

[Reciprocal Link] SparkPath Technologies, Inc.
Provides PeopleSoft and SQR technical development and support.

Yahoo! Groups > SQR Jobs Group
A less-active, unmoderated email list for posting SQR-related resumes, project announcements, job announcements, help-wanted and work-wanted ads.

[Sponsored Link] Protallian Resources
A community of independent contract consultants, including SQR developers. 2 sites: For contractors | For clients

The SQR Evangelist
Why use SQR? One guru's experiences. Ask the SQR Evangelist.

Also see Publications

[Reciprocal Link]SQR Integrator: Turn your SQR platform into a powerful data warehousing environment

Application development-related links

Trade a link with us

Site ©2004-2009 SparkPath Technologies, Inc. and its licensors. All rights reserved.
This site is not affiliated with Oracle Corp.



Terms of use

Visit our
Specific SQR Topics page
 

SQR, from Oracle Corp., is a powerful and flexible programming language.

SQR generates presentation-quality reports for distribution through the web or via various file formats. While best known for its robust enterprise reporting capabilities, it also provides general-purpose procedural programming functionality useful for high-volume database/file access and updates. SQR runs on multiple database and operating system platforms.

Ownership of SQR has passed through a long series of companies. It was eventually acquired by Hyperion Solutions Corp.  In 2007, Hyperion was acquired by Oracle Corp.  SQR and programs developed using SQR are also delivered with PeopleSoft solutions. PeopleSoft, which was also acquired by Oracle, purchased rights to the SQR source code and maintained its own version of SQR. Almost all of the SQR coding-related information here and elsewhere on the internet will apply to both versions.

The PeopleSoft version is not sold separately. The name "SQR" has been largely retired from the Hyperion version; it is now simply a part of the Production Reporting component of Hyperion System 9.