HP 3000 Manuals HP 3000 Manuals
Information Access SQL/iX
(c) Copyright Hewlett-Packard Company 1995. All rights reserved. HP Part No. B3162-90002 Printed in U.S.A. Edition E0395 Printed November 7, 1997 NOTICE ------------------------------------------------------------------------------------------ | | | The information contained in this document is subject to change without notice. | | | | HEWLETT-PACKARD PROVIDES THIS MATERIAL "AS IS" AND MAKES NO WARRANTY OF ANY KIND, | | EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF | | MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. HEWLETT-PACKARD SHALL NOT BE | | LIABLE FOR ERRORS CONTAINED HEREIN OR FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES IN | | CONNECTION WITH THE FURNISHING, PERFORMANCE OR USE OF THIS MATERIAL WHETHER BASED ON | | WARRANTY, CONTRACT, OR OTHER LEGAL THEORY. | | | | Hewlett-Packard assumes no responsibility for the use or reliability of its software | | on equipment that is not furnished by Hewlett-Packard. | | | | This document contains proprietary information which is protected by copyright. All | | rights are reserved. No part of this document may be photocopied, reproduced or | | translated to another language without the prior written consent of Hewlett-Packard | | Company. | | | | Company or product names followed by (R) are U.S. registered trademarks of the | | respective company. Company or product names followed by (TM) are registered | | trademarks of the respective company. | | | | Lotus(R) 1-2-3(R), Symphony(R), and VisiCalc(R) are U.S. registered trademarks of | | Lotus Development Corporation. dBASE II(R), dBASE III(R), and dBASE IV(R) are U.S. | | registered trademarks of Ashton-Tate Corp. IBM(R), PC(TM), XT(TM), AT(TM), | | PC-DOS(R), PS/2(TM), and DisplayWrite 3 are trademarks of International Business | | Machines Corp. MS-DOS(R), Microsoft(R), Multiplan(R), Windows(TM), Excel(R), and | | Word(R) are U.S. registered trademarks of Microsoft Corporation. R:Base(TM) is a | | U.S. trademark of Microrim, Inc. ORACLE(R) is a U.S. registered trademark of Oracle | | Corporation. INGRES(TM) is a trademark of Ingres Corporation. PARADOX(R) is a | | registered trademark of Borland International. | | | ------------------------------------------------------------------------------------------ RESTRICTED RIGHTS LEGEND ------------------------------------------------------------------------------------------ | | | Use, duplication or disclosure by the U.S. Government is subject to restrictions as | | set forth in subparagraph (c)(1)(ii) of the Rights in Technical Data and Computer | | software clause in DFARS 252.227-7013. | | | | Rights for non-DOD U.S. Government Departments and Agencies are as set forth in FAR | | 52.227-19(c)(1,2). | | | ------------------------------------------------------------------------------------------ Printing History The manual printing date and part number indicate its current edition. To ensure that you receive the updated or new edition, you should subscribe to the appropriate product support service. See your HP sales representative for details. Printing date Edition Number --------------------------------------------------------------------------------------- June 1990 First Edition, E0690 May 1992 Second Edition, E0592 March 1995 Third Edition, E0395 About This Manual This manual is a basic reference guide to Information Access SQL/iX. Here is what you will find in it: * Chapter 1 is an introductory overview of Information Access SQL/iX. * Chapter 2 describes the environment in which Information Access SQL/iX runs. * Chapter 3 covers installation procedures. * Chapter 4 explains how to set up PC users to enable them to retrieve ALLBASE/SQL, ORACLE, and INGRES data through Information Access SQL/iX. * Chapter 5 gives performance tuning recommendations. * Appendix A describes Information Access SQL/iX error messages. * Appendix B lists languages and character sets supported by ALLBASE/SQL and ORACLE. * Appendix C lists data type mappings from ALLBASE/SQL and ORACLE to Information Access. * The glossary contains definitions of terms used in this manual. Who Should Read This Manual Read this manual if you are: * A Database Administrator (DBA) maintaining ALLBASE/SQL, ORACLE, or INGRES relational database management systems on an HP 3000 computer. * A System Manager with a working knowledge of HP 3000 Series 900 hardware and software and familiarity with MPE/iX operating system procedures. Where to Find More Information For more information about related Information Access software, see the following: * Using Basic Serial Connection Files * HP NewWave Access User's Guide * HP Information Access for Windows Help Facility For information about ALLBASE/SQL, see the following manuals for the 900 Series HP 3000 Computer Systems: * ALLBASE/SQL Database Administration Guide * ALLBASE/SQL Reference Manual * ALLBASE/SQL Quick Reference Guide * ALLBASE/ISQL Reference Manual * ALLBASE/SQL Message Manual * ALLBASE/NET User's Guide For information about ORACLE or INGRES, see the manual set that came with the product. Conventions This symbol represents a labeled key on the keyboard. For example, Shift is the shift key, Y is the Y key, and so on. Exceptions Keyboard Instructions: The Enter and Return keys discussed in our procedures and examples specifically refer to the Enter and Return keys on a terminal. If you are using an HP Vectra, IBM, Compaq, or othe Function Label Function Labels correspond to function keys labeled f1 through f8 on the keyboard. Some keyboards have another set labeled F1 through F12. Use whichever set you find more convenient, since the first eight keys perform the same function. To Choose a Function Press the corresponding function key on your keyboard. Label... OR, with a mouse, move the pointer to the Function Label on the screen, then press the select button. SCREEN TEXT Screen text represents text, examples, or syntax statements displayed on the screen. Examples and syntax statements may include an :MPE or program prompt, COMMANDS, ELEMENTS, variables, symbols, and punctuation. For example: :HELLO username.accountname :FILE T;DEV=TAPE;DEN=1600 :STORE filename.group.account;*T;SHOW COMMANDS and ELEMENTS are displayed in UPPERCASE to indicate that they are to be typed as shown. variables represent parameters you MUST replace with appropriate information. ;,". punctuation and *!@= are typed as shown except for {}braces and []brackets, symbols which are used to indicate alternates and options. {ALTERNATES} are COMMANDS, ELEMENTS, or variables within {braces}. At least one is required. { ALTERNATE A} Type A or B { ALTERNATE B} [OPTIONS] are COMMANDS, ELEMENTS, or variables within [brackets]. All are optional. [ OPTION A] Type A, B, or neither [ OPTION B]