SQR
Encyclopedia
SQR is a programming language
designed for generating reports from database management systems. The name is an acronym of Structured Query Reporter, which suggests its relationship to SQL
(Structured Query Language). Any SQL statement can be embedded in an SQR program.
Inc. Sybase purchased SQ Software in the early 1990s. To avoid competing directly with Oracle Corporation
, Sybase
had a marketing and development agreement with MITI for the Oracle database versions of SQR. MITI acquired the full rights to SQR in the mid 1990s. MITI changed its name to SQRiBE Technologies in 1997. Brio Technology
acquired SQRiBE in August, 1999. Brio Technology
later changed its name to Brio Software. Brio licensed the compiler source code to PeopleSoft
Inc. sometime around 2000. Hyperion Solutions
Corporation acquired Brio Software in October, 2003. Oracle Corporation
acquired PeopleSoft
in December, 2004. And as of March 2007 Oracle Corporation
has acquired Hyperion Solutions
.
and printing functions. It can embed any SQL
statement almost anywhere in a program. There is a version of SQR that can use multidimensional databases like Essbase
. It can combine database
reads with print instructions. It flexibly formats data breaks and page breaks. It prints variable fonts, sizes, and colors. It has a graph generation command that offers dozens of parameters for adjusting content and appearance.
s. The first three are numeric (variables
begin with “#”), character string (variables
begin with “$”), and date (variables
begin with “$”, same as with character string variables
.). Date variables
must be declared, to be distinguished from character string variables
. There is the option to declare numeric variables
to specify them more precisely (integer
, floating point
, etc.). The last data type is a database
column (variables
begin with “&”). The values of database
columns are set only by a SQL “select” statement; no other command can change their values.
SQR has arrays of like those of the C programming language
or COBOL
. An array has one or more fields, each field is either a numeric, string, or date variable
. Each field may have multiple occurrences, giving SQR the equivalent of two-dimensional arrays. SQR has special commands that manipulate multiple items within a single array. There are also many commands that cannot use an array element in place of a scalar variable
.
SQR has four control structures. The first three are if-else-end, while-end, and evaluate (like case or switch). The fourth is the embedded SQL
“select” statement, which allows SQR statements to be executed for each row of data in a loop.
SQR has commands to open, read, write, append, and close computer file
s. File input and output is sequential and record-oriented only; random access
is not supported.
The Report is good for printing
Programming language
A programming language is an artificial language designed to communicate instructions to a machine, particularly a computer. Programming languages can be used to create programs that control the behavior of a machine and/or to express algorithms precisely....
designed for generating reports from database management systems. The name is an acronym of Structured Query Reporter, which suggests its relationship to SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
(Structured Query Language). Any SQL statement can be embedded in an SQR program.
History
SQ Software created SQR in the mid 1980s. It had a marketing agreement with D & N Systems, which changed its name to SQL Solutions and was later acquired by SybaseSybase
Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....
Inc. Sybase purchased SQ Software in the early 1990s. To avoid competing directly with Oracle Corporation
Oracle Corporation
Oracle Corporation is an American multinational computer technology corporation that specializes in developing and marketing hardware systems and enterprise software products – particularly database management systems...
, Sybase
Sybase
Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....
had a marketing and development agreement with MITI for the Oracle database versions of SQR. MITI acquired the full rights to SQR in the mid 1990s. MITI changed its name to SQRiBE Technologies in 1997. Brio Technology
Brio Technology
Brio Technology was a San Francisco Bay area software company cofounded in 1984 by Yorgen Edholm and Katherine Glassey. The company is best known for their business intelligence software systems, starting with DataPivot on the Apple Macintosh. Brio Software was acquired by Hyperion in 2003...
acquired SQRiBE in August, 1999. Brio Technology
Brio Technology
Brio Technology was a San Francisco Bay area software company cofounded in 1984 by Yorgen Edholm and Katherine Glassey. The company is best known for their business intelligence software systems, starting with DataPivot on the Apple Macintosh. Brio Software was acquired by Hyperion in 2003...
later changed its name to Brio Software. Brio licensed the compiler source code to PeopleSoft
PeopleSoft
PeopleSoft, Inc. was a company that provided Human Resource Management Systems , Financial Management Solutions , Supply Chain and customer relationship management software, as well as software solutions for manufacturing, enterprise performance management, and student administration to large...
Inc. sometime around 2000. Hyperion Solutions
Hyperion Solutions
Hyperion Solutions Corporation was a business performance management software company, located in Santa Clara, California, USA, which was acquired by Oracle Corporation in 2007...
Corporation acquired Brio Software in October, 2003. Oracle Corporation
Oracle Corporation
Oracle Corporation is an American multinational computer technology corporation that specializes in developing and marketing hardware systems and enterprise software products – particularly database management systems...
acquired PeopleSoft
PeopleSoft
PeopleSoft, Inc. was a company that provided Human Resource Management Systems , Financial Management Solutions , Supply Chain and customer relationship management software, as well as software solutions for manufacturing, enterprise performance management, and student administration to large...
in December, 2004. And as of March 2007 Oracle Corporation
Oracle Corporation
Oracle Corporation is an American multinational computer technology corporation that specializes in developing and marketing hardware systems and enterprise software products – particularly database management systems...
has acquired Hyperion Solutions
Hyperion Solutions
Hyperion Solutions Corporation was a business performance management software company, located in Santa Clara, California, USA, which was acquired by Oracle Corporation in 2007...
.
SQR-Related Products
- ORACLE: Hyperion SQR Production Reporting - System 9 (Release 9.3.1, 2008);
- ORACLE: PeopleSoft Enterprise Tools & Technology (PeopleTools, Release 8.49, 2008)
General Components
- SQR Server
- SQR Viewer
- SQR Print
- SQR Execute
- SQR Workbench for Windows; SQR Developer
Features
SQR is notable for its powerful databaseDatabase
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...
and printing functions. It can embed any SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
statement almost anywhere in a program. There is a version of SQR that can use multidimensional databases like Essbase
Essbase
Essbase is a multidimensional database management system that provides a multidimensional database platform upon which to build analytic applications. Essbase, whose name derives from "Extended Spread Sheet dataBASE", began as a product of Arbor Software, which merged with Hyperion Software in 1998...
. It can combine database
Database
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...
reads with print instructions. It flexibly formats data breaks and page breaks. It prints variable fonts, sizes, and colors. It has a graph generation command that offers dozens of parameters for adjusting content and appearance.
Syntax
SQR has four scalar data typeData type
In computer programming, a data type is a classification identifying one of various types of data, such as floating-point, integer, or Boolean, that determines the possible values for that type; the operations that can be done on values of that type; the meaning of the data; and the way values of...
s. The first three are numeric (variables
Variable (programming)
In computer programming, a variable is a symbolic name given to some known or unknown quantity or information, for the purpose of allowing the name to be used independently of the information it represents...
begin with “#”), character string (variables
Variable (programming)
In computer programming, a variable is a symbolic name given to some known or unknown quantity or information, for the purpose of allowing the name to be used independently of the information it represents...
begin with “$”), and date (variables
Variable (programming)
In computer programming, a variable is a symbolic name given to some known or unknown quantity or information, for the purpose of allowing the name to be used independently of the information it represents...
begin with “$”, same as with character string variables
Variable (programming)
In computer programming, a variable is a symbolic name given to some known or unknown quantity or information, for the purpose of allowing the name to be used independently of the information it represents...
.). Date variables
Variable (programming)
In computer programming, a variable is a symbolic name given to some known or unknown quantity or information, for the purpose of allowing the name to be used independently of the information it represents...
must be declared, to be distinguished from character string variables
Variable (programming)
In computer programming, a variable is a symbolic name given to some known or unknown quantity or information, for the purpose of allowing the name to be used independently of the information it represents...
. There is the option to declare numeric variables
Variable (programming)
In computer programming, a variable is a symbolic name given to some known or unknown quantity or information, for the purpose of allowing the name to be used independently of the information it represents...
to specify them more precisely (integer
Integer
The integers are formed by the natural numbers together with the negatives of the non-zero natural numbers .They are known as Positive and Negative Integers respectively...
, floating point
Floating point
In computing, floating point describes a method of representing real numbers in a way that can support a wide range of values. Numbers are, in general, represented approximately to a fixed number of significant digits and scaled using an exponent. The base for the scaling is normally 2, 10 or 16...
, etc.). The last data type is a database
Database
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...
column (variables
Variable (programming)
In computer programming, a variable is a symbolic name given to some known or unknown quantity or information, for the purpose of allowing the name to be used independently of the information it represents...
begin with “&”). The values of database
Database
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...
columns are set only by a SQL “select” statement; no other command can change their values.
SQR has arrays of like those of the C programming language
C (programming language)
C is a general-purpose computer programming language developed between 1969 and 1973 by Dennis Ritchie at the Bell Telephone Laboratories for use with the Unix operating system....
or COBOL
COBOL
COBOL is one of the oldest programming languages. Its name is an acronym for COmmon Business-Oriented Language, defining its primary domain in business, finance, and administrative systems for companies and governments....
. An array has one or more fields, each field is either a numeric, string, or date variable
Variable (programming)
In computer programming, a variable is a symbolic name given to some known or unknown quantity or information, for the purpose of allowing the name to be used independently of the information it represents...
. Each field may have multiple occurrences, giving SQR the equivalent of two-dimensional arrays. SQR has special commands that manipulate multiple items within a single array. There are also many commands that cannot use an array element in place of a scalar variable
Variable (programming)
In computer programming, a variable is a symbolic name given to some known or unknown quantity or information, for the purpose of allowing the name to be used independently of the information it represents...
.
SQR has four control structures. The first three are if-else-end, while-end, and evaluate (like case or switch). The fourth is the embedded SQL
SQL
SQL is a programming language designed for managing data in relational database management systems ....
“select” statement, which allows SQR statements to be executed for each row of data in a loop.
SQR has commands to open, read, write, append, and close computer file
Computer file
A computer file is a block of arbitrary information, or resource for storing information, which is available to a computer program and is usually based on some kind of durable storage. A file is durable in the sense that it remains available for programs to use after the current program has finished...
s. File input and output is sequential and record-oriented only; random access
Random access
In computer science, random access is the ability to access an element at an arbitrary position in a sequence in equal time, independent of sequence size. The position is arbitrary in the sense that it is unpredictable, thus the use of the term "random" in "random access"...
is not supported.
The Report is good for printing