SQR Server 6.2 Installation Guide

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

SQR Server 6.2 Installation Guide
© Copyright 2001 Brio Technology All rights reserved. Printed in the USA. This publication pertains to Brio.Report and to any subsequent release until otherwise indicated in new editions or technical notes. Information in this document is subject tochange without notice. The software described herein is furnished under a license agreement, and it may be used or copied only in accordance with the terms of the agreement.

Limited Warranty The Brio.Report application and Installation Guide are sold “as is,” without warrant as to their performance, merchantability, or fitness for any particular purpose. The entire risk as to the results andperformance of this program is assumed by you. However, to the original purchaser only, the publisher warrants the magnetic medium on which the program is recorded to be free from defects in materials and faulty workmanship under normal use for a period of ninety days from the date of purchase. If during the ninety-day period the medium should become defective, it may be returned to the publisher for areplacement without charge, provided you have previously executed a software license agreement. BrioQuery, BrioQuery Enterprise, Brio Broadcast Server, Brio OnDemandServer, Adaptive Reports, Brio.Insight, Brio.Quickview, Brio.Portal, Brio ONE, ONE/Publisher, ONE/Users, ONE/Services, ONE/Scheduler, ONE/Script, ONE/WebClient, ONE/API, ONE/Integrator, Brio.Report Builder, Brio.Report Viewer,Brio.Report Activator, SQR, SQR Server, SQR Execute, SQR Print, Personal SQR, Enterprise Information Portal, Empowered Reports, Report Surfing, and Smartcuts are trademarks or registered trademarks of Brio Technology, Inc. All other company and product names used herein may be the trademarks or registered trademarks of their respective companies.

Contents

SQR Server 6.2 Installation Guide BeforeInstalling SQR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Installing Personal SQR Version 6.2 on Windows 95/98 Systems . . . . . . . . . . . 3 Installing SQR Server Version 6.2 on Windows NT Systems . . . . . . . . . . . . . . 12 Configuring SQR DDO for Use with Essbase . . . . . . . . . . . . . . . . . . . . . . . 21 Installing SQR Server Version6.2 on UNIX Systems . . . . . . . . . . . . . . . . . . . . 22 Installing SQR Server 6.2 on IBM S/390/ OS/390 /DB2 Systems . . . . . . . . . . 30 Requirements for Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Hardware Requirements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Software Requirements . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . 30 Known Issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Installation Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Creating New Data Sets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 Setting up the Demo Database . . . . . .. . . . . . . . . . . . . . . . . . . . . . . 37 Including Your Own Subroutines and Functions . . . . . . . . . . . . . . 37 Running SQR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 Running SQR Execute . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42 Running SQR Print . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . 45 File Name Formats . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47 Differences Between SQR for OS/390 and Other SQR Versions . . . . . . . . 47 Troubleshooting Your SQR Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 52 Error when Trying to Use Oracle External Authentication…