Manual sql

Solo disponible en BuenasTareas
  • Páginas : 422 (105432 palabras )
  • Descarga(s) : 0
  • Publicado : 26 de abril de 2011
Leer documento completo
Vista previa del texto
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 are distributedunder 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 the Brio SoftwareLicense 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™, Brio Performance 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 in Brief

About This BookCHAPTER 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 Introduction About 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 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
tracking img