HP 3000 Manuals HP 3000 Manuals
Index
A
aborts
and timeouts
adding
users and DBEnvironments
ALLBASE
connection string syntax
ALLBASE.DLL
description
ALLBASE/NET
and listener process
version required
allbase section
in the SQL.INI file
ALLBASE section
in the SQL.INI file
ALLBASE/SQL
data type rules
data types
DBEnvironment creation
embedded statements
features of
version required
ALLBASSP.DLL
description
ALTER PASSWORD
used in SQLBase
ALTER TABLE statement
restrictions on
ANSI character set
converting from ROMAN8 character set
ANSTART
syntax
ANSTAT
syntax
ANSTOP
syntax
application software
compatible with PC API
description
in client/server environment
testing
when to install
ARPA
location of host name
ARPA Listener
and listener process
ARPA Services
connection assurance parameters
parameter in connection string syntax
authorities
granting
authorization
identifiers
B
bind variables
definition
C
C++
and Q+E Library
C/API
See Gupta interface
CATALOG.SCP
description
CATALOG.SQL
description
Catalog tables
loading
C language
and 4GL tools
class name
definition
client
operating environment
client environment
description
client/server environment
description
client software
order of installation
code names
default
codes
and SQLWindows
changing in the VIEWS.SCP file
coding
in C and SQL
command files in ISQL
to add and remove views
COMMENT ON
SQLBase statement
COMMENT ON COLUMN
SQLBase command
COMMIT
warning message
comparison operators
and mapped constructs
configuration of client
sockets, demand load
ConFlag
parameter in LastUser line
connecting
from application software
from Microsoft Access
connection
between PC and server
requests
server timeouts
SQL statements related to
to multiple DBEnvironments
connection assurance parameters
connection string
convertion option
conversion flag
in connection string syntax
converting
character sets
syntax to convert to ANSI character set
converting HPDC.LOG
using DISPLOG
cursor stability isolation level
use with PC API
D
database
accessing multiple
database code
explained
in connection string syntax
in installation
database sample
creation of
database server
preparing for installation
data communication port
and the listener
data communication software
and listener process
connection assurance parameters
default order of loading
parameters in connection string syntax
required on the client
required on the server
data types
date and time
differences between ALLBASE/SQL and SQLBase
different implementations
how differences are handled
impact of differences
numeric
SQLBase date and time constants
summary of differences
translation of
date and time constants
SQLBase
date and time data types
differences
DBA authority
and installation
and Views Script
DBALLBAS.EXE
description
DBEName
parameter in LastUser line
syntax
DBEnvironment
adding
adding new names
creating
database code
opening mutiple
DBEnvironment name
adding to SQL.INI file
syntax
DBEUserID
definition
DBMS
in a client/server environment
DDL
description
deadlock
non-detectable
DefaultIsolation
defined in ODBC.INI
default names
in SQL.INI file
DELETE statement
correlation names in
deleting Quest tables
demand load
in configuration of client
DISK.ID
description
disk space
for Gupta interface
for ODBC interface
for the Gupta interface
disk storage requirements
on the client
DISPLOG.EXE
description
Displog program
to convert HPDC.LOG
DLLs
definition
domain name service file
DRDBSP.DLL
description
DRDBSP.EXE
:description
DRDEEBEE.LOG
creation
Dr. DeeBee Spy
and troubleshooting
dynamic link library
description
E
embedded SQL
unsupported
error message
for redundant COMMIT statements
error messages
ignored by PC API
errors
and unsupported SQL
during installation
etc/hosts
Excel
version required
EXECUTE IMMEDIATE
used by PC API
Express Windows
connecting from
extended character sets
conversion from ROMAN8
extracting
Gupta files
ODBC files
F
features
of ALLBASE/SQL
FILTER.DLL
description
filter trace
FILTER.DLL description
Forest and Trees
version required
@ functions
SQLBase
functions
ODBC
G
GRANT CONNECT TO
syntax
granting authorities
syntax
graphical interface design tools
GROUP BY
column numbers
group name
definition
Gupta
troubleshooting
Gupta interface
installing the SYSSQL views
server-independent system catalog views
used with SQLBase
H
hardware requirements
disk storage
memory
server
Host
parameter in LastUser line
host name
where defined
HOSTS.NET.SYS
HP 3000
used with ThinLAN 3000/iX
HP ARPA Services
connection assurance parameters
HPDAARLG log file
HPDANSLG log file
HP GlancePlus
and troubleshooting
HP LAN Manager
description
HP Network Services
description
on the client
HP Network Services (NS)
connection assurance parameters
parameter in connection string syntax
HPSQLNETLOG
and troubleshooting
Human Resource Management System
version required
I
Impromptu
version required
IN predicate
syntax
installation
of client supporting software
SYSSQL views
installing
ODBC interface
the Gupta interface
ISO 8859/1
and ROMAN8 character set
isolation levels
definition
in SQLBase and ALLBASE/SQL
with SQLTalk
with SQLWindows
ISQL
installing and removing views
used for DBA functions
L
LAN
card required on the client
in supporting operating environment
LAN Manager
on the client
LastUser
syntax in ODBC.INI
listener
checking status
description
log file
starting
starting, stopping, checking
stopping
listener process
description
loading data
in PartsDBE sample database
log files
listener
logging on
to HP 3000 server
logging tracing packets
logon
adding a new user
logon string
in SQL.INI file
syntax
Lotus 1-2-3
version required
M
mapped constructs
comparison operators
definition
numbered bind variables
ROLLBACK and COMMIT syntax
the ; terminator
warning message on redundant COMMIT statements
mapping
of system catalog views
memory management software
as option on the client
recommendation
memory requirements
on the client
Microsoft Developer Network (MSDN)
Microsoft Windows
version required
migrating
from previous version of PC API
mpedbname
adding to SQL.INI file
and SQLWindows
defined for installation
in connection string syntax
MPE/iX
logon
logon string
version required
mpeuser
adding to SQL.INI file
defined for installation
in connection string syntax
MS-DOS
memory required
NETSETUP command
version required
MS LAN Manager
and LAN Manager
multiple DBEnvironments
connecting to
N
NETCONTROL STATUS
NetIPC
parameter in connection string syntax
verification of configuration
NetType
parameter in LastUser line
NetWare
parameter in connection string syntax
NetWare/iX
and HP ThinLAN 3000/iX
and listener process
on the client
NetWare Listener
and listener process
starting
network addresses
saving
network configuration
checking
networking
connection assurance parameters
networking software
default order of loading
on the client
parameters in connection string syntax
Network Services (NS)
connection assurance parameters
parameter in connection string syntax
network type
in connection string syntax
node manager capability
to start network
node name
defined
in connection string syntax
where defined
ns
parameter in connection string syntax
NS
location of node name
NS3000/iX
and listener process
NS Listener
and listener process
numbered bind variables
definition
numeric data types
O
ODBC Administrator
and Data Source Names
ODBC API Reference
ODBC functions
ODBCVIEW.HP
description
downloading to PC
operating environment
client
server
optimistic locking
and row identifiers
optional software
on the client
on the server
order
for installation of supporting software
ordering Microsoft SDK
owner names
and authorities
P
PartsDBE sample database
creation
passwords
syntax in connection string syntax
used in SQLBase
PC
advantages
PC API
description
how it works
PC API driver version number
performance
improving through the SQL.INI file
placeholder
for passwords
PowerBuilder
version required
preparation
of PC client
PREPARE
used by PC API
preparing
the database server for installation
product components
description
programming
C
Q
Q+E Database Editor
connecting from
version required
Q+E Database Library
connecting from
Quarterdeck Expanded Memory Manager (QEMM)
as option on the client
query tools
compatible with PC API
Quest
connecting from
R
read committed isolation level
use with PC API
README.HP
description
read only isolation level
use with PC API
read uncommitted isolation level
use with PC API
release lock isolation level
use with PC API
release numbers
for ALLBASE/SQL
for IMAGE/SQL
for TurboIMAGE/XL
replacement strings
and SQLWindows
report writing tools
compatible with PC API
resources
and timeouts
Resource Sharing
description
ROLLBACK and COMMIT
in SQLBase
ROMAN8 character set
converting to ANSI character set
router
additional
syntax
router information
in the SQL.INI file
ROWID
and optimistic lock
S
sample database
creation
Scriptor
and troubleshooting
starting
SCRIPTOR.EXE
description
scripts
how to execute
used in Scriptor
section header
in SQL.INI file
security
granting authorities
SELECT statement
with ORDER BY
server
hardware requirements
operating environment
server1
in the SQL.INI file
server environment
description
server-independent views
how to install
SessionID
part of the logon string
SET USER TIMEOUT
and deadlocks
socket buffer size
in configuration of client
sockets
parameter in connection string syntax
software
application
data communication
installation on the client
memory management
order of installation on the client
requirements on the client
Software Developers Kit (SDK)
software requirements
PC client
SPX/IPX protocol
required on the client
required product on the server
SQL
and program development
differences between ALLBASE/SQL and SQLBase
embedded statements
logical constructs
related to passwords
syntax
SQLAPIW.DLL
description
SQLAPIW.LIB
description
SQLAPIY.DLL
description
SQLAWIN.DLL
description
SQLBase
data type rules
porting applications to ALLBASE/SQL
SQL coding
and 4GLs
sqldemo section
in the SQL.INI file
SQL.H
description
SQL.INI file
and SQLWindows
changes to
connection string syntax
duplicates
example
identification of routers
maintaining
purpose
SQLMON
troubleshooting
SQLSetup script
DBEnvironment creation
SQLTalk
and isolation levels
connecting from
SqlUser variable
used in SQLWindows
SQLWindows
and isolation levels
and SQL differences
connecting from
Sqlconnect call
SqlDatabase variable
SqlPass variable
SqlUser variable
version required
stopping
the listener
STREAMS command
and listener process
supporting software
installation on client
server
support tools
listed
symbols
translation between SQLBase and ALLBASE/SQL
synonyms
used in SQLBase
syntax
SQL.INI file at installation
sysadm
in the SQL.INI file
SYSSQL
mapping to ALLBASE/SQL system catalog views
SYSSQL views
and migration
how to install
purpose of
system catalog views
comments in
how to install
installing
mapping
purpose of
SQLBase and ALLBASE/SQL
system requirements
for PC API
T
TCP/IP protocol
product required on the server
required on the client
TERMINATE USER
and deadlocks
terminator
adding the ;
testing
application software
ThinLAN 3000/iX
and listener process
and NetWare Listener
product required
timeout
and deadlocks
server connection
timeouts
and abnormal PC aborts
tools
support
tracing calls
with Dr. DeeBee Spy
tracing packets
logging
translating
data types
translation
CHAR to LONG VARCHAR
TRLT.DLL
description
TRLT.SCP
and troubleshooting
troubleshooting
avoiding deadlocks
using Dr. DeeBee Spy
using filter
using HPDCRECORD
using HP GlancePlus
using HPSQLNETLOG
using Scriptor
using SQLMON
using the WHAT utility
tuple ID (TID)
U
UNCATALG.SCP
description
to delete Quest tables
UNCATALG.SQL
description
unsupported ALLBASE/SQL statements
BEGIN DECLARE SECTION
CLOSE CURSOR
CONNECT
DECLARE CURSOR
DESCRIBE
DISCONNECT
END DECLARE SECTION
EXECUTE
EXECUTE IMMEDIATE
explained
FETCH
INCLUDE
OPEN
PREPARE
REFETCH
RELEASE
RESET
SQLEXPLAIN
START DBE
START DBE NEW
START DBE NEWLOG
STOP DBE
WHENEVER
unsupported functions
COMMENT ON
COMMENT ON COLUMN
synonyms
unsupported SQL
ALTER PASSWORD
and logical constructs
column numbers in GROUP BY
correlation names
@ functions
UNVIEWS.SCP
description
UNVIEWS.SQL
description
ISQL script to remove views
UPDATE statement
correlation names in
user code
explained
in connection string syntax
in installation
UserName
parameter in LastUser line
users
adding
V
VERIFY.SCP
description
used in Scriptor
Verify Script
how to execute
version
checking with the WHAT utility
views
comparison of SQLBase and ALLBASE/SQL
installing views owned by SYSSQL
VIEWS.SCP
description
edit to change codes in the SQL.INI file
used in Scriptor
Views Script
and system catalog views
description
how to execute
VIEWS.SQL
description
ISQL script to add views
Visual Basic
and Q+E Library
version required
W
WAN
in supporting operating environment
warning messages
ignored by PC API
WHAT command
to check versions
WHAT.EXE
description
Word for Windows
version required