HP 3000 Manuals HP 3000 Manuals
Table of Contents
HP PC API User's Guide for ALLBASE/SQL and IMAGE/SQL
HP PC API User's Guide for ALLBASE/SQL and IMAGE/SQL : COPYRIGHT NOTICE
Ch 1. Getting Started
What Is PC API?
Client Environment
Server Environment
The Connecting Link
System Requirements
Database Server Supporting Environment
Required Hardware
Required Software
Optional Software
PC Client Supporting Environment
Required Hardware
Required Software
Optional Software
Prepare the Database Server
Verify Software Version Numbers
Set the Connection Assurance Parameters
Start the Listener
Gather Information
Create the DBEnvironment on the Database Server
Prepare the PC Client
Install the Supporting Software
Check the Network Configuration
Download PC API from the Database Server
Downloading PC API
NetWare/iX
ARPA Services (FTP)
NS Services (DSCOPY)
Extracting the PC API file
Ch 2. Using the ODBC Interface
Installing and Configuring the ODBC Interface
Application Development with ODBC
Supported Functions
Isolation Levels
Connecting From Application Software
Connecting From Microsoft Access
Connecting from Visual Basic
ALLBASE/SQL Restrictions on the ODBC Grammar
Ch 3. Using the Gupta Interface
Installing the PC API Gupta Interface
Migrating to the A.G0 Version of PC API
Configuring the Gupta Interface
Edit the SQL.INI File
Check for Duplicate Files in Other Directories
Use Scriptor to Verify the Connection and Create Views
Execute the Verify Script
Execute the Views Script
Test the Application Software
Maintaining the SQL.INI File
Using Other Routers
ALLBASE Connection String Syntax
Adding a New DBEnvironment Name
Adding a New User Logon
Using the ANSI Character Set
Improving Performance
Understanding SYSSQL System Catalog Views
Editing the VIEWS.SCP File
ISQL and SYSSQL Views
Connecting From Application Software
Connecting from Q+E Database Editor
Connecting from the Q+E Database Library
Connecting from Quest
Connecting From SQLWindows
Connecting from Express Windows and SQLTalk
Using Apostrophes and Quotes
Using Different Data Types Defined By ALLBASE/SQL and SQLBase
How Different Data Typing Rules Affect PC API Users
How Data Type Differences Are Handled by PC API
CHAR and VARCHAR
The SQLBase LONG Data Type
DECIMAL and NUMERIC
INTEGER
NUMBER
SMALLINT
FLOAT and DOUBLE PRECISION (Long Floating Point)
FLOAT or REAL (Short Floating Point)
Date/Time Data Types
DATETIME
DATE and TIME
INTERVAL
Understanding the SQL Differences Between ALLBASE/SQL and SQLBase
Mapped Constructs
Numbered Bind Variables
ROLLBACK and COMMIT Statements
Comparison Operators
The ; Terminator
Ignored Warning and Error Messages
Unsupported SQLBase Syntax and Logical Constructs
Column Specification with ORDER BY
The @ Functions
Synonyms
ALTER TABLE Statement
Correlation Names in DELETE and UPDATE
Column Numbers in GROUP BY
Authorization Identifiers
DBEUserID
Group Name
Class Name
Passwords
The IN Predicate
Isolation Levels
Row Identifiers
System Catalog Views
Native Language Support for 16 Bit Character Sets
Ch 4. Unsupported ALLBASE/SQL Statements
Why Are Some ALLBASE/SQL Statements Unsupported?
ALLBASE/SQL Statements That Work Only with Embedded SQL
ALLBASE/SQL Statements Replaced by Functions on the PC Client
Ch 5. Troubleshooting
Tools on the Database Server
Monitoring Activity with HP GlancePlus/XL Program
Monitoring ALLBASE/SQL Activity with SQLMON
Avoiding Deadlocks with SET USER TIMEOUT
Checking the Listener Log File
Tools on the PC Client
Using HPDCRECORD to Log Packets
Using HPSQLNETLOG to Log Packets
ODBC Tools
Tracing Calls with Dr. DeeBee Spy
Gupta Interface Tools
Tracing Calls with Filter
Tracing Calls with Scriptor
Using the WHAT Utility to Check Versions
Ap A. Error Messages
Ap B. PC API Files
INDEX
Index