HP 3000 Manuals HP 3000 Manuals
900 Series HP 3000 Computer Systems HP PC API User's Guide for ALLBASE/SQL and IMAGE/SQL HP Part No. 36216-90104 Printed in U.S.A. Edition First Edition E0494
________________________________________________________________________ |The information contained in this document is subject to change | |without notice. | | | |HEWLETT-PACKARD MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS | |MATERIAL, 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 use of this | |material. | | | |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. | ________________________________________________________________________ Copyright (c) 1991, 1992, 1993, 1994 by Hewlett-Packard Company Impromptu(TM) is a trademark of Cognos. Crystal Reports(TM) is a trademark of Crystal Computer Services Inc. Lotus(TM) and 1-2-3(TM) are trademarks of Lotus Development Corporation. Express Windows(TM), Quest(TM), ReportWindows(TM), SQLBase(TM), SQLWindows(TM) and SQLTalk/Windows(TM) are trademarks of Gupta Technologies, Incorporated. Forest and Trees(TM) is a trademark of Trinzic, Inc. HRMS(TM) and SQR(TM) are trademarks of PeopleSoft, Incorporated. MS-DOS(R), Microsoft(R), are U.S. registered trademarks of Microsoft Corporation. Microsoft Access(TM) and Microsoft Windows(TM) are trademarks of Microsoft Corporation. PowerBuilder(TM) is a trademark of Powersoft Corporation. Q+E(TM) is a trademark of Q+E Software. Quarterdeck(TM) is a trademark of Quarterdeck Corporation. Dr. DeeBee Spy(TM) is a trademark of SYWARE, Inc. Printed April 1994 Printing History The following table lists the printings of this document, together with the respective release dates for each edition. The software version indicates the version of the software product at the time this document was issued. Many product releases do not require changes to the document. Therefore, do not expect a one-to-one correspondence between product releases and document editions. Edition Date Software Version -------------------------------------------------------------------------------------- First Edition April 1994 36216-02A.G0.00 ALLBASE/SQL Manuals and IMAGE/SQL Manuals Title Customer Order Number -------------------------------------------------------------------------------------- ALLBASE/NET User's Guide 36216-90031 ALLBASE/SQL Advanced Application Programming Guide 36216-90100 ALLBASE/SQL C Application Programming Guide 36216-90023 ALLBASE/SQL COBOL Application Programming Guide 36216-90006 ALLBASE/SQL Database Administration Guide 36216-90005 ALLBASE/SQL FORTRAN Application Programming Guide 36216-90030 ALLBASE/SQL Message Manual 36216-90009 ALLBASE Pascal Application Programming Guide 36216-90007 ALLBASE/SQL Performance and Monitoring Guidelines 36216-90102 ALLBASE/SQL Reference Manual 36216-90001 Getting Started with HP IMAGE/SQL 36385-90008 HP ALLBASE/QUERY User's Guide 92534-90011 HP IMAGE/SQL Administration Guide 36385-90001 HP PC API User's Guide for ALLBASE/SQL and IMAGE/SQL 36216-90104 ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL 36216-90096 Up and Running with ALLBASE/SQL 36389-90011 Additional Resources You may find the following manuals helpful: * HP GlancePlus/XL User's Manual * 4GL Programming Guides from Hewlett-Packard: HP ALLBASE/4GL Developer Self-Paced Training Guide HP ALLBASE/4GL Developer Reference Manual, V.1 HP ALLBASE/4GL Developer Reference Manual, V.2 HP ALLBASE/4GL Developer Administration Manual HP ALLBASE/4GL Developer Quick Reference Guide HP ALLBASE/4GL Run-Time Administration Manual HP ALLBASE/4GL Software Update Notice B.04 * Other manuals from Hewlett-Packard: HP GlancePlus/XL User's Manual Using the 900 Series HP 3000: Fundamental Skills NetIPC 3000/XL Programmer's Reference Manual Berkeley Sockets/iX Reference Manual NetWare for the HP 3000 Concepts NetWare for the HP 3000 Installation NetWare for the HP 3000 System Administration NetWare for the HP 3000 User Basics for DOS Workstations NetWare for the HP 3000 Utilities Reference NetWare for the HP 3000 System Administration MPE/iX Supplement NetWare for the HP 3000 System Error Messages Preface The HP PC API User's Guide for ALLBASE/SQL and IMAGE/SQL describes how to install and maintain HP PC API. HP PC API can access ALLBASE/SQL and IMAGE/SQL on the HP 3000 Series 900 or ALLBASE/SQL on the HP 9000 Series 700/800. This guide is written for the HP 3000 system administrator installing HP PC API and the application software developer and user on the PC client. Information about the PC client is the same whether it is connected to an HP 3000 or HP 9000. However, information about the database servers varies and therefore a user's guide has been written for each platform. The differences are in the following areas: * the system requirements * logon syntax * specification of the database * supported networking types For information on the HP 9000 database server, refer to the HP 9000 version of this manual, HP PC API User's Guide for ALLBASE/SQL. MPE/iX, Multiprogramming Executive with Integrated POSIX, is the latest in a series of forward-compatible operating systems for the HP 3000 line of computers. In HP documentation and in talking with HP 3000 users, you will encounter references to MPE XL, the direct predecessor of MPE/iX. MPE/iX is a superset of MPE XL. All programs written for MPE XL will run without change under MPE/iX. You can continue to use MPE XL system documentation, although it may not refer to features added to the operating system to support POSIX (for example, hierarchical directories). This guide is divided as follows: * Chapter 1, "Getting Started," describes the product and lists the hardware and software requirements for HP PC API on both the client and server. This chapter also describes how to prepare the environment on both the client and server. * Chapter 2, "Using the ODBC Interface," describes ODBC and provides information on its use with ALLBASE/SQL and IMAGE/SQL. * Chapter 3, "Using the Gupta Interface," describes Gupta interface and its use with ALLBASE/SQL and IMAGE/SQL. Configurations and the SYSSQL views are discussed. * Chapter 4, "Unsupported ALLBASE/SQL Statements," lists ALLBASE/SQL statements that are not supported by HP PC API. * Chapter 5, "Troubleshooting," describes the available troubleshooting tools on the database server and PC client. * Appendix A, "Error Messages," describes various error messages that the application returns. * Appendix B, "PC API Files," lists the files included with the product. What's New in this Release The following items are new in this release: * Support for the Microsoft ODBC interface has been added. * The A.G0.00 release of PC API is now bundled with ALLBASE/SQL and IMAGE/SQL. * The Gupta interface supports HP 3000 16 bit NLS character sets. * New server connection architecture. * Support for WINSOCK and WLIBSOCK network interface libraries. Conventions UPPERCASE In a syntax statement, commands and keywords are shown in uppercase characters. The characters must be entered in the order shown; however, you can enter any character in either uppercase or lowercase. For example: COMMAND can be entered as any of the following: command Command COMMAND ComMand italics In a syntax statement or an example, a word in italics represents a parameter or argument that you must replace with the actual value. In the following example, you must replace FileName with the name of the file: COMMAND FileName punctuation In a syntax statement, punctuation characters (other than brackets, braces, vertical bars, and ellipses) must be entered exactly as shown. In the following example, the parentheses and colon must be entered: (FileName):(FileName) underlining Within an example that contains interactive dialog, user input and user responses to prompts are indicated by underlining. In the following example, yes is the user's response to the prompt: Do you want to continue? >> yes { } In a syntax statement, braces enclose required elements. When several elements are stacked within braces, you must select one. In the following example, you must select either ON or OFF: COMMAND {ON } {OFF} [ ] In a syntax statement, brackets enclose optional elements. In the following example, OPTION can be omitted: COMMAND FileName [OPTION] When several elements are stacked within brackets, you can select one or none of the elements. In the following example, you can select OPTION or Parameter or neither. The elements cannot be repeated. COMMAND FileName [OPTION ] [Parameter] [...] In a syntax statement, horizontal ellipses enclosed in brackets indicate that you can repeatedly select the element(s) that appear within the immediately preceding pair of brackets or braces. In the example below, you can select Parameter zero or more times. Each instance of Parameter must be preceded by a comma: [,Parameter][...] In the example below, you only use the comma as a delimiter if Parameter is repeated; no comma is used before the first occurrence of Parameter: [Parameter][,...] |...| In a syntax statement, horizontal ellipses enclosed in vertical bars indicate that you can select more than one element within the immediately preceding pair of brackets or braces. However, each particular element can only be selected once. In the following example, you must select A, AB, BA, or B. The elements cannot be repeated. {A} |...| {B} ... In an example, horizontal or vertical ellipses indicate where portions of an example have been omitted. _ In a syntax statement, the space symbol _ shows a required blank. In the following example, Parameter and Parameter must be separated with a blank: (Parameter)_(Parameter) The symbol indicates a key on the keyboard. For example, RETURN represents the carriage return key. CTRLcharacter CTRLcharacter indicates a control character. For example, CTRLY means that you press the control key and the Y key simultaneously.