HP 3000 Manuals HP 3000 Manuals
Index
A
aborts
and timeouts
account password
in the SQL.INI file
adding
users and DBEnvironments
Advancelink for Windows
and character set conversion
AliasDB file
configuration not necessary
ALLBASE
connection string syntax
ALLBASE.MSG
description
ALLBASE/NET
and listener process
version required
allbase section
in the SQL.INI file
ALLBASE/SQL
data type rules
data types
DBEnvironment creation
embedded statements
features of
purpose of
reserved words
version required
ALLMAST.NET.SYS
and listener process
ALTER PASSWORD
used in SQLBase
ALTER TABLE statement
restrictions on
ANSI character set
converting from ROMAN8 character set
application software
compatible with PC API
description
in client/server environment
testing
when to install
ARPA Services
connection assurance parameters
parameter in connection string syntax
authorities
granting
not grantable through SQLTalk
authorization
identifiers
AUTOEXEC.BAT
changes to
automated installation
and HP Software Vendor
B
batch jobs
setting the number
bind variables
definition
C
C/API
See Gupta C/API
checklist
installation of PC API
C language
and 4GL tools
class name
definition
client
operating environment
client environment
description
client/server environment
description
client software
order of installation
closing databases
from outside PC API
code names
default
codes
and replacement strings
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
compatible application software
listed
configuration of client
sockets, demand load
connect access
controlling
connecting
from application software
connection
and security
between PC and server
multiple from same window
overview
requests
server timeouts
SQL statements related to
to multiple DBEnvironments
to the server
connection assurance parameters
connections
number of
connection string
and passwords
and verification
convertion option
conversion flag
in connection string syntax
converting
character sets
syntax to convert to ANSI character set
cursor stability isolation level
use with PC API
D
database
accessing multiple
database code
explained
in connection string syntax
in installation
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
DBEnvironment
adding
adding new names
controlling access
creating
database code
opening mutiple
DBEnvironment name
adding to SQL.INI file
syntax
DBEUserID
authorization of
definition
DBMS
in a client/server environment
DDL
description
deadlock
non-detectable
DELETE statement
correlation names in
demand load
in configuration of client
dialog box
and open connections
direct logon
explained
disconnecting
from all databases
DISK.ID
description
disk storage requirements
on the client
DISPLOG.EXE
description
DLLs
definition
dual stack
support with HP ARPA Services
dynamic link library
description
E
embedded SQL
unsupported
Error dialog box
definition
errors
and unsupported SQL
during installation
origin of
ERROR.SQL file
description
types of errors
EXECUTE IMMEDIATE
used by PC API
Express Windows
connecting from
version required
extended character sets
conversion from ROMAN8
F
features
of ALLBASE/SQL
FILTER.DLL
description
filter trace
FILTER.DLL description
Forest and Trees
version required
@ functions
SQLBase
G
GRANT CONNECT TO
syntax
granting authorities
syntax
with GRANT statement
GRANT statement
and access
GROUP BY
column numbers
group name
definition
group password
in the SQL.INI file
Gupta C/API
installing the SYSSQL views
server-independent system catalog views
used with SQLBase
H
hardware requirements
disk storage
memory
server
HP 3000
and installation
used with ThinLAN 3000/XL
HP ALLBASE/SQL PC API
description
HP ARPA Services
connection assurance parameters
for NetWare
on the client
parameter in connection string syntax
HP LAN Manager
description
HP Network Services
description
for NetWare
on the client
HP Network Services (NS)
connection assurance parameters
parameter in connection string syntax
HP Software Vendor
used to install PC API
Human Resource Management System
version required
I
icon
for PC API
IMAGE/SQL
description
IN predicate
syntax
installation
as add-on to existing server
automated
of client supporting software
of PC API
on new server
on remaining PC clients
summary of steps
SYSSQL views
INSTALL.DAT
description
INSTALL.EXE
description
ISO 8859/1
and ROMAN8 character set
isolation levels
definition
in SQLBase and ALLBASE/SQL
setting with SQLWindows
ISQL
installing and removing views
used for DBA functions
J
JCONFJOB.NET.SYS
and listener process
jobs
and connections
L
LAN
card required on the client
in supporting operating environment
LANIC card
included with ThinLan 3000/XL
LAN Manager
and compatible networking products
on the client
LAN server
and HP Software Vendor
link
between client and server
listener
description
listener process
and connection
description
loading data
in PartsDBE sample database
logging on
to HP 3000 server
logon
adding a new user
logon string
MPE/iX
syntax
validation
M
maintaining
PC API
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 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
and PowerBuilder
defined for installation
in connection string syntax
MPE XL Server Media Product
product required
MS-DOS
memory required
NETSETUP command
version required
multiple connections
and PowerBuilder
within the same window
multiple DBEnvironments
connecting to
installing views
N
NetIPC
parameter in connection string syntax
verification of configuration
NetUsers file
configuration not necessary
NetWare
parameter in connection string syntax
NetWare Listener
and listener process
starting
NetWare/XL
and HP ThinLAN 3000/XL
and listener process
on the client
network addresses
saving
network configuration
checking
networking
connection assurance parameters
networking software
compatible with LAN Manager
on the client
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
ns
parameter in connection string syntax
NS3000/XL
and listener process
NS Listener
and listener process
starting
numbered bind variables
definition
numeric data types
NWSTART command
and NetWare Listener
NWSTAT command
and NetWare Listener
O
open connections
dialog box
operating environment
client
server
optional software
on the client
on the server
order
for installation of supporting software
outer join
and UNION ALL statement
used in SQLBase and ALLBASE/SQL
owner names
and authorities
P
PartsDBE sample database
creation
passwords
in logon string
syntax in connection string syntax
used in SQLBase
path
in AUTOEXEC.BAT
PC
advantages
PC API
and open connections
description
how it works
performance
improving through the SQL.INI file
placeholder
for passwords
for passwords in SQL.INI file
PowerBuilder
and multiple connections
and SQL.INI file
connecting from
defining mpeuser
sqlca
transaction object
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
version required
Quarterdeck Expanded Memory Manager (QEMM)
as option on the client
queries
from TurboIMAGE/XL
query tools
compatible with PC API
R
read committed isolation level
use with PC API
README
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
remaining PC clients
installing
replacement strings
and SQLWindows
ReportWindows
version required
report writing tools
compatible with PC API
reserved words
ALLBASE/SQL
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
S
Scriptor
starting
SCRIPTOR.EXE
description
scripts
how to execute
used in Scriptor
section header
in SQL.INI file
security
and connection
granting authorities
through logon system
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
purpose of
SessionID
and transactions
part of the logon string
Setup Disk
in the installation process
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 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
SQLAWIN.DLL
description
SQLBase
data type rules
porting applications to ALLBASE/SQL
sqlca
in PowerBuilder
SQL coding
and 4GLs
sqldemo section
in the SQL.INI file
SQL.H
description
SQL.INI file
allbase section
and PowerBuilder
and SQLWindows
changes to
connection string syntax
duplicates
example
identification of routers
maintaining
purpose
SQLSetup script
DBEnvironment creation
SQLTalk
connecting from
SQLTalk Security Menu
and SQLWindows users
SQLTalk/Windows
version required
SqlUser variable
used in SQLWindows
SQLWindows
and SQL differences
and SQLTalk Security Menu
connecting from
Sqlconnect call
SqlDatabase variable
SqlPass variable
SqlUser variable
version required
SQR
version required
steps
installation of PC API
STREAMS command
and listener process
summary
of installation steps
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
for multiple DBEnvironments
how to install
purpose of
system catalog views
comments in
for multiple DBEnvironments
how to install
installing
mapping
purpose of
SQLBase and ALLBASE/SQL
system requirements
for PC API
T
TCP/IP protocol
and NS Listener
product required on the server
required on the client
terminator
adding the ;
testing
application software
ThinLAN 3000/XL
and listener process
product required
timeout
and deadlocks
server connection
timeouts
and abnormal PC aborts
tools
support
transaction object
example
in PowerBuilder
transactions
and connections
translating
data types
translation
CHAR to LONG VARCHAR
TRLT.DLL
description
TurboCONNECT
using
TurboIMAGE/XL
accessing
U
UNION ALL statement
in outer join
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
user password
in the SQL.INI file
users
adding
V
verification
NS Listener
VERIFY.SCP
description
used in Scriptor
Verify Script
how to execute
views
comparison of SQLBase and ALLBASE/SQL
for multiple DBEnvironments
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
virtual terminal capability
for NetWare clients
W
WAN
in supporting operating environment
warning message
for redundant COMMIT statements
WHAT.EXE
description
window
different window, different connection