Peoplesoft

SQR Language Reference
Brio Performance Suite™ 8

4980 Great America Parkway
Santa Clara, CA 95054 USA
+1(408)496-7400

SQR Language Reference — Brio Performance Suite™ 8
Part Number 1210981
Copyright © 2002 Brio Software, Inc.
All rights reserved. Printed in the United States of America.
This product and related products and documentation are protected by copyright and
aredistributed under licenses restricting their use, copying, distribution, and
decompilation. No part of this product or related documentation may be reproduced
in any form by any means without prior written permission of Brio Software and its
licensors.
Brio Software, Inc.
4980 Great America Parkway
Santa Clara, CA 95054
+1(408)496-7400
support@Brio.com
sales@Brio.com
www.Brio.com
Refer to theBrio Software License Agreement in this package before installing or using
the product.
If you find any errors or problems with this documentation, please notify Brio
Software. Brio Software does not guarantee that this document is without error. The
information in this document is subject to change without notice.

Trademarks
Brio®, Brio Software™, Brio Inform™, Brio Metrics Builder™,
BrioPerformance Suite™ 8, Designer™, Explorer™, Insight Server™,
Intelligence iServer™, Knowledge Server™, Reports iServer™, SQR™, and
SQR Developer™ are trademarks or registered trademarks of Brio Software, Inc.,
in the United States and other countries. All other marks are the trademarks or
servicemarks of Brio’s suppliers or partners and are the property of such third parties.

Contents inBrief

About This Book
CHAPTER 1 Introduction
CHAPTER 2 SQR Command Reference
CHAPTER 3 HTML Procedures
CHAPTER 4 Encoding in SQR
CHAPTER 5 SQR.INI
CHAPTER 6 SQR Samples
CHAPTER 7 SQR Messages
CHAPTER 8 Deprecated Information
Index

iv

Contents

About This Book
Audience . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .xiii
In This Book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
Related Documents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiv
Help . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
CHAPTER 1

IntroductionAbout SQR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-2
SQR Program Structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3
SQR Syntax Conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4
Rules for Entering SQR Commands . . . . . . . . . . . . . . . . . . . . .. . . . . . . . 1-5
SQR Tools . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-6
SQR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-6
SQR Execute . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-7
SQR Print . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-7
SQR Samples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-8
SQR Command Line . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-9
SQR Command-line Arguments . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . 1-9
SQR Command-line Flags . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-11
SQR Data Elements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-21
Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-21
Literals . . . . . . . . . . . . . . . . . . . . ....