Actuateclub.com

 

  About Actuate   |   Forums   |   Message Board  |   FAQ   |   Jobs    |   Actuate 100   |   Guest Book  |   Feedback  |   Sitemap   |   Home

Techieindex

 
SQR

 

Structured Query Report Writer is a one-step 4GL report writing and programming tool which allows you to use all the latent power built into SQL. SQR, Easy SQR, SQR Workbench is a powerful suite of report-writers for relational database, designed with the SQL language in mind.

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 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 Brio Technology (formerly SQRIBE).

Utilities

sqrsh.sqr

Sqr shell program that does everything you ever wanted (autodoc, trace ,  profile, pretty, ibr ,  etc).

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 particular location on each page. Bursting can cause multiple files to be generated and/or (with SQR 4.1 and above) a Table-Of-Contents entry to be generated in the output SPF file. (It can run under SQR3 with somewhat reduced functionality.)

ora_doc.sqr

Report program which produces documentation about an ORACLE schema. It lists columns, constraints, indexes and comments for all tables owned by a user.

 

 

 

Copyright © 2008 Techieindex