IMAGE/1000 Data Base
Management System
Quick Reference Guide
HEWLETT
PACKARD
HEWLETT-PACKARD COMPANY
Data Systems Division
11000 Wolf* Road
Cupertino, California 95014
Library Index No.
2 DMGMT.345. 92069-90005
MANUAL PART NO.
Printed In U.S.A.
IMAGE/1000 Data Base
Management System
Quick Reference Guide
HEWLETT
PACKARD
HEWLETT-PACKARD COMPANV
Data Systems Division Update 1 July 1981
11000 Wolfe Road MANUAL PART NO. 92069-90005
Cupertino, California 95014 Printed in U.S.A. March 1980
PRINTING HISTORY
New editions are complete revisions of the manual. Update packages contain
replacement pages or write-in instructions to be merged into the manual by
the customer. Manuals will be reprinted as necessary to incorporate all prior
updates. A reprinted manual is identical in content (but not in appearance) to
the previous edition with all updates incorporated. No information is
incorporated into a reprinting unless it appears as a prior update. The edition
does not change.
First Edition March 1980 (Software Revision Code 2001)
Update 1 July 1981 (Software Revision Code 2126)
NOTICE
The information contained in this document is subject to change
without notice.
HEWLETT-PACKARD MAKES NO WARRANTY OF ANY KIND
WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT
LIMITED TO, THE IMPLIED WARRANTIES OF
MERCHANTABILITY AND FITNESS FOR A PARTICULAR
PURPOSE. Hewlett-Packard shall not be liable for errors contained
herein or for incidental or consequential damages in connection with
the furnishing, performance or use of this material.
Hewlett-Packard assumes no responsibility for the use or reliability of
its software on equipment that is not furnished by Hewlett-Packard.
This document contains priority information which is protected by
copyright. All rights are reserved. No part of this document may be
photocopied, reproduced or translated to another program language
without the prior written consent of Hewlett-Packard Company.
ii
Copyright © 1980 by HEWLETT-PACKARD COMPANY
CONVENTIONS USED IN THIS MANUAL
Notation
Description
[ ] An element inside brackets is optional.
{ } When several elements are stacked within
braces, the user must select one of these
elements.
Example:
user must select A, B, or C.
uppercase Uppercase letters mean that the information
should be presented exactly as shown.
fowercase 1 Lowercase denotes a parameter which must
be replaced by a user-supplied variable.
All item names, data set names and level
code words consist of one to six ASCII char-
acters restricted as follows.
• only printable characters, ! through
• not allowed are: plus (+), minus (-), colon
(:), comma (,), semicolon (;), left and right
parentheses ( () ), period (.), equal sign
(=), double quotes ("). or underscore
(_)■
• the first character must not be blank
(space), or a number.
• embedded spaces are not allowed
file names All references to file names conform to RTE
FMP conventions. Any file name referred to as
an FMP namr consists of a file namr or a
logical unit number. Any file name referred to
as an FMP file namr consists only of a file
namr; a logical unit number is not permitted.
In an FMP file namr, negative lus are not per-
mitted; only cartridge reference numbers can
be used.
Update 1
fog lu The log lu is LU 1 if the terminal being used is
a Session terminal, the terminal lu if the termi-
nal is a Multi-Terminal Monitor terminal and
LU 1 if the terminal is neither a Session nor
MTM terminal.
An underlined parameter means that you will
be prompted for it if not passed in the original
runstring.
iv
Section I Page
DEFINITIONS AND CAPACITY INFORMATION
Section II Page
CREATING THE DATA BASE
Control Command 2-1
Data Base Privacy Levels 2-2
Item Definition 2-2
Set Definition 2-3
DBDS 2-4
DBBLD 2-5
Section III Page
QUERYING THE DATA BASE
Using QUERY 3-1
Terminating QUERY 3-2
Define Commands 3-2
Retrieving Data Base Entries 3-2
Modifying the Data Base 3-4
Generating Reports 3-5
Report Formatting 3-5
Report Editing 3-8
Storing and Maintaining Procedures 3-9
Utility Commands 3-10
Section IV Page
HOST LANGUAGE ACCESS— FORTRAN,
ASSEMBLY, BASIC
Host Language Access 4-1
Parameter Definitions 4-1
IMAGE Subroutines 4-4
Section V Page
MAINTAINING THE DATA BASE
Utility Programs 5-1
Section VI Page
ERROR MESSAGES
IMAGE Numbered Error Messages 6-1
DBDS Error Messages 6-6
RECOV Error Messages 6-14
DBS PA Error Messages 6-14
QUERY Error Messages 6-16
IMAGE Error Codes and QUERY Messages 6-34
v
DEFINITIONS AND CAPACITY INFORMATION
Compound Data Kern
Named group of identically defined, adjacent items within the
same data entry.
Capacity: 255 elements, each of which may contain up to
255 bytes with the lim itation that the d ata entry can
only contain a total of 4096 bytes.
Data Base
One or more data sets which have some logical relationship
to one another.
Capacity: 50 data sets.
255 unique data item names (reusable in different
data sets).
15 level words.
Data Base Name
1 to 6 ASCII characters restricted as follows:
• only printable characters, ! through
• not allowed are: plus (+), minus -), colon (:), comma (,),
period (.), semicolon (;), left and right parentheses ( () ),
double quotes ("), equal sign (=), and underscore ( — ).
• first character must not be blank (space) or a number
• embedded blanks not allowed
Data Entry
See Entry
Data Item
See Item
Data Item type specifications for the item part of a data
schema:
11
Denotes an integer number in the range of -32768 to
+32767.
R2
Denotes a real number in the range of ±1.70 x 10* to
±1.47 x 10- 39
X integer
Denotes an ASCII string of character length n, where n
must be an even number not exceeding 255.
Update 1
1-1
Data Item Name
See Item Name
Data Set
See Set
Data Set Namr
Same convention as Data Base Name.
Edit Mask (see QUERYING THE DATA BASE, REPORT
EDITING, for format).
Capacity: Alphanumeric = 1 to 132 characters
Numeric = 1 to 20 characters
Entry
An ordered set of data items.
Capacity: 4096 bytes (media record plus data record).
127 unrepeated data item names.
FIND Procedure
Capacity: 50 logical relationships.
FMP File Namr
File namr. Must use cartridge reference number — negative
lus are not permitted.
FMP Namr
File namr or logical unit number.
Item
Smallest accessible data element in a data base — may be
expressed as numbers or ASCII character strings. Numeric
values are integers (one 16-bit word long) or reals (two 16-bit
words long).
Item Name
Same convention as Data Base Name.
Level Word
Code word corresponding to each data base privacy level.
Convention is the same as Data Base Name.
1-2
Path Count
Integer from 0 to 16 indicating key data items and showing
how many paths exist from the master data set to detail data
sets through the key item link.
Capacity: 16 data paths from each master data set and to
each detail data set.
QUERY Command
Capacity: 698 characters.
Security Code
Decimal integer 1 through 32767.
Set
Collection of data entries where each entry contains values
for the same data items.
Capacity: 2 31 - 1 (RTE-IVB) or 2 15 - 1 (RTE-L or RTE-XL) data |
entries as long as the capacity of the disc car-
tridge is not exceeded.
Update 1
1-3
CREATING THE DATA BASE
SCHEMA DEFINITIONS
Control Command: Optional. Specifies control options to
be used by DBDS while processing
the data base schema. Defaults are
LIST, ROOT, SET, NOTABLE, and
ERRORS=100.
Format: $CONTROL: [ L I ST ,NOL 1ST , ] [ ROOT ,
N0R00T , ] [ SET , NOSET , ] [ TABLE ,
NOTABLE , ] [ERRORS'nnn]
[FIELD;]
LIST
Lists each source record on the list
device.
NOLI ST Suppresses the LIST option and, if an error
occurs, prints the offending source record
along with the error message.
ROOT
A root file is createdif no errors are de-
tected in the schema.
NOROOT No root file will be created. The schema is
merely checked for errors.
SET
Creates data sets if no errors are detected
in the schema.
NO SET No data sets will be created.
TABLE A table of summary information is printed
about the data sets after the schema has
been scanned by DBDS (if no errors were
detected).
NOTABLE Suppresses the printing of the summary
table.
2-1
ERRORS- nnn Sets the maximum number of errors al-
lowed (0<nnn<999). If this number is
reached during processing, the schema
processor prints an error message and
terminates.
FIELD A table is printed for each data set de-
scribing the start and end of each data
item if no errors are detected in the
schema.
Schema Structure
BEGIN DATA BASE: data base name;
LEVELS : [level part]
ITEMS: item part
SETS: aet port
END.
Data Base Privacy Levels:
Defined by a level word and level numbers (integers 1 to 15)
in any order.
type 11 = integer from -32768 to +32767.
R2 = real from ±1.70 x 10 39 to
±1.47 x 10- 39 .
Xinteger = ASCII string of character
length n, where n must be an
even number not exceeding
255.
read level integer from 1 to 15.
write level integer from 1 to 15; must be equal to or
greater than the read level.
Set:
Names the various data sets within the data base, indicates
which data items belong to each set and links master data
sets to detail data sets by defining key items. Items are stored
in the order listed.
Formats:
Master Data Sets:
NAME: set name, type;
ENTRY:
item name [(path count)],
item name [(path count)];
CAPACITY: capacity;
Detail Data Sets:
NAME : aetname, DIETAIL]
ENTRY: item name [( 1 ink )[( sort item])],
item name [( 1 ink )[ (sort item])],
CAPACITY: capaci ty;
Update 1
2-3
type A[UTOMATIC] or M[ANUAL]
path count integer in the range of 0 to 16, inclusive
capacity integer 1 to 2 3 ' - 1 for RTE-IVB or 1 to
32,767 for RTE-L or RTE-XL.
link name of the master data set linked to the
detail set item
sort i tern item whose value is used to order entries in
the chain
DBDS
Processes the data base schema.
Run Format:
:RU,DBDS[ .input .list ,
opt ion]
input FMP file namr of file containing data base
schema definition or the device lu where schema
exists. Default is scheduling lu.
li st FMP namr where the listing is written. Default is
LU 6.
option Characters PU if existing data sets are to be
purged before new ones are created.
Wore; Blanks may be inserted anywhere within the schema
except within symbolic names, reserved words, or
other syntactical entities.
2-4
Updatel
DBBLD
Loads actual data item values into a data base structure and,
optionally, confirms that they are presented in the proper
format. Integer items occupy a six column field and real
numbers a thirteen column field. Character type data item
values appear in a field exactly as long as their defined
length.
Run Format: : RU, DBBLD [ , i nput ,1 i st ,
options]
i nput
FMP namr of data. Default is scheduling lu.
list
FMP namr where the list will be written.
Default is LtJ 6
opt i ons :
(entered in any order and separated by com-
mas)
ADD
Input file error free entries are added to data
base.
ERRHLT
Data processing stops when an error is
detected.
NOLIST
Input file data is not listed to output device.
n
Integer from 1 to 512 which specifies line
length. Default is 72.
Input File Format:
data base namr, level word;
$SET:set name 1
data for set name 1
$SET:set
data for
SEND
name n
set name n
2-5
QUERYING THE DATA BASE
Using QUERY
Run
:RU,QUERYC .input ,list ,logn
Format
ECHO , node]
input
The FMP namr from which the input will come.
Default is LU 1 or user's terminal in an MTM
environment.
list
FMP namr where the list will be written. Default list
is interactive input device or LU 6 if the input is a
file or not an interactive device. If the list file does
not already exist, QUERY will create it.
log FMP namr which specifies the logging device or
file. ECHO lists each command to the log device
or file before it is executed. Default log unit is the
interactive input device or LU 1 when the input is
a file or not an interactive device. QUERY creates
the log file if it does not exist.
node User's node number. Allows the user to run
QUERY remotely using the DS/1000 REMAT pro-
gram. Input device must be either interactive or
an FMP file namr local to the data base. Any files |
and data bases referenced by QUERY running
remotely must exist on the node local to the
QUERY program. Before requesting a remote
copy of QUERY, the REMAT switch (SW) com-
mand must be executed with the source node as
the node at which QUERY is to be run and the
destination node as the user's node. The remote
copy of QUERY can be invoked using either the
RU or RW REMAT command.
Interactive input QUERY READY
response: NEXT?
Update 1
3-1
Batch mode Prompt is suppressed. Input is expected
response: in the order it would be entered
interactively.
Terminating QUERY
EXIT;
The EXIT; command, typed in response to NEXT?, terminates
QUERY.
Define Commands
Data base
definition: DATA-BASE'data base namr;
Select file
definition: SELECT-F ILE-f i le namr;
When input is interactive, QUERY will prompt for level code
word (LEVEL-?) and open mode (OPEN MODE - ?). Re-
sponses should be the appropriate level word (defined by
LEVELS: when the data base was created) and open mode
(1 = read/write, shared access, 3 = read/write, exclusive
access, 8 = read only, shared access).
Retrieving Data Base Entries
Find
FIND retrieve
procedure END;
Command
or
Format:
FIND NAME-p
rocedure name;
procedure FMP file namr of a file stored on disc don-
name taining a FIND command which uses a
retrieve procedure.
retrieve Specifies a relation between a data item and
procedure data item value. QUERY will find the values
which fit the stated relation and store the
record addresses of those data entries.
3-2
Retrieve Procedure Format:
[set name.] item name operator
"value"
set name Name of data set containing the item. Op-
tional when the item is defined in only one
set, or when the data set is specified ear-
lier in the FIND command.
item name Name of the item. For a compound item,
only the first element is used.
operator Relational operator indicating the type of
comparison to be made.
Relational
Operator Meaning
I E equals
ISNOT .
,. lc . is not equal to
1 ML
I LT is less than
INLT is not less than
IGT is greater than
INGT is not greater than
value Value to be compared with each of the
values of the data items named in the rela-
tionship. Value must be enclosed in
quotes and appropriate to the data item
type.
3-3
Modifying the Data Base
(Formats below)
UPDATE A[DD]:
Adds a data entry to a detail or manual master data set.
The user will be prompted with the name of each item in
the set. Item values to be added should be enclosed in
quotes and entered after each item name.
UPDATE D[ELETE]:
Deletes all records selected by the FIND command.
UPDATE R[EPLACE]:
Replaces the value of a data item with another value in all
data entries in the current select file. The user will be
prompted with
ITEM?
which must be followed by an item name, equal sign, and
item value enclosed in quotes — item name="item value"
To Add, Delete, or Replace Data:
UPDATE NAME«procedure name;
(if procedure file is stored on disc)
or
Add Data UPDATE ACDDl.data set name;
Format: (to add data)
or
Delete Data UPDATE DCELETE3;
Format: (to delete data)
or
Replace Data UPDATE RCEPL ACE];
Format: (to replace data)
data aet name Name of data set to which entry will
be added.
procedure name Namr of the UPDATE A,D, or R com-
mand stored as a procedure on the
disc.
Note: Path items cannot be modified.
3-4
Generating Reports
Report
REPORT ALL [.character];
Command
or
"Ul INcLl.
RtruBi nni it proceaure name;
or
REPORT [.character];
body
END;
character Any ASCII printing character — determines
the printing of certain optional information.
procedure name FMP file namr of a file containing RE-
PORT commands stored as a proce-
dure in a procedure file.
body Header, detail, edit, sort, group and
total statements.
Report Formatting
Format Aid Parameters:
SPACE space- Skips lines on report page before or
control after printing any line. A[number]
causes that number of lines to be
spaced after the line, while Bfnumber]
spaces that number of lines before a
line. The number parameter is an
integer from 1 to 5.
SKIP skip- Skips to a new page before or after
control printing a detail, group or total line.
Parameter A will page after a line
while B will cause the page before a
line.
Print position Integer from 1 to 132 defining the
ending column position of a charac-
ter string or data item value in a
report.
3-5
Edit EZ specified will suppress any
leading zeroes in numeric data item
values.
Enumber (where number is an inte-
ger from 0 to 9) corresponds to the
number of an edit statement that is
defined after the statement contain-
ing the edit parameter.
Example:
To page before and space after the header line "PAGE",
ending in column 35:
H1 ."PAGE" ,35, SKIP B, SPACE A2
Report Statements:
Header Statement Format:
Hnumber , data type, print
posi t i on C , SPACE space-control];
number Integer from 1 to 5 specifying on which
header line (out of five possible lines) the
information is to appear. Header information
in a header statement labeled H1 appears in
the first line, H2 appears in the second
line, etc
data type Either an ASCII character string bracketed
by quotes or the word PAGENO.
Detail Statement Format:
DCn],data type, print
poaitionf. , SPACE space-
control ][, SK I P skip-control]
[.edit];
n Integer from 1 to 9
data type ASCII character string bracketed by quotes
or the name of a data item.
3-6
Edit Statement Format:
Enumber ,"edit mask";
number Integer from 0 to 9 identifying the edit
statement. No two edit masks may be iden-
tified by the same integer.
edit mask 1 to 20 numeric edit characters or 1 to 132
alphanumeric edit characters, bracketed by
quotes. See REPORT EDITING for complete
edit mask information.
Sort Statement Format:
S[ level ] ,doto Item name;
level Integer from 1 to 5.
data item Name of data item contained in the data
name entries selected by the FIND command.
Group Statement Format:
G 1 eve 1 , da t a type, print
posi t i on [, SPACE space
-cont rol ]
t .SKIP skip-control 1 C
.editl;
level Integer from 1 to 5, corresponding to the
level appearing in a sort statement.
data type Either an ASCII character string bracketed
by quotes, or the name of a data item.
Total Statement Format:
Tlevel.data type.p
rint
position! .SPACE
space-
control ] [ .SKIP skip-
control ] I .edit ]
, AVERAGE
.COUNT
.ADD
3-7
level
Integer from 1 to 5 corresponding to the
level appearing in a sort statement or the
letter F.
data type Either an ASCII character string bracketed
by quotes or the name of a data item.
ADD Instructs QUERY to add the values specified
in data type. Accumulators are set up for
each control level and, if the user specifies F
as the level, for the final level. Capacity is 10
digits for integers and reals, 20 digits for
ASCII Numeric Strings.
AVERAGE Instructs QUERY to average the values of
the data item specified in data type. Charac-
ter data itmes must not exceed 20
characters.
COUNT Instructs QUERY to print the number of data
item values printed after the last and before
the current control break.
Report Editing
Alphanumeric Editing
Example: Data Item
Value Edit Mask Printed Result
ABCD "X-X-X-X" A-B-C-D
Edit mask consists of X's as place holders with ASCII charac-
ters inserted. QUERY reads the mask from right to left, so
fewer X's in the mask than characters in the data cause the
leftmost data item characters to remain unprinted. More X's in
the mask than characters in the data cause asterisks to be
printed in the extra columns.
3-8
Update 1
Numeric Editing:
Edit mask consists of place holders (9,Z,*,$), sign characters
(CR,-), and inserted ASCII characters. Each place holder is
replaced by a decimal digit from the data item value in the
corresponding position of the output field.
Explanation of place holders:
9 Place holder. Does the same thing as an X in an
Alphanumeric Edit.
Z Zero suppression place holder. If a zero appears to
the left of the leftmost significant digit, QUERY in-
serts a blank in that position and all zeroes to its left
are also replaced by blanks.
* Asterisk place holder. Leading zeroes are re-
placed with asterisks.
* Dollar sign place holder. The first zero to the left of
the leftmost significant digit is replaced with a dol-
lar sign. All zeroes to its left are replaced with
blanks.
CR Sign character. Always appears in the two right-
most positions of the edit mask. If the data item
value is positive, QUERY prints two blank charac-
ters in place of the CR.
Sign character like CR. If the data item value is
negative, QUERY prints the minus sign (-) in the
rightmost position of the output field. If positive,
QUERY prints a blank in place of the minus sign.
When an overflow occurs in totalling, the field is filled with
asterisks. i
Storing and Maintaining Procedures
Create a procedure: CREATE NAME-procedure namr;
Display a procedure: DISPLAY NAME-procedure namr;
Delete a procedure: DESTROY NAME-procedure namr;
Execute a program (can be used to modify a
procedure — default is EDITR):
EXECUTE [ ^program name ] ;
Note: Real numbers cannot be edited.
Update 1 3-9
Utility Commands
XEQ Command Format: XEQ-file name;
file name FMP file namr of an ASCII file containing
commands and parameters.
FORM Command Format: FORM;
HELP Command Format:
HELP! .command] [ .FUNCTION]
[ .SYNTAX] [ , OPERANDS] ;
command Either: CREATE, DATA-BASE DESTROY,
DISPLAY, EXECUTE, EXIT, FIND, FORM,
HELP, LIST, REPORT, SELECT-FILE,
UPDATE, or XEQ.
LIST Command Format: L I ST« list devi ce ;
list device FMP namr where the list is to be written.
3-10
HOST LANGUAGE ACCESS— FORTRAN,
ASSEMBLY, BASIC
Host Language Access
Calling an IMAGE Subroutine:
FORTRAN CALL name (parameter,
parameter , . . . .parameter)
Assembly JSB name
DEF .+(n+1)
DEF parml
DEF parm2
DEF parmn
BASIC lineno CALL name(paramet er .
parameter , . . . .parameter)
Parameter Definitions:
IBASE
(FORTRAN and Assembly Language)
Integer array containing the data base FMP file namr. The
first word is either a DS/1 000 node number (if accessing a
data base at a remote site), or two ASCII blanks. Words
two through the end of the array contain at least the data
base and the security code, separated by a colon and
terminated by a blank or semi-colon.
Example: DIMENSION IBASEC7)
DATA I BASE / 1 01 ,2HQA , 2HDB,
2H:1 ,2H00,2H:4,2H3;/
(BASIC)
One-dimensional string array containing two ASCII blanks
followed by the data base namr. The first two bytes cannot
contain a DS/1 000 node number, but must be blank.
4-1
ILEVL
Gives the user's level code word.
(FORTRAN and Assembly Language)
Integer array of three words, blank-filled if necessary.
(BASIC)
One-dimensional string array.
ID
Supplies a data set name for data base manipulation
calls. For DBINF calls, ID may also be a data item name.
(FORTRAN and Assembly Language)
Integer array of three words, blank-filled if necessary. May
also contain an integer which is a data set or data item
number.
(BASIC)
One-dimensional string array.
IMODE
Passes information to the subroutine via an integer varia-
ble. It may be an access mode parameter, an information
series indicator or a read option. For calls which do not
have multiple modes, IMODE must contain the value 1.
ISTAT
Returns status information to the user. If the operation
requested was unsuccessful, a non-zero code is returned
in the first word or element of the array. If the operation is
successful, the first word or element of the ISTAT array is
set to zero. Depending on the operation, additional infor-
mation may be passed via the remainder of the array.
(FORTRAN and Assembly Language)
Ten words long.
(BASIC)
Variable length, ranging from one to six elements.
IBUF
(FORTRAN and Assembly Language only)
Buffer used to pass information to and from the user, the
size being dependent on the information to be passed.
4-2
VALUE-LIST
(Basic only)
List of one or more variables separated by commas and
corresponding in type and number to the data items given
in NAME-LIST. The variables in VALUE-LIST are the val-
ues either retrieved from or added to the data-base as
values for those items named in the NAME-LIST.
Format:
DIM 1*112]
DATA "ASSY, #, FAILU-
RE AD 1$
CALL DBGETCQ$ , S$ ,M7 , S[ 1 ] ,A$,
I*,Y*,F1)
ITEM
Contains the name of the data item on which a search is to
be made.
(FORTRAN and Assembly Language)
Integer array of at least three words or, alternately, an
integer variable containing a data item number.
(BASIC)
One-dimensional string array.
IARG
Real or integer variable, integer array, one-dimensional
string array containing a value given to a key item, or a
doubleword integer variable containing a relative record
number.
LIST
(FORTRAN and Assembly Language only)
Integer array containing a list of data item names or num-
bers. A list of data item names is a set of data item names
separated by commas and terminated by a blank or
semi-colon. A list of data item numbers is an integer N
followed by a set of N data item numbers, where N is from
1 to the number of items in the data set being accessed.
4-3
Format: DIMENSION LISTO)
DATA LIST/2HAS,2HSY,2H#, ,
2HPA , 2HRT , 2H* , ,2HEM ,
2HP#,2H; /
NAME-LIST
(BASIC only)
Used in retrieval, add, and update operations to specify
the data items that will be affected. NAME-LIST is a one-
dimensional string array containing a list of one or more
data item names, separated by commas and terminated
by a blank or semi-colon. No more than ten names may
appear in a name-list, except in a DBGET operation which
can contain only nine.
Format: DIM G$[41 ]
DATA "ASSY* , DATE , PART* ,
F AI LCD, REFDES ,PNTS ,
EMP* ; "READ G$
IMAGE Subroutines
DBCLS
Format: DBCLSt ibase , id , imode , is ta t )
Terminates access to a data base or closes a data set.
imode values: 1 — close the data base
2 — close a data set
DBDEL
Format: DBDELC ibase , id , imode , is tat )
Deletes the current entry from a data set. The data base must
be open in mode 1 or 3 and the level of access granted at
open time must allow deleting from the data set. If open in
mode 1, the data base must be locked. Imode must contain
the value 1 .
4-4
DBFND
Format: DBFND< i base , i d , imode , i stat ,
i t em , iarg)
Locates the master set entry that matches the specified key
item value and sets up pointers to the detail data set chain in
preparation for chained access to the data entries which are
members of the chain. Imode must contain the value 1.
DBGET
(FORTRAN and Assembly Language)
Format: DBGEK ibaae , id , i mode , i 5 to t ,
1 i st , i buf , iarg)
(BASIC)
Format: DBGETC i base , id , imode , i stat ,
iarg , name- 1 ist,value-list)
Provides seven different methods for reading the data items
of a specified entry.
imode values: 1 — reread current record
2 — forward serial read
3 — backward serial read
4 — directed read by record number
5 — forward chain read
6 — backward chain read
7 — directed read by key item value
DBINF
Format: DB I NF( ibaae , id , imode ,
i a tat , ibuf )
Returns information about the data base being accessed
provided the user's access level is high enough. If it is not,
data items, data sets, and data paths are considered
nonexistent by IMAGE.
imode values: 101 — determine access to an item
102 — obtain information on an item
103 — get list of items in the data base
104 — get list of items in a data set
201 — determine access to a set
4-5
202 — obtain information on a set
203 — get list of sets in the data base
204 — get list of sets containing an item
301 — get list of paths for a data set
302 — determine master data set's
search item
401 — obtain current chain pointers
402 — restore saved chain pointers
DBLCK
Format: DBLCKC ibase , id , imode , i a tat )
Provides temporary exclusive control of a data base by lock-
ing the root file. A redundant call while in open mode 1 or a
call in open mode 3 is ignored,
imode values: 1 — lock with wait
2 — lock, no wait
DBOPN
Format: DBOPNObase.ilevl , imode , is tat )
Initiates access to the data base and establishes the access
mode and level for all subsequent data base interaction,
imode values: 1 — shared read/write with lock access
3 — exclusive read/write access
8 — shared read-only access
DBPUT
Format: DBPUTCibase, id, imode, istat ,
list I | ibuf
name-list J' I value-list
Adds new entries to a manual master or detail data set. The
data base must be open in mode 1 or 3 and the user's access
level must allow write access. If opened in mode 1 , the data
base must be locked before DBPUT is called. Imode must
contain the value 1 .
4-6
DBUNL
Format: DBUNL( ibase , id , imode , i s tot )
Relinquishes the temporary exclusive control a data base
acquired by a previous call to DBLCK. DBUNL unlocks the
root file and disables the calling program's data base write
access until another DBLCK call is made. Redundant calls
and calls not made in open mode 1 are ignored. Imode must
contain the value 1.
DBUPD
Format: DBUPDC ibase , id , imode , i a tat ,
Modifies values of data items in the entry residing at the
current record address of a specified data set when the data
base is open in mode 1 or 3. If open in mode 1 , the data base
must be locked. Key items cannot be modified. Imode must
contain the value 1 .
(
list
name- 1 i st
ibuf
val ue-1 ist
4-7
MAINTAINING THE DATA BASE
Utility Programs
DBLOD
Loads data base values from a file created by DBULD into a
data base.
Run :RU,DBL0D[ ,console][ .storage]
Format: [, root ] C , level H, abort ]
console Console lu. Default is scheduling lu
storage FMP namr where the data has been stored.
Default is lu 8.
root FMP namr of root file. No default — this is an
interactive prompt.
level Highest level word defined for the data base.
No default — this is an interactive prompt.
abort AB to abort if duplicate file name is encoun-
tered. CO to overwrite existing files. No de-
fault — this is an interactive prompt.
5-1
DBLOD interaction:
:RU,DBLOD,15,8,QADB:100:43,SECUR,CO
or
:RU,DBL0D,15,8
ROOT FILE NAMR ?QADB: 1 00 : 43
HIGHEST LEVEL CODE WORD ?SECUR
OVERWRITE EXISTING FILES (YES OR N0)?YES
END of REEL (reel #) (DBLOD reaches the end
of a magnetic tape reel)
MOUNT TAPE (data base name)
(peel #) loading process
ON LOGICAL UNIT DEVICE n0t V<3t
, , „, complete
(lu #)
READY (YES OR NO)?
END OF FILE (storage file DBLOD has
name) reached the
NEXT STORAGE FILE (AB TO end of the
ABORT)? disc file
DATA BASE LOAD COMPLETED
load operation
is complete
5-2
DBULD
Stores data base information to magnetic tape or disc file.
Run
:RU,DBULD[
,cori3ole] [storage]
Format:
C .root] [
, level 1 [ .abort ]
console Console lu. Default is scheduling lu.
storage FMP namr where the data has been stored.
Default is lu 8.
root FMP namr of root file. No default — this is an
interactive prompt.
level Highest level word defined for the data base.
No default — this is an interactive prompt.
abort AB to abort if end of storage device is
reached, CO to continue under this condition.
DBULD interaction:
: RU, DBULD ,15,8,QADB: 100: 43, SECUR.AB
or
:RU,DBULD,1S,8
ROOT FILE NAMR ?QADB: 100:43
HIGHEST LEVEL WORD ?SECUR
ABORT AT END OF STORAGE DEVICE
<YES OR NO)? YES
SAVE TAPE ON LOGICAL DEVICE
(lu#)
AS (data base name)
(reel number)
MOUNT NEXT REEL ON LOGICAL
DEVICE
(tape drive lu number)
READY (YES OR NO)?
DATA BASE UNLOAD COMPLETE
5-3
DBULD reaches
the end of a reel
Printed by DBULD
when new tape
reel should be
mounted
Completion of
dump message
DBSTR
Dumps a root file and associated detail, automatic and
manual master data sets (including pointers) to a magnetic
tape or disc file.
Run : RU , DBSTR [ .console] [ , storage]
Format: [ , root ] t , 1 evel ] [ ,abor t ]
console Console lu. Default is scheduling lu.
storage FMP namr where the data has been stored.
Default is lu 8.
root FMP namr of root file. No default — this is an
interactive prompt.
level Highest level word defined for the data base.
abort AB to abort if end of storage device is
reached, CO to continue under this condition.
DBRST
Loads a data base and associated root file from backup files
created by DBSTR.
Run : RU, DBRST [ .console] [ , storage]
Format: [, root ][, level ][ .abort ]
console Console lu. Default is scheduling lu.
storage FMP namr where the data has been stored.
Default is lu 8
root FMP namr of root file. No default — this is an
interactive prompt.
level Highest level word defined for the data base.
No default — this is an interactive prompt.
abort AB to abort if duplicate file name is encoun-
tered, CO to overwrite existing files. No de-
fault — this is an interactive prompt.
5-4
DBS PA
Indicates number of records used, number of free records,
and the capacity of all data sets in a data base.
Run
:RU,DBSPA[ .console] [ , list ]
Format:
[ .root ] C .level ]
console
Console lu. Default is the scheduling lu.
list
lu of the list device. Default is the console lu.
root
FMP file namr of the root file. No default — this
is an interactive prompt.
level User's level word. No default — this is an
interactive prompt.
DBS PA interaction:
:RU,DBSPA,15,G,QADB: 1 00.-43.SECUR
or
:RU,DBSPA,1S,6
ROOT FILE NAMR ?QADB:100:43
LEVEL CODE WORD ?SECURE
DBSPA response to data:
Lists all data sets, capacity, records used, free records, and
any discrepancies.
5-5
RECOV
Displays the number of programs that have the data base
open in any access mode and allows the user to close any
data base inadvertently left open.
Run : RU ,RECOV[ .console]
Format: E , 1 i st ] [ .node]
console Console lu. Default is the scheduling lu.
list List lu. Default is the console lu.
node Operator's node number in DS network. De-
fault is the local node.
Recov responses:
DONE (successful simulated closure)
Printout of coordinating table
DATA BASE <fnms,r6 1 RELEASED (user count is reduced
to zero)
CLOSURE UNSUCCESSFUL (unsuccessful simulated
closure)
5-6
ERROR MESSAGES
IMAGE NUMBERED ERROR MESSAGES:
100 Illegal data set reference
101 Illegal item reference
102 Data item specified is not a key item
103 Illegal data base parameter, or data base not open to
user
104 The mode of operation for the data base (specified in
the DBOPN call) is insufficient for the type of access
requested in a subroutine call.
105 Detail data set is full; no empty record space exists
106 Master data set is full; no empty record space exists
107 A master data set does not contain an entry for a key
item value
108 A request has been directed to an automatic master
data set
110 A key data item value already exists in a manual
master data set
111 Path has not been initialized for a chain read, or
record number in directed read is illegal
1 12 User has attempted to change the value of a key item
1 13 User has attempted to delete a manual master data
set entry that still has links to non-empty detail data
set chains
114 Record accessed is empty
1 15 The mode specified by the user is invalid
1 16 File specified by the IBASE parameter is not a root file
117 The security code given does not match the security
code for the data base being accessed
118 Data set is not write enabled for the user's access
level
119 The root file for the data base being accessed does
not exist
1 20 The data set being accessed is not a detail data set
121 The detail data set being accessed is not linked to
any master data sets
122 A chain read cannot be performed
123 Data set being accessed is not a master data set
124 Illegal DBINF request
6-1
ERROR MESSAGES (Continued)
IMAGE NUMBERED ERROR MESSAGES:
125 Invalid data set or item reference used in DBINF
request
128 Not enough space for IMAGE data buffers (solution:
make program smaller, segment program or run pro-
gram in a larger partition)
129 Root file is opened exclusively to another user
131 No activity table space available (more than 20 dif-
ferent data bases are open in the system) or the data
base is already open to seven users
132 No resource number available
1 34 An attempt is being made to lock a data base that
has been opened in mode = 8
135 Data base is locked to user and attempts to unlock it
have failed
1 36 Data base is locked to another user (returned on lock
without wait request)
137 Illegal resource number usage
140 Unable to schedule DBCOP
150 Data base already open to user
152 Data base open to another user in an incompatible
mode
153 User has no access to any item or set in the data
base with his given level
1 54 Data base corrupt — bad data path pointers in a data
set
155 Beginning of chain or end of chain found on a
chained read
156 Detail data set does not contain any entries along the
specified chain
157 No current record for data set
159 User attempting to UPDATE, PUT or DELETE a
record with an open mode of 1 without first locking
the data base
1 60 IMAGE data structures are corrupt (could be caused
by the structures being overwritten or by DBBUF not
residing in the main segment)
6-2
ERROR MESSAGES (Continued)
IMAGE NUMBERED ERROR MESSAGES:
161 An internal subroutine passed DBCOP an illegal func-
tion code (could be caused by a user writing over a
constant in an IMAGE segment)
162 Missing parameter in a library subroutine call
201 User passed DBBLD an illegal data base name
202 User passed DBBLD an incorrect security code
203 No data appears in the DBBLD input file between the
first record and the SEND record
204 A data entry in the DBBLD input file is too short or
omitted
205 A $SET: or SEND record is missing or too many fields
exist for a data entry in a DBBLD input file
206 A nonnumeric character or invalid number appeared
in an integer data field in a DBBLD input file
207 A nonnumeric character appeared in a numeric data
field in a DBBLD input file
208 An error has occurred during entry into a data base
from a DBBLD input file and DBBLD cannot purge the
data base
209 A physical end-of-file mark was encountered by
DBBLD while processing an input file
210 The logical unit specified in the RUN command for
one of the utilities (DBRST, DBSTR, DBLOD, DBUNL)
was illegal
211 The user has failed to give the correct level word to
DBRST, DBSTR, DBLOD or DBUNL
212 The input file presented to DBLOD or DBRST is of an
illegal format
213 The user has failed to give the proper security code
to DBRST, DBSTR, DBUNL or DBLOD
214 The root file and associated sets are on different
subchannels during operation of DBSTR or DBRST
215 Either the file containing the data base root file or the
file containing the data base cannot be found during
operation of the DBSTR or DBRST routines
6-3
216 Either the root file size or the data base file size on the
disc is not the same size as the root file and data
base stored on the back-up file
217 The DBULD routine has discovered no data in the
data base to unload
218 Illegal mode or column parameter
219 Not enough space to load root file
220 DBBLD has encountered an I/O abort
230 An attempt is being made to write to a tape that has
no write ring
231 An attempt is being made to access a tape on a drive
that is off-line
235 The utility is aborting because it reached the end of
the FMP storage file without reaching the end of the
data base and the user did not specify to continue
236 The utility is aborting because it reached the end of
tape before reaching the end of the data base and
the user did not specify to continue
241 The lu specified as the console lu is not interactive
242 The user mounted a reel with an incorrect reel
number or specified a disc file out of sequence
6-4
ERROR MESSAGES (Continued)
IMAGE NUMBERED ERROR MESSAGES:
243 The root file name specified does not match the root
file name on the storage device
244 The user specified the wrong cartridge to restore the
data base (DBRST must load the data base back
onto the same cartridge from which it came)
247 The program was terminated by the user entering the
operator BR[EAK] command
248 An illegal word was entered as an abort option in the
run string
302 Too many names in a NAME-LIST
303 Invalid name in NAME-LIST
304 The type or length of a variable in VALUE-LIST does
not match the type or length of its corresponding item
in NAME-LIST
305 Variable missing in VALUE-LIST
306 Invalid relative record number (nonnumeric)
310 Illegal IBASE parameter of a DBOPN call (does not
start with two blanks)
324 Illegal DBINF request
7777 A catastrophic error has occurred in a utility — reload
and rerun the program
6-5
ERROR MESSAGES (Continued)
DBDS ERROR MESSAGES:
MESSAGE
ALL PATHS TO MASTER ARE NOT DEFINED
AT LEAST ONE ITEM MUST BE DEFINED
AUTOMATIC MASTER MUST HAVE KEY ITEM ONLY
AUTO-MASTERS MUST HAVE AT LEAST 1 PATH
AUTO-MASTER NEEDS MORE WRITE CAPABILITY
BAD CAPACITY COUNT
BAD READ LEVEL
BAD TERMINATOR EXPECTED
BAD TYPE DESIGNATOR
BAD WRITE LEVEL
'BEGIN DATA BASE' EXPECTED
CANNOT OPEN SCHEMA FILE
'CAPACITY:' EXPECTED
6-6
MEANING
Not enough detail data sets defined a path to a master set.
The data base must have a minimum of one item defined.
An automatic master may have only one item defined and it
must be a path item.
An automatic master data set must define a path item with a
path count of at least 1 .
An automatic master's write level must be equal to or greater
than its related detail data set's key item (this is not true of
manual masters).
The capacity count was not between 1 and 2 31 -1.
The read level was not between 1 and 15.
A semi-colon was expected. DBDS scans until it finds a
semi-colon before it continues processing.
An item has been defined as other than 11 , R2, or Xn or a data
set has been defined as other than Manual, Automatic, or
Detail.
The write level on an item definition is not between 1 and 15
or is less than the read level.
The 'BEGIN DATA BASE:' command was not found.
DBDS cannot open the schema file because the wrong
name was entered, the disc is not mounted or there was a
disc error.
The 'CAPACITY:' command was expected.
6-7
DATA BASE HAS NO DATA SETS
DATA SET FILES CREATED
DATA SET MUST HAVE AN ITEM
DUPLICATE ITEM NAME
DUPLICATE LEVEL WORD
DUPLICATE SET NAME
END DATA BASE DEFINITION
♦END.' EXPECTED
END OF FILE ENCOUNTERED
♦ENTRY:' EXPECTED
ENTRY TOO BIG
FMP ERROR - ALL DATA SETS NOT CREATED
FMP ERROR XXXX ON FILE YYYY
ILLEGAL CARTRIDGE NUMBER
ILLEGAL CONTROL OPTION
ILLEGAL LEVEL WORD
ILLEGAL NAME
ILLEGAL SECURITY CODE
ILLEGAL SEPARATOR
INCOMPLETE NAME
6-8 Update 1
No data sets were defined for the data base.
All the data set files were successfully created.
Every data set must contain at least one data item.
The item name was already defined.
The level word was already defined.
The data set name was already used.
DBDS has terminated.
An END.' command was not found.
An end of file was unexpectedly found in the schema input
file.
The 'ENTRY:' command was expected.
A data entry is larger than 4096 bytes.
There was an FMP error while trying to create a data set.
The data set may have already existed or the disc was not
mounted. Examine the disc to see which data sets were
created — correct the disc error and retry DBDS.
FMP error on file YYYY.
The cartridge number is not an integer between 1 and 32767
or is not two ASCII characters.
A command found in the 'SCONTROL:' list was not legal.
An illegal character was found in the level word.
Some portion of the data base namr or some portion of the
set namr is not legal.
The security code is not an integer between 1 and 32767 or
is not two ASCII characters.
A comma, colon or parenthesis was expected.
A data base namr must have a security code.
Update 1
6-
ERROR MESSAGES (Continued)
DBDS ERROR MESSAGES: (Continued)
MESSAGE
I
ITEM NAME EXPECTED
ITEM TDD LONG
' ITEMS : ' EXPECTED
KEY ITEMS NOT OF SAME LENGTH OR TYPE
LEVEL NUMBER ALREADY DEFINED
LEVEL OUT OF RANGE
'LEVELS:' EXPECTED
MASTER MUST HAVE A PATH
MAX ERRORS-SCHEMA PROCESSING
MISSING PROGRAM SEGMENTS
'NAME:' EXPECTED
NON-NUMERIC PATH COUNT
NOT ENOUGH MEMORY TO CREATE ROOT FILE
PATH ITEM CANNOT BE AN ARRAY
6-10
Update 1
MEANING
I
A name was expected in an item definition.
An item has been defined with too many elements in its
array or the n in an Xn item is longer than 255.
The 'ITEMS:' command was expected.
A key item in a detail data set is not the same type or length
as the master's key item.
The level number was already defined.
A level number was not between 1 and 15.
The 'LEVELS:' command was not found.
All master data sets, both manual and automatic must have
a key item defined. The path count for a manual master may
be zero.
The number of errors is equal to the requested error count
specified in the 'SCONTROL' option list by the 'ERRORS='
command.
A segment to DBDS was not loaded.
The 'NAME:' command was expected.
The path count in a master data set is not an integer.
DBDS not loaded into a large enough partition. Increase
the partition size using the SZ command.
An item which was an array was defined as a path item.
Update 1
6-11
ROOT FILE CREATED
ROOT FILE NOT CREATED
ROOT FILE NOT CREATED - SCHEMA ERRORS
ROOT FILE OVERHEAD RECORD ERROR
SEARCH ITEM ALREADY DEFINED
♦SETS:' EXPECTED
THE FOLLOWING ITEMtS) ARE UNUSED
TOO MANY DATA ITEMS
TOO MANY DATA SETS
TOO MANY ELEMENTS
TOO MANY PATHS
TOTAL ITEM LENGTH NOT INTEGRAL WORDS
UNDEFINED ITEM REFERENCED
UNDEFINED SET REFERENCED
UNEXPECTED 'END.'
WARNING - SECURITY CODE IGNORED
*$CONTROL:' EXPECTED
6-12 Update 1
The root file was successfully created.
The root file was not created because of the 'NOROOT' or
'NOSET' option in the '$CONTROL:' list.
There were errors in the schema so the root file and all the
data sets were not created.
There was an error writing the overhead record to the root
file. Check for a possible disc error.
The master already has a path item defined. There can only
be one path item per master.
The 'SETS:' command was not found.
The items that are listed were not used in any sets.
More than 255 data items have been defined or more than
127 items referenced in a data set.
More than 50 data sets were defined.
More than 255 elements were defined in an item definition.
More than 16 paths were defined in the master or detail data
set or more paths from a detail were defined to a master than
were allotted to the master.
An ASCII item defined without elements must have an even
character count or the element count times the character
count must be even.
An item was used in the set part that was not defined.
A set name was used in a detail data set's path definition
that was not defined previously in the set part.
An 'END.' command was unexpectedly encountered.
A security code in a set namr is ignored. Data sets have the
same security code as the data base.
The 'SCONTROL' command was expected.
Update 1
6-13
ERROR MESSAGES (Continued)
RECOV ERROR MESSAGES:
MESSAGE
BAD PROGRAM NAME
CLEAN UP UNSUCCESSFUL
RECOV INPUT ERR
RECOV OUTPUT ERR
UNABLE TO LOCK LIST LU
UNABLE TO OBTAIN CURRENT DATA
BASE INFORMATION
DBSPA ERROR MESSAGES:
MESSAGE
/DBSPA - ERROR <XXX> ON DATA SET
/DBSPA - ERROR <XXX> ON DBOPN
/DBSPA - ERROR ON INPUT <XXXX>
/DBSPA - ERROR ON OUTPUT <XXXX>
/DBSPA - ILLEGAL OR MISSING ROOT FILE NAMR
/DBSPA - UNABLE TO LOCK OUTPUT LU
/DBSPA - UNABLE TO OBTAIN INFORMATION ON
DATA SETS
6-14
MEANING
Program name misspelled or not in coordinating table.
DS error or program does not have data base opened.
I/O error from input LU.
I/O error to list device.
LU already locked.
Not enough SAM or DBCOP not loaded.
MEANING
IMAGE error while accessing data set.
IMAGE error returned from DBOPN call.
I/O ERROR FROM INPUT LU
I/O error to list device.
Illegal or missing root file namr
LU already locked.
IMAGE error from DBINF call.
6-15
QUERY ERROR MESSAGES:
MESSAGE
A MASTER ENTRY WITH KEY VALUE EXISTS
BAD DATA SET
BAD DATA SET OR DATA ITEM IN DBINF CALL
BAD OR MISSING SEGMENT
BAD TRACK IN WORK AREA
BATCH FILE ERROR
BEGINNING OR END OF CHAIN ENCOUNTERED
BREAK REQUESTED
CANNOT ALTER THE VALUE QF AN ITEM
CANNOT EDIT REAL VALUES
CANNOT PERFORM A CHAIN READ
CARTRIDGE LOCKED
COMMAND TABLE OVERFLOW
6-16
Update 1
MEANING
Translation of IMAGE error 110.
Data set specified does not exist in the data base being
processed, or level word is not sufficient for data set.
Translation of IMAGE error 125.
A segment needed by QUERY does not have an ID segment.
A track in the work area of the disc is faulty or not available.
The batch file specified in the XEQ= command cannot be
opened.
Translation of IMAGE error 155.
User entered an RTE BR[EAK] command while QUERY was
processing a report command.
Translation of IMAGE error 112.
A DETAIL, GROUP, or TOTAL statement contains a real
data item, which cannot be edited.
Translation of IMAGE error 122.
Translation of FMP error 13.
Alter the REPORT procedure to contain less than 100
statements.
Update 1
6-17
ERROR MESSAGES (Continued)
QUERY ERROR MESSAGES: (Continued)
MESSAGE
CONFLICT IN SST DEFINITION
CONSTANT LITERAL HAS EDIT OPTION
CONTROL BREAK INCONSISTENCY
DATA BASE ALREADY LOCKED TO ANOTHER USER
DATA-BASE ALREADY OPEN
DATA-BASE CANNOT BE CLOSED DUE TO LOCK
DATA BASE CORRUPT - BAD CHAIN POINTER
DATA BASE INACCESSIBLE WITH THAT LEVEL
DATA BASE MUST BE LOCKED
DATA BASE OPEN EXCLUSIVELY
DATA BASE NOT DECLARED
DATA BASE NOT ENABLED FOR LOCKING
DATA BASE NOT OPENED
DATA BASE RN IS BEING USED ILLEGALLY
DATA ITEM NOT MEMBER OF SET
DATA ITEM VALUE TOO LONG
DATA SET FOR OPERATION MUST BE A DETAIL
DATA SET FOR OPERATION MUST BE A MASTER
6-18
MEANING
Translation of FMP error 39.
Alter the REPORT procedure to delete the edit mask refer-
ence or change the constant to a data item name.
The level numbers of a TOTAL, SORT, or GROUP statement
do not match properly. Alter the REPORT to maintain control
break consistency.
Translation of IMAGE error 136.
Translation of IMAGE error 150.
Translation of IMAGE error 135.
Translation of IMAGE error 154.
Level code insufficient.
Translation of IMAGE error 159.
Translation of IMAGE error 129.
Type a DATA-BASE= command, then reenter the QUERY
command.
Translation of IMAGE error 134.
Translation of IMAGE error 103.
Translation of IMAGE error 137.
Data item specified is not a member of the data set being
processed.
Data item value exceeds 255 characters.
Translation of IMAGE error 120.
Translation of IMAGE error 123.
6-19
DATA SET IS NOT WRITE ENABLED
DETAIL CHAIN IS EMPTY
DETAIL DATA SET HAS NO PATHS
DETAIL DATA SET IS FULL
DCB NOT OPEN
DETAIL LEVEL XX IS MISSING
DEVICE I/O ABORTED
DIRECTORY FULL
DISC CARTRIDGE NOT FOUND
DISC DOWN
DUPLICATE DATA ITEM IN SOFT STATEMENTS
DUPLICATE EDIT STATEMENT
DUPLICATE NAME
EDIT MASK TABLE OVERFLOW
XXXXXX ENTRIES FOUND
ERROR NO. XXX
FILE CURRENTLY OPEN OR EXCLUSIVE OR
LOCK REJECT
FILE NOT FOUND
6-20
Translation of IMAGE error 118.
Translation of IMAGE error 156.
Translation of IMAGE error 121.
Translation of IMAGE error 105
Translation of FMP error 11.
DETAIL statements using level numbers must be contiguous
starting at 1. A DETAIL statement using level 1 may be de-
fined without defining a DETAIL statement with no level
number
QUERY had an I/O abort error.
Translation of FMP error 14.
Translation of FMP error 32.
Translation of FMP error 1.
Alter the REPORT to eliminate the double reference.
Alter the REPORT procedure to eliminate the double
reference.
Translation of FMP error 2.
Alter the REPORT command to contain not more than 10
edit masks.
Number of entries selected by the FIND command.
An error occurred which is not in either of QUERY'S trans-
lation tables. If the error number is greater than 99, see
Table B-1 in the IMAGE manual for more information. If the
error is less than 100, see the FMP File Manager Manual.
Translation of FMP error 8.
Translation of FMP error 6.
6-21
ERROR MESSAGES (Continued)
QUERY ERROR MESSAGES: (Continued)
MESSAGE
FILE SPECIFIED IS NOT A ROOT FILE
FILE EXPECTED
FIND PROCEDURE TOO LONG
GREATER THAN 25S EXTENTS
ILLEGAL ACCESS TO DATA SET
ILLEGAL ACCESS TO LU
ILLEGAL ACCESS TO SYSTEM
ILLEGAL CONTROL OPERAND
ILLEGAL DATA ITEM NAME
ILLEGAL DATA SET NAME
ILLEGAL DESTINATION LU
ILLEGAL INPUT PARAMETER
ILLEGAL LIST PARAMETER
ILLEGAL LOCK REQUEST
ILLEGAL LOG PARAMETER
ILLEGAL LU
ILLEGAL NAME
6-22
MEANING
Translation of IMAGE error 116.
A procedure file was used in a FIND command that did not
include the FIND command. Probable cause is an error in
creating the procedure file or supplying the wrong procedure
file name.
A FIND procedure contains more than 50 logical
relationships.
Translation of FMP error 46.
User does not have write access to the data set. Reopen the
data set using a higher level code word.
Translation of FMP error 20.
Translation of FMP error 19.
Internal error in QUERY'S tables.
Data item name specified does not appear in the schema
for the data base being accessed, or level code word is
insufficient.
Data set name specified does not appear in the data base
being processed, or level code word insufficient.
Translation of FMP error 21.
The input file declared in the RU, QUERY command cannot
be opened.
The list file declared in the RU, QUERY command cannot be
opened.
There was an error when QUERY tried to lock the list lu.
The log file declared in the RU, QUERY command cannot be
opened.
Translation of FMP error 18.
Translation of FMP error 15.
6-23
ILLEGAL OPTION
ILLEGAL PATH MODIFICATION
ILLEGAL READ OR WRITE ON TYPE 0
ILLEGAL SECURITY CODE
ILLEGAL SELECT-FILE SIZE OR TYPE
ILLEGAL TERMINATOR
ILLEGAL TYPE OR SIZE x 0
INCONSISTENCY BETWEEN OPTIONS AND EDIT
STATEMENTS
INPUT FILE ERROR - YYYYYYYYY
INPUT MUST BE CONTAINED WITHIN MULTIPLE
LINES OF 72 CHARACTERS
INPUT TOO LONG
INSUFFICIENT WORK AREA FOR SORT
INERNAL BUFFERS ARE CORRUPT
INTERNAL DBCOP ERROR
INTERNAL IMAGE CALL IS INVALID
6-24
The option parameter in the RU, QUERY string did not begin
with the letters "EC".
User tried to change a key item value in an UPDATE
REPLACE command.
Translation of FMP error 17.
Translation of IMAGE error 117.
The select-file specified by the user existed, but is not a type 1
file, or is less than three blocks long.
An item value being entered must end with a semicolon.
This error could also occur if too many values are entered for
an array item
Translation of FMP error 16.
A REPORT command specified an edit mask that did not
exist, or an edit mask was used on a data item that is a
type real.
File Manager error YYYYYYYYY occurred when the
RU, QUERY command was entered.
QUERY ignores commands of more than 72 characters
per line.
The command entered exceeded 896 characters. Retype in
a shorter form.
The area on the disc reserved for sorting data entries is not
large enough to sort all of the desired entries. Use the FIND
command to shorten the number of data entries found,
reduce the number of items sorted, increase the number of
system tracks available, or simply try again later when the
system is less busy.
Translation of IMAGE error 160.
Translation of IMAGE error 161
Translation of IMAGE error 162.
6-25
ERROR MESSAGES (Continued)
QUERY ERROR MESSAGES: (Continued)
MESSAGE
INVALID COMMAND
INVALID DATA ITEM NAME OR NUMBER
INVALID DATA SET NAME OR NUMBER
INVALID DATA ITEM VALUE OR TERMINATOR
INVALID DBINF MODE
INVALID LOGICAL CONNECTOR XXXXXX
INVALID MODE
INVALID # OF VALUES FOR RELATIONAL
OPERATOR
INVALID OR MISSING SEARCH ITEM
INVALID PROCEDURE NAME
INVALID REQUEST
INVALIE SECURITY CODE OR ILLEGAL WRITE
ON LU
ITEM NOT MEMBER OF DATA SET OR DATA SET
NOT SPECIFIED
LIST FILE ERROR
LU NOT FOUND IN SST
6-26
MEANING
Command not recognized by QUERY.
Translation of IMAGE error 101.
Translation of IMAGE error 100.
A value is not enclosed in quotes, or a comma or logical con-
nector is missing.
Translation of IMAGE error 124.
QUERY anticipated an AND, OR, or END and does not
recognize the characters specified by XXXXXX.
Mode parameter entered was not an acceptable open mode
value.
More than one value follows an IGT, ILT, or INLT where only
one value is allowed.
Translation of IMAGE error 102.
Procedure name used in a command is invalid. Retype using
the proper name.
Level code word or open access mode is illegal.
Translation of FMP error 7.
A qualified data item is not a member of the data set speci-
fied in the FIND command or a data item is a member of
more than one data set and the desired data set is not
specified.
The list file specified in the LIST= command could not be
opened.
Translation of FMP error 40
6-27
MASTER DATA SET IS FULL
MORE THAN 5 FIELDS ARE BEING TOTALED
MUST ENTER PATH ITEM VALUE
NEXT?
NO ACCESS TO DATA SETS
NO CURRENT CHAIN OR BAD RECORD NUMBER
NO CURRENT RECORD FOR OPERATION
NO MASTER ENTRY WITH KEY ITEM VALUE
NO RESOURCE NUMBER AVAILABLE
NO ROOM FOR DATA BASE ENTRY INDBCOP
NON-NUMERIC IN INTEGER VALUE
NON-NUMERIC IN REAL OR INTEGER VALUE
NON-NUMERIC IN REAL VALUE
NOT ENOUGH ROOM ON DISC CARTRIDGE
OPEN MODE DOES NOT ALLOW THAT OPERATION
QUERY - OUTPUT FILE ERROR
PART 1 1 TON IS TOO SMALL
PROCEDURE NAME XXXXXX NOT FOUND
QUERY/1 000 READY
6-28
Translation of IMAGE error 106.
TOTAL statements in a REPORT command reference more
than five different data items.
User must enter values for path (or key) items in an UPDATE
ADD command.
QUERY is ready for another command.
User does not have access to any data set in the data base.
Translation of IMAGE error 111.
Translation of IMAGE error 157.
Translation of IMAGE error 107.
Translation of IMAGE error 132.
Translation of IMAGE error 131.
A nondigit character was entered as a value for a type integer
value for a type integer data item.
User entered a nonnumeric digit when a real or integer value
was expected
A nondigit character was entered as a value for a type real
data item.
Translation of FMP error 33.
Translation of IMAGE error 104.
QUERY had a nonrecoverable file I/O error while trying to
write to the list file or the log file.
Translation of IMAGE error 128.
Specified procedure does not exist.
Informs user that QUERY is executing.
6-29
ERROR MESSAGES (Continued)
QUERY ERROR MESSAGES: (Continued)
MESSAGE
READ OR WRITE TO A RECORD NOT WRITTEN
RECORD HAS NOT YET BEEN FOUND
RECORD IS EMPTY
RELATIONAL OPERATOR INVALID
RELEASE TRACKS
REPORT CANNOT BE GENERATED DUE TO ERRORS
REPORT EXPECTED
REQUEST DIRECTED AT AN AUTOMATIC MASTER
RETRIEVAL FROM MORE THAN ONE DATA SET
ROOT FILE CANNOT BE FOUND
SAME LINES HAVE CONFLICTING REPORT OPTIONS
SELECT-FILE ERROR
6-30
MEANING
Translation of FMP error 5.
User attempted to UPDATE REPLACE, UPDATE DELETE, or
REPORT without first using a FIND command.
Translation of IMAGE error 114.
User entered a relational operator other than IS, IE, INE, IGT,
INGT, ILT, INLT or ISNOT.
More values are specified in a FIND command than can be
stored in available system tracks. Either reduce the number
of FIND data item values, make more system tracks available
or retry when the system is less busy.
REPORT command generated contains errors.
A procedure file was used in a REPORT command that did
not include a REPORT statement.
Translation of IMAGE error 108.
An attempt was made to execute a FIND command that
would retrieve values from more than one data set.
Translation of IMAGE error 119.
Like statements in a REPORT command (such as all DETAIL
statements of same level) have conflicting SPACE or SKIP
options. All items or literals that print on one line must not
space or skip more or less than other statements that print on
that line.
An I/O error occurred while accessing the select-file.
6-31
SELECT-FILE NOT DECLARED
SELECT-FILE OVERFLOW
SERIAL READ IN PROGRESS
SOF OR EOF READ OR SENSED
SORT ERROR - XXXXXX
SORT LEVEL XX IS MISSING OR DUPLICATED
SORT VALUE SIZE EXCEEDS LIMITS
STRING ADD ERROR
SYNTAX ERROR
TOTALLED STRING EXCEEDS 20
UNABLE TO SCHEDULE DBCOP
UNOBTAINABLE OPEN MODE
UPDATE EXPECTED
USER ACCESS NOT HIGH ENOUGH
VALUE MUST HAVE QUOTES _ ITEM IGNORED
VALUE TOO LARGE FOR PARAMETER
VALUE TOO LONG - ITEM IGNORED
6-32 Update 1
User attempted to execute a FIND command before a select-
file was specified. Enter the SELECT-FILE= command, then
reenter the FIND command.
QUERY found more data entries than there is room for in the
select file. A select file must be specified that is larger than
the current one.
QUERY is reading each record in the data set in order to
satisfy the requirements of a FIND command.
Translation of FMP error 12.
Numbered IMAGE error XXXXXX occurred while reading
entries from the data base.
GROUP or TOTAL statements in a REPORT command refer-
ence sort levels that do not appear in a SORT statement.
Total SORT key size is longer than 80 characters.
Totalled (added or averaged) ASCII string was not in DECAR
format.
Command is not in proper form.
A string being added or averaged had a length greater
than 20 characters.
Translation of IMAGE error 140.
Translation of IMAGE error 152.
ERROR MESSAGES (Continued)
IMAGE ERROR CODES AND QUERY
MESSAGES:
NUMBERED
CODE ERROR MESSAGE
100 INVALID DATA SET NAME OR
NUMBER
101 INVALID DATA ITEM NAME OR
NUMBER
102 INVALID OR MISSING
SEARCH ITEM
103 DATA BASE NOT OPENED
104 OPEN MODE DOES NOT ALLOW THAT
OPERATION
105 DETAIL DATA SET IS FULL
106 MASTER DATA SET IS FULL
107 NO MASTER ENTRY WITH KEY
ITEM VALUE
108 REQUEST DIRECTED AT AN
AUTOMATIC MASTER
110 A MASTER ENTRY WITH KEY
VALUE EXISTS
111 NO CURRENT CHAIN OR BAD
RECORD NUMBER
112 CANNOT ALTER THE VALUE OF
AN ITEM
113 ENTRY BEING DELETED HAS
NON-EMPTY CHAINS
114 RECORD IS EMPTY
115 INVALID MODE
116 FILE SPECIFIED IS NOT A
ROOT FILE
117 ILLEGAL SECURITY CODE
118 DATA SET IS NOT WRITE
ENABLED
119 ROOT FILE CANNOT BE FOUND
120 DATA SET FOR OPERATION MUST BE
A DETAIL
121 DETAIL DATA SET HAS NO PATHS
122 CANNOT PERFORM A CHAIN READ
123 DATA SET FOR OPERATION MUST BE
A MASTER
6-34
124 INVALID DBINF MODE
125 BAD DATA SET OR DATA ITEM IN
DBINF CALL
128 PARTITION IS TOO SMALL
129 DATA BASE OPEN EXCLUSIVELY
131 NO ROOM FOR DATA BASE ENTRY
IN DBCOP
132 NO RESOURCE NUMBER AVAILABLE
134 DATA BASE NOT ENABLED FOR
LOCKING
135 DATA BASE CANNOT BE CLOSED DUE
TO LOCK
136 DATA BASE ALREADY LOCKED TO
ANOTHER USER
137 DATA BASE RN IS BEING USED
ILLEGALLY
140 UNABLE TO SCHEDULE DBCOP
150 DATA BASE ALREADY OPEN
152 UNOBTAINABLE OPEN MODE
153 DATA BASE INACCESSIBLE WITH
THAT LEVEL
154 DATA BASE CORRUPT - BAD
CHAIN POINTER
155 BEGINNING OR END OF CHAIN
ENCOUNTERED
156 DETAIL CHAIN IS EMPTY
157 NO CURRENT RECORD FOR
OPERATION
158 DATA ITEM IS NOT PART OF
GIVEN DATA SET
159 DATA BASE MUST BE LOCKED
160 INTERNAL BUFFERS ARE CORRUPT
161 INTERNAL DBCOP ERROR
162 INTERNAL IMAGE CALL IS INVALID
6-35
