HP 3000 Manuals HP 3000 Manuals
Index
A
Access Group Menu
access groups
adding
capabilities
changing
configuring
deleting
examining
listing
showing one access group
Access PC
command files
how PC users establish host sessions
interaction with Access Server
interaction with Information Access Server
version number
Access Server
Administrator Utility
and the Database Administrator
components
configuring
DBA tasks
definition of
enhancements
interaction with Access PC
letting users in and out
managing
running as batch job
setting up
software descriptions
Translator Utility
UDC commands
version number
accounts
accessing databases and files across accounts
accessing data sources across accounts
database location
file location
PC users' saved data location
ACLIST
ACUDC.PPCUTIL.HPOFFICE
Add/Delete Table Security by Group screen
Add/Delete Table Security by Table screen
adding
access groups
databases
files
file tables
IMAGE tables
item security
remote HP 3000 systems
tables
table security
users
view tables
view tables with an editor
adding by table
table security
adding, screens
Add Access Group screen
Add File Table screen
Add IMAGE Database screen
Add IMAGE Table screen
Add Item Security screen
Add Remote HP 3000 System screen
Add Table Menu
Add User screen
Add View Table screen
adding view tables with an editor
additions and deletions
order for
Administrator Utility
Configuration Main Menu
definition of
effective management of
Entry screen
going to screens
ground rules for
help
List Screen Names screen
lockword
Main Menu
menu path
monitoring
password of user ADMIN
Password Options screen
Report Main Menu
Report on Configuration screen
Report on System Status screen
running
screen map
security
Synchronization Main screen
System Status Main Menu
user name (ADMIN)
version number
ADMIN Main function label
ADMIN.PPC.SYS
ADMIN UDC
ADMIN, user
AOPTION
ASCII file format
ASSIGN command
average
ROWAVG function
B
basic serial connection files
batch input files for synchronization
example
format of
how to create and process
batch processing
binary file format
binary file output
BRW/IRF file format
C
Cancel Change function label
capabilities for access groups
CASE statement
chained reads
change controlling DBA
access group
file
IMAGE database
changing
access groups
databases
data dictionary passwords
dataset capacities
files
item security
remote HP 3000 systems
tables
table security
users
changing default table security
CHGDICPASS UDC
CHGENVPASS UDC
CLEARAC UDC
COLUMN command
command files
batch processing with
choosing columns
commands
concluding a session
configuring a database
establishing access
executing
ground rules for
in Access PC
initiating from the PC
prompts
requesting a query
requesting a sort
requesting a summary
running through MPE or HDPBATCH
SAMPCMD.PPCUTIL.HPOFFICE, sample
saving a result table
selecting and manipulating tables
setting up
status and error tracking
testing and fine-tuning
command files, commands
ASSIGN
COLUMN
CONFIG_COL
CONFIG_TAB
DEBUG
DEFINE_Q
DEL_TAB
ECHO
EXIT
HELP
INPUT
JOIN_COL
LIST
OUTPUT_TAB
PERFORM_CFG
PERFORM_OUTPUT
PERFORM_Q
PERFORM_SORT
PERFORM_SUM
Q_RESULT
RECORD
RELEASE_TABLE
REMOTE
REN_TAB
RESUME
SEARCH
SECUREINPUT
SELECT
SHOW
SORT
SPEED
SQL
SUMMARY
TABLE
TELL
TIME
USERINFO
XEQ
communication
datacom links
composite keys
compound items
computing new values
concatenation of items
CONDOR
CONFIG_COL command
CONFIG_TAB command
configuration
changing
order for additions and deletions
planning
screens
Configuration Main Menu
configured tables
versus saved tables
Configure View Table Editor screen
configuring
access groups
controlling DBA
databases
data sources
files
file tables
for tutorials
IMAGE tables
item security
remote HP 3000 systems
security
sequence for
tables
table security
users
view tables
conversion
of file data
of IMAGE data
copying
configured tables
count
ROWCOUNT function
D
Database Administrator (DBA)
database chains
optimizing
Database Information screen
databases
accessing across accounts
adding
changing
combining information
configuring
controlled by DBA
data dictionary databases
deleting
examining
host databases
listing
open mode
passwords
passwords, ground rules for changing
PC databases
releasing
remote databases
security
showing one database
database security
datacom links
to remote HP 3000
data conversion
data dictionary
changing
changing passwords
defining entries in
Dictionary/3000
limits
maintaining
optimizing database chains
passwords
synchronizing definitions
utilities supported
datasets
changing dataset capacities
data sources
accessing across accounts
configuring
security
Data Sources Menu
DBA capabilities
assigning
deleting users
removing
dBASE
DEBUG command
decimal conversion
defaults
opening files
default user
DEFINE_Q command
deleting
access groups
database definitions
files
item security
remote HP 3000 system
saved tables
saved tables by mistake
tables
table security
users
deletions and additions
order for
DEL_TAB command
Dictionary/3000 definitions
translating
Dictionary/3000 Information screen
DIF file format
DISABLEAC UDC
disabling Access Server
Done function label
E
ECHO command
ECM
editor
view tables
ENABLEAC UDC
enabling Access Server
enhancements to Access Server
Entry screen
for the Administrator Utility
for the Translator Utility
errors
tracking command file errors
tracking server process errors
error spoolfiles
HDSPERR and HDSPNSE
examining
access groups
databases
files
item security
remote HP 3000 systems
synchronization errors
system status
tables
table security
users
Executive Card Manager (ECM)
EXIT command
Exit Help function label
exiting
Administrator Utility
Translator Utility
exiting/Host Batch Facility
F
file
deleting
File Data Conversion screen
file equations
options
file formats
for saving result tables
files
accessing across accounts
adding
changing
configuring
deleting
examining
hold files
host files
listing
lockwords
releasing
:remote files
remote files
SAMPCMD.PPCUTIL.HPOFFICE
showing one file
Files Menu
file tables
adding
changing
copying or renaming
data conversion
examining
listing
selecting items
synchronizing definitions
FOPTION
function labels
G
GONOGO UDC
Go To Page function label
Go to screen field
H
HDPBATCH
HDPDIC, database
configuration rules
description of
schema for
size considerations
structure of
HDPENV, database
configuration rules
description of
schema for
size considerations
structure of
HDSPERR, error spoolfile
help
calling HP
Help function label
HELP command
Help function label
Host Batch Facility
status and error tracking
Host Batch Facility, commands
ASSIGN
COLUMN
CONFIG_COL
CONFIG_TAB
DEBUG
DEFINE_Q
DEL_TAB
ECHO
EXIT
HELP
INPUT
JOIN_COL
LIST
OUTPUT_TAB
PERFORM_CFG
PERFORM_OUTPUT
PERFORM_Q
PERFORM_SORT
PERFORM_SUM
Q_RESULT
RECORD
RELEASE_TABLE
REMOTE
REN_TAB
RESUME
SEARCH
SECUREINPUT
SELECT
SHOW
SORT
SPEED
SQL
SUMMARY
TABLE
TELL
TIME
USERINFO
XEQ
Host Data Server Process (HDSP)
host/PC
communication methods
how PC users establish host sessions
interaction
HOSTVERIFY UDC
HP 3000/logging on
I
IAFILE
IMAGE
security
IMAGE/3000
security
IMAGE Database Menu
IMAGE databases
deleting
IMAGE Data Conversion screen
IMAGE datasets
IMAGE Sequential Access Method
IMSAM
IMAGE tables
accessing large
adding
changing
copying or renaming
data conversion
examining
listing
security
selecting items
synchronizing definitions
IMSAM
adding keys
changing keys
composite keys
IMAGE Sequential Access Method
keyed reads
IMSAM keys
Information Access
data dictionary
definition of
Information Access PC
Information Access Server
interaction with Access PC
Information Access SQL/UX
Information Access SQL/XL
INPUT command
installing
Information Access data dictionary
ISO-7
character sets
support
Item Clause
items
breaking out substrings (SUB function)
compound items
computing new values
concatenating
data conversion of file items
data conversion of IMAGE items
defining a sub-item
public items
qualifying item names
renaming
reserved words as item names
selecting for file tables
selecting for IMAGE tables
selecting items for file tables
showing their characteristics
specifying for view tables
substituting data (CASE statement)
item security
adding
adding, things to know about
changing
deleting
examining
showing
Item Security Menu
J
JOB-STATUS, IMAGE dataset
table
JOIN_COL command
JOIN operation
four tables
three tables
two tables
JOIN operations
examples
JSLOG, log file
JSPURGE
syntax for
JSPURGE UDC
K
keyed reads
IMSAM
KSAM
KSAM
keyed reads
KSAM files
KSAM key items
L
limits
active users
data dictionary size
saved table limit for users
sector limit for users
table size
LIST command
listing, screens
List Access Groups screen
List Active Users screen
List All Tables screen
List Files screen
List File Tables screen
List IMAGE Databases screen
List IMAGE Tables screen
List Remote HP 3000 Systems screen
List Saved Tables screen
List Screen Names screen
List Tables Menu
List Users screen
List View Tables screen
local tables
lockword
Administrator Utility
lockwords
file lockwords
files
lockword visibility
log file
printing deleted status information
printing in the Translator Utility
logging on
logon for users using MPE interface programs
logging on to the HP 3000
logon UDCs
Lotus 1-2-3
M
Main Menu
manuals, other
map for Administrator Utility screens
MATCH operator
maximum
ROWMAX function
maximum active users
maximum table size
minimum
ROWMIN function
MPE
how PC users establish sessions
interface
priority queue
security
version number
N
networking
Next Page function label
O
OMNIDEX Information Management System
opening files
defaults
order for additions and deletions
order of items
in file tables
in IMAGE tables
OUTPUT_TAB command
P
PARMHELP UDC
Password Options screen
passwords
Administrator Utility (ADMIN) password
changing data dictionary passwords
database passwords
data dictionary passwords
default user (no password)
password visibility
user passwords
PC
batch facility
PCCI.PUB.SYS
PC/host
interaction
PC users
and the host HP 3000
capabilities
keeping users out of Access Server
letting users into Access Server
security of data
PC users/logging on the the HP 3000
performance tuning
PERFORM_CFG command
PERFORM_OUTPUT command
PERFORM_Q command
PERFORM_SORT command
PERFORM_SUM command
planning
Access Server configuration
Previous Page function label
primary DBA
capabilities
Print function label
printouts
Print function label
redirecting
reports
priority queue
PRODUCTION operation
public items
public tables
Q
Q_RESULT command
R
R
base
RECORD command
records
computing new values
maximum record length
selecting
sorting
redirecting reports and printouts
RELEASE_TABLE command
releasing
databases
files
remote access
definition of
REMOTE command
Remote HP 3000 System Menu
remote HP 3000 systems
adding
changing
configuring
deleting
examining
listing
showing one system
translating from remote Dictionary/3000
remote tables
renaming
configured tables
items
users
REN_TAB command
Report Main Menu
Report on Configuration screen
Report on System Status screen
reports
options on Report on Configuration screen
options on Report on System Status screen
printing
redirecting
reserved words
item names
table names
restoring saved tables from a backup tape
result tables
limits on table size
saving on the host HP 3000
RESUME command
ROW functions
running
Administrator Utility
Translator Utility
S
SAMPCMD.PPCUTIL.HPOFFICE
SAMPCMD.PPCUTIL.HPOFFICE, sample command file
Sample Values Security
saved tables
deleting
deleting by mistake
how they are saved
limit for users
limits on table size
listing
maximum number per user
releasing to other users
restoring from a backup tape
saving result tables on the host
showing one user's
T-files and saved table definitions
versus configured tables
schema
for HDPDIC database
for HDPENV database
screens
going directly to a screen
listing all on-line
menu path
screen map
SEARCH command
secondary DBA
capabilities
secondary DBA capabilities
assigning
sectors
limit for users
SECUREINPUT command
security
accessing databases across accounts
accessing data sources across accounts
accessing files across accounts
access to data
Administrator Utility (ADMIN) password
configuring
database security
data dictionary passwords
defining HP 3000 with different logons
during configuration changing
file security
item security
letting users in and out
PC users' data security
remote database
remote files
sample values
securing the Administrator Utility
table security
user passwords
Where Clause
Security Menu
SELECT command
selecting records
self-describing (SD) file format
serial reads
session model
capturing for command files
sessions
how PC users establish
SHOW command
showing, screens
Show Access Group screen
Show File screen
Show File Table screen
Show IMAGE Database screen
Show IMAGE Table screen
Show Item Security screen
Show Items screen, for file tables
Show Items screen, IMAGE and view tables
Show Remote HP 3000 System screen
Show Table Security by Group screen
Show Table Security by Table screen
Show User's Saved Tables screen
Show View Table screen
showing table security by group
showing table security by table
Show User screen
SITECHARSET UDC
Sort Clause
SORT command
sorting records
SPEED command
spoolfiles
HDSPERR and HDSPNSE
SQL command
SQL commmand
standard deviation
ROWSTD function
status
system status
streaming jobs
SUB function
in the Where Clause
sub-items
sum
ROWSUM function
SUMMARY command
Symphony
synchronizing, screens
Synchronization Detail screen
Synchronization Main screen
Synchronization Summary screen
synchronizing table definitions
avoiding problems
batch input files
checking for errors
checking interactively
correcting problems
examining errors
file tables
IMAGE tables
processing batch input files
selecting tables to check
view tables
when to check
why problems arise
syntax
view tables
system status
examining
System Status Main Menu
T
TABLE command
Table Menu
tables
accessible to assigned users
adding
adding file tables
adding IMAGE tables
adding view tables
changing
changing file tables
changing IMAGE tables
changing maximum size
changing view tables
checking definitions interactively
configuring
copying
deleting
examining
file tables
IMAGE tables
large, handling
limits on table size
listing configured tables
listing saved tables
local tables
public tables
releasing saved tables
remote tables
renaming
renaming if used in Using Clause
reserved words as table names
saved tables
security
showing one configured table
showing one user's saved tables
synchronizing definitions
view tables
view table syntax
table security
adding
adding by group
adding by table
changing
changing default
deleting
deleting by group
deleting by table
examining
releasing saved tables
showing
Table Security Menu
TELL command
T-files and saved table definitions
TIME command
totaling
ROWSUM function
Translator Utility
Database Information screen
definition of
Dictionary/3000 Information screen
Entry screen
limitations of
log file TRANSLOG
printing the log file
running
when to use
TRANSLOG log file
TRANS.PPC.SYS
TRANS UDC
tuning
performance
TurboIMAGE
tutorials
configuring for
TUTORIAL UDC
U
UDC
logon
UDC commands
ADMIN
CHGDICPASS
CHGENVPASS
CLEARAC
DISABLEAC
ENABLEAC
GONOGO
HOSTVERIFY
JSPURGE
PARMHELP
SITECHARSET
TRANS
TUTORIAL
user
OPERATOR
user-defined commands
USERINFO command
User Menu
user name
Access Server (ADMIN)
user OPERATOR
users
adding
assigning secondary DBA capabilities
capabilities
changing
changing maximum active users
configuring
default user (no name or password)
deleting
examining
listing
listing currently active users
lowering priority queue
maximum active users
maximum MPE sectors
MPE priority
passwords
privileged
renaming
showing one user
user name
Using Clause
utilities supported
V
version numbers
view table editor
view tables
adding
changing
configuring
copying or renaming
examining
examples, advanced
examples, simple
listing
specifying items
synchronizing definitions
syntax for
view table editor
W
Where Clause
X
XEQ command