HP 3000 Manuals HP 3000 Manuals
Table of Contents
HP ALLBASE/SQL PC API User's Guide
HP ALLBASE/SQL PC API User's Guide : COPYRIGHT NOTICE
Ch 1. Getting Started
What Is PC API?
Client Environment
Server Environment
The Connecting Link
System Requirements
Database Server Supporting Environment
Hardware
Software
Optional Software
PC Client Supporting Environment
Hardware
Software
Optional Software
Compatible Networking Products
Application Software
Ch 2. Installing PC API
Migrating to the A.F0 Version of PC API
Prepare the Database Server
Verify That Supporting Software Is Running
Gather Information
Create the DBEnvironment on the Database Server
Prepare the PC Client
Install the Supporting Software
Check the Network Configuration
Install PC API on the PC Client
Setup PC API
Edit the AUTOEXEC.BAT File
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
Setup PC API on the Remaining PC Clients
Ch 3. Maintaining PC API
SQL.INI File
Using Other Routers
ALLBASE Connection String Syntax
Adding a New DBEnvironment Name
Adding a New User Logon
Improving Performance
SYSSQL System Catalog Views
Editing the VIEWS.SCP File
Executing VIEWS.SCP for Multiple DBEnvironments
ISQL and SYSSQL Views
Server Connection Assurance Timeout
Using the ANSI Character Set
Ch 4. Connecting to ALLBASE/SQL
Overview
Connecting to Multiple Databases and Multiple DBEnvironments
Connecting From Application Software
Connecting From SQLWindows
Connecting from Express Windows and SQLTalk
Connecting From PowerBuilder
Accessing IMAGE/SQL through PC API
Error Handling
Security
Controlling Access to the Database Server
Controlling Connect Access to the DBEnvironment
Controlling Access Within the DBEnvironment
Using Apostrophes and Quotes
Ch 5. Data Type Differences Between 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
Ch 6. SQL Differences Between ALLBASE/SQL and SQLBase
Mapped Constructs
Numbered Bind Variables
ROLLBACK and COMMIT Statements
Comparison Operators
The ; Terminator
Warning Message on Redundant COMMIT Statements
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
Outer Join
The IN Predicate
Isolation Levels
System Catalog Views
Ch 7. 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
Ap A. Error Messages From the PC Client
Ap B. PC API Files
Ap C. ALLBASE/SQL Reserved Words
INDEX
Index