MDBS_Application_Programming_Ref_Dec1985 MDBS Application Programming Ref Dec1985

MDBS_Application_Programming_Ref_Dec1985 MDBS_Application_Programming_Ref_Dec1985

User Manual: MDBS_Application_Programming_Ref_Dec1985

Open the PDF directly: View PDF .
Page Count: 193

Download
Open PDF In Browser	View PDF

PROGRAMMING

MDBS APPLICATION

REFERENCE MANUAL

The MDBS DMS MANUAL
Version

Micro

Data

3.08

Base Systems, Inc.

P. O. Box
Lafayette,

248

Indiana

47902

USA
Telex:

(312)

209147

303-6300

ISE

(in Illinois)

December

1985

employees

Inc

. ,

and

agreement

(C)

is provided for the use of the customer and the customer 's
have
been copyrighted
by Micro Data Base Systems,
entire
contents
reproduction by any means is prohibited except as permitted in a written
with Micro Data Base Systems,
Inc.
manual

The

1981

Micro

Data

Base

Systems,

Inc.

Rev.

85A
3250332

NEW

RELEASES,

VERSIONS,

AND

A WARNING

of the magnitude of the MDBS software will
necessarily continue to evolve over time. ReaHzing this, Micro Data
Base Systems, Inc., vows to provide its users with updates to this
version for a nominal handling fee.

Any programming

endeavor

versions of MDBS software will be considered as separate products.
bona fide owners of previous versions are generally entitled
However,
to a preferential
rate structure.

New

Finally,

of our software is personalized to identify the
some
of
licensee.
several levels of this personalization,'
methods
be
which involve encryption
guaranteed to
combinatorially
Our products have been produced with a very
decipher.
difficult to investment
of capital and labor, to say nothing of the
substantial
years of prior involvement in the data base management area by our
we
Accordingly,
concerned about any
principals.
are seriously
unauthorized
copying of our products and will take any and all
available legal action against illegal copying or distribution of our
products.

(C)

each copy
There are

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MDBS

MANUAL

DMS

MANUAL

PREFACE

application developers were well aware of the
the miá-1960s,
data handling limitations of programming languages and file management
To overcome these limitations, data base management systems
systems.
approaches
to data base
By 1971,
began
four major
to appear.
shallow-network,
had
management
the hierarchical,
taken shape:
approaches
structuring
CODASYL-network
and
logical
data
to
relational,
Each
and manipulation.
represented an advance over the old fileoffered
oriented data handling methods and the latter two approaches
advances over the former two.
By the mid-1970s,
data base management
software was well established as the cornerstone for application
development
and some mini computers.
on mainframes
By

microcomputers
end of the decade,
with their
computing
basis -- -- began to
dollar
power
on a per
The acceptance
of mainframe data base management systems
proliferate.
coupled
with the rise of microcomputers
led to the formation of Micro
Data
Base
Systems
in both
Incorporated by a group with expertise
make
qenl1ine
management
base
The
data
objective
was
to
areas.
in
This objective was
tools available in the micro realm.
and viable data
1979 with the release of MDBS I
authentic
the
-- microcomputers. Over the years,
base
management system (dbms) for
which operates not only on
has evolved
into the present MDBS
this microcomputers
The evolution of
machines
many
as well.
but on larger

the

Near
phenomenal

initial

fulfilled

first
III

with
micro dbms
is highlighted with many firsts:
first
a
and
implementation
of
logging
recovery,
first
full
dbms
micro
dbms,
dbms,
postrelational
to run
first
first multiuser
MDBS

built-inIII
under

PCDOS,

MSDOS

and UNIX.

MDBS
Today,
offers professional application
developers a
degree
and
of power
unavailable with any other data base
be
management software
This is
minis or mainframes.
on micros,
-due
implementation
proprietary
to the highly efficient,
partially
MDBS
techniques.
is not a mainframe retread shoehorned into a
microcomputer.
is also due to the innovative data modeling
Because these features go far beyond
features that MDBS
provides.
MDBS
those of the older data base management approaches,
is
variously
referred to as postrelational
multiarchical
extendedor
or
The emphasis in this approach
network.
to data base management is on
The result
natural representation of the application world.
direct,
As stated in the
is a tremendous increase in developer productivity.
DApt'ÁhÁqe
r.he 7"Ñí generÁr.ic)n·
authoritative
qtAfe of fjie Arr. pepc)rt.
1982):
L. Gradwell, Pergamon press, Oxford, England,
(ed., D.

IIIflexibility
it
It III
III

III

"The

data modelling capability of MDBS
other commercially available DBMS." MDBS
that is, in many ways, ahead of mainframe
gradwell)

III is issuperior
III
DBMSs.""... (D.

All

of this translates
into
developers and administrators.

(C)

1981

convenience

Micro Data Base Systems,

for

Inc.

application

to any
product

system

Rev.

85A

mdbs

dms

manual

mdbs

Dl4S

manual

The MDBS R&D Lab's expertise
in the areas of decision support
unique
systems and artificial
intelligence has resulteá in two
environments for processing MDBS
data bases. One is a decision
support environment called Kmwledgeí·iam
functions as a universal
It
knowledge
management system,
allowing users to represent and process
knowledge in many different ways
spreadsheets, text,
-- including
graphics,
forms, procedural models,
data bases, and
relational
MDBS
The
second
data
bases.
postrelational
is a revolutionary
wakes
Guru.
environment
called
the
artificial of intelligence
and
both
technology
language
expert system
benefits
natural
processing easily accessible to business users, without sacrificing
familiar business computing capabilities. FIDBS III data base contents
are directly accessible within the Guru environment.

III

This manual provides details on the features and utilization of
Companion
manuals
Language.
Data fianipulation
discuss the
I·1DBS Data
and various optional modules.
Language
This
Description
manual is not intended to be a tutorial.
For a tutorial treatment of
s
(including
many advantages over f lle
data base management
management),
the reader
is advised to consult such suitable references
the

lrrent of
>rrent of

COMMANDS

LGCPLX
LGENDX

RETRIEVAL

MANUAL

DMS

MDBS

MANUAL

from Current of run unit) . . . .
from Member).
. . . . . . . . . .
from Qwner) . . . . . . . . . . .
(Get Eield from Current of run unit). . . .
(Get Uekí from Member) . . . . . . . . . .
(Get Eield from Qwner).
. . . . . . . . . .
(Qbtain Duplicate Record based on calc Key)
(GET
(GEE
(GET

data
data
data

(Qbtain
(Qbtain
(Qbtain
(Qbtain
(Qbtain
(Qbtain
(Qbtain
(Qbtain
(Qbtain
(Qbtain
(Qbtain
(Qbtain
(Qbtain
(Qbtain
(Obtain
(Qbtain
(Qbtain
(Qbtain
(Qbtain
(Qbtain
(Qbtain
1981

Eirst Qwner).
Urst Member).
Me1nber)

j,ast
Last Qwner)

.
.
.
.

.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

based on data ftem).
Member based on Sort Key) .
Next fjember).
. . . . . . .
Next MeInber based on data Ltem)
Next E1elnber based on 8ort Key).
Next Qwner) . . . . . . . . . .
Next Qwner based on data ítem).
Next Qwner based on Sort Key) .
Qwner based on data ítem) . . .
Qwner based on 8ort Key). . . .
Erior Member) . . . . . . . . .
2Uor Member based on data Ltem).
MeTnber
based on 8ort Key) .
2rior Qwner).
2Uor
. . . . . . . . . .
12rior Qwner based on data Lteni) .
Erior Qwner based on Sort Key). .
Eecord based on calc Key) . . . .
Member

Micro

Data

Base Systems,

Inc.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

Rev.

.
.
.
.
.
.

30
30
31
31
32
32

32.1
32.2
32.3
32.4
32.5
32.6
32.7
32.8
32.9

.32.10
.32.11

.32.12
.32.13
.32.14

.32.15
.32.16
.32.17

.32.18
.32.19
.32.20
.32.21
.32.22

85A

MDBS

DMS

SPECIAL

MANUAL

(ÁLíTer Eñd Qfi ,aet). . . .
(IZata Base control system
(Qata 2ase SEl,ection)
. .

dbinit
DBSEL

DMSSJP
EXTEND
MPL
SETPBF

undef

varcs

.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.

(Allocate Aser Lndicators).
. . . . . .
(Check Qirrent of run unit against Yser

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.

.
.
.
.
. O
. .
. .
. .
. .
. .
. .
. ·.
. .
. .
. .
. .
. .
. .
. .
. .
. .

INITialization)

data block) . . . . .
(wis Set JimE). . . . . . . .
(FYTFNP
data block) . . . . .
(Mu1tiuser Eriority j,evel). .
(SEE
Eage BuEfer region).
. .
(TjNr)EFine data blocks).
.
.
.
(miable for Command átatus)
(PFFTNF

DEFINE

.
.
.

89
90
90

90.1
90.2
90.2
.
.
.

91
92
92

92.1

COMMANDS

AUI
CCU
DBCLS
DBCLSA
DBCNV
DBENV

dbopn
DBOPNA
DBSAVE
DBSTAT
GMC
GOC
GTC
GTM
GTO
NCI
TCN
TCT
TMN
TMT
TON
TOT
TUN

MANUAL

COMMANDS

ALTEOS

UTILITY

DMS

MDBS

Rev.

(Oata Base CCLoáe)
. . . . .
(Oata Base CL,oáe for Area).
(pata Rase format CoNyersion)
(Qata Base ENYironment)
. .
(Oata j3,ase QEeN). . € . . .
(Oata Base QEeli Áxea) . . .
(Oata E,ase
. . . . .
(Oata Base
. .
(Get fjember Count). . . . .
(Get Qwner Count)
. . . . .
(Get Type of >rrent of run
(Get Type of fjember).
. . .
(Get Type of Qwner) . . . .

.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.

.
.
.
.

.
.

.
.
.

unit)

.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.

(Null all >rrency Lñdicators).
(Tfst Current of run unit for Eiull)
(Fest Current of run unit Type) . .
(Test Member for NUI). . . . . . .
(Tést Member Type). . . . .
. . .
(Tést Qwner for tiull) . . . . . . .
(Tést Qwner rype) . . . . . . . . .
(Test Yser indicator
for NullA . .

85A

(C)

1981

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

indicator).

Micro Data Base Systems,

.
.
.
.
.

67
68
69
70
70

70.1
.
.
.
.
.
.
.
.
.
.
.
.

71
72
73
74
75

75
76
76
77
77

78
78

78.1
. 78
78.2
78.2
. 79

Inc.

MDBS

DMS

MDBS

MANUAL

OVERVIEW

DMS

Organization

is the second component in the
This is the MDBS DMS Manual.
It
MDBS
Manuals
and
Reference
assumes
the reader is familiar with
set of
Manual.
the MDBS DDL
This
in
presented
description
data
facilities
and
document
Data Manipulation Language (DML)
describes the MDBS
command
base
DML
data
has
each
behavior
of
the
the
on
the effect that
The MDBS DMS Manual is written
(MDBS.DMS).
system
on two
control
fundamental
manipulation
manipulation features and advanced
levels:
An
is sufficient for
features.
understanding of the fundamentals
The advanced
features are
developing useful application systems.
perhaps
These are
denoted
by a vertical bar in the outsiáe margin.
needed,
special
less frequently
but they are valuable for certain
kinds of data manipulation.

III

in this manual is applicable to both versions
describes those data manipulation features that
of the host
Version 3a.
is also independent
languageHost
language(s) selected to interface with mdbs.dms.
dependent
aspects
of the interface are described in appropriate MDBS
System Specific Manuals.
The documentation
A
3a and 3c. Appendix
are applicable only to

remainder
of this chapter outlines the role of MDBS.DMS
(DML),
and
Language
Data Manipulation
in
software
its associated
background
development.
Chapter
provides the detailed
application
that is necessary
to effectively use the MDBS Data Manipulation
Each
Chapters
Language.
through XV documents a class of DML
of
commands.
The
commands
individual
in each class are presented
When
command
a
and
each
is described.
alphabetically
the function of
command
DML
MDBS.DMS
is executed,
reports on the status of that
command's
Each possible command
execution.
status is explained in
Chapter
XVI.
Tlíe

III

The Role

DML

in Application

Development

Data
Manipulation Language consists of a group
of
A DML
of which performs some data manipulation task.
command
The programming
is stated within an application
program.
language
used
to write an application program is called the hzak
command
1(Ínql1(aqe.
a DML
is typically invoked as a function in the
when a DML command
host language.
is given, the MDBS.DMS
software

The
commands,

MDBS

each

carries out the actual data manipulation.
This could involve storing
data from a host program variable into the data base.
Conversely,
could involve extracting data from the data base and depositing
in
Many
a
host language variable.
other kinds of data manipulation are
supported. In effect, the DML extends the data handling capability of
language,
a programming
bases
so that programs can utilize MDBS data
in addition to traditional files.

Usage
of the MDBS DML
depends
QIÜY upon a knowledge
The application
programmer need

searching
(C)

indices,
1981

in developing an application
program
of the data base's logical structure.
not be concerned with using pointers,
disk I/O, file handling, free space management,

Micro

Data

Base Systems,

Inc.

Rev.

85A

MDBS.DMS

MANUAL

- I:

OVERVIEI·I

IQJBS.DMS

MANUAL

etc. All of these factors are automatically handled by the I'IDBS.DE1S
software.
Furthermore, all data manipulation occurs subject to the
in a data base's DDL
security and integrity constraints defined MDBS.DMS
a
specif ication.
multiuser environment,
In
manages record
lockout to prevent such problems as one user attempting to modify a
record that another user is reading.
Special DÍ4L commands are
available to the application programmer who (beyond the standard
passive lockouts) desires to actively lock out records, record types[
or sets.
data manipulation language provides a procedural approach to
be contrasted
data manipulation.
can therefore
with a query
a
language,
which provides
nonprocedural
approach to data
the highest
manipulation. From the standpoint of achieving
performance for application software,
using a DML is inevitably
On the other hand,
superior to using a nonprocedural query language.
the application developer who is not experienced in using DEIL can very
achieve
by using a nonprocedural query
more rapid development
likely
language
(at the expense of a sacrifice in perll'-Xmance).
In data base
management
systems that do not support both a DI4L and a query
language, the application developer has no choice.
Both kinds of
languages
recommended that the query
is
are available with FIDBS.
be used in situations where the
lanquage (see the MDBS QRS Manual) It
need flor rapid development
outweighs
the need for optimal perforr.íance.
performance
is the overriáing consideration, then the MDEIS
If optimal
DML
most
is
appropriate.
In addition to QRS, there are other optional
modules
IBS, RDL and BLF.
IDML,
including
access
A

Although the MDBS DML makes many commands available,
is
the case that an application developer will need to use only
typically
a few kinds of DML commands in any given application
Across
program.
DML
a
a
about
dozen
application
is
there
small
of
programs,
group
all
commands that tend to be heavily used.
Varying degrees of selective
MDBS.DL4S
used
linking are permitted, depending on the host language
(see MDBS System Specific Manuals for details).
In other words, only
of 14DBS.DI4S
to execute an application
that part DFIL
that is needed
commands
program's
is held in main meiaoryú
Since the entire
!4DBS.DMS
software is not in main memory,
there is more memory
available for a larger appliCation program or a larger page buffer
region.

component
of FIDBS.DMS performs virtual buffer paging, based
When
a
algorithm.
page replacement
on an enhanced least-recently-used
MDBS.DMS
DML command
images
executed,
determines whether
of
is
needed pages are not resident,
needed pages are in main memory.
!4DEIS.DMS
has them read into main memory.
Tíie larger the page buffer
main
is that needed pages are
memory,
region in
the more
and
the
Thus
be.
processing
is important
resident
the Faster
a
the
application developer to allow as large
page buffer region
for
environment, the page buffer region
as possible.
In a single-user
One

all

likely it
will

assigned by the programmer.
In a multiuser
size is directly
EÍDBS.DPIS
determines the size of the page buffer region
environment,
by all users
that i s shared
i .e . , simultaneously executing
programs)
(

application

Rev.

85A

(C)

1981

Micro Data Base Systems,

Inc.

MDBS

DMS

MDBS

MANUAL

Data

MANUAL

GENERALBACKGROUND

II.
A.

DMS

Transfer

data from a host language variable into
the data
Others retrieve data from the data base into a host
language variable, from which the data can then be used for
There are two basic approaches for
computation or program output.
MDBS.DMS
to accomplish the data transferral between a data
allowing
The approach used depends
base and an application program.
on the
Non-record-oriented
nature of the host programming language.
Host
languages (such as BASIC) require the data block approach.
languages with a facility for defining program record types (e.g.r
COBOL,
PL/l, PASCAL) use the program record type approach. Füll
details of the approach used for a particular host language appear in
the MDBS System Specific Manual for that host language.
Some

DML

commands

pass

base.

ElQgks. A data block is a named sequence of one or
DML commands
MDBS
host language variables.
exist to
define, extend, and undefine data blocks (see Chapter XIII).
a given host language
variable can participate in many data
A
DML
command to put data into a data base has a
blocks.
data block name as one of its arguments. The value(s) of
the host language variable(s)
for that data block is(are)
put into the data base. ADMLcommandto retrieve data from
a data base has a data block name as one of
arguments.
The retrieved value(s) becomes the new value(s)itsfor the data
block's host language variable(s).

Rata
more

elq9lmd BegQrg Typq,s. A program record type plays the same
role as a data block. It is a named sequence of one or more
host language variables.
is not defined with DML
commands, but is specified with the host language's
facility
program
record types (for example, a Dl level
for defining
or a record
entry in a COBOL working storage section,
A given host language
PASCAL).
of
variable
or
structure
usually cannot participate
in more than one program record
A DML
command to put data into a data base has a
type.
The
record
type name as one of its arguments.
program
value(s) of the host language variable(s)
that
program
for A DML commaná
record type is(are) put into the data base.
to retrieve data from a data base has a program record type
The retrieved value(s)
name as one of its arguments.
becomes the new value(s) of the program record type's host
language variable(s).

Currency

Indicators

iÁÁicátQts are used by
of which record occurrences
maintains two
interest. MDBS.DMS
a
schema:
in
data
base's
specified
the cuixent id£iÜ2qL of the set.
Cjjll£1jgy

track

(C)

1981

Micro

Data

an application
programmer
to keep
in a data base are currently of
currency indicators for each set
the cutxent qwrrl of the set and
There
can be many owner
record

Base Systems,

Inc.

MDBS

DMS

MANUAL

- II:

BACKGROUND

MDBS

DMS

MANUAL

occurrences in the data base for a given set. At any moment during
the execution of an application program no more than one of those
owner
record occurrences is the csuxmt owner of the set.
dml
commands allow the application
programmer
to control which (if any)
owner record occurrence is the current
owner of a set. The SXSTEM
LéQQKjj
QggyKKeÁge ia aluavs the cjjtr£nt
qwijal q£ 2y£ly sYskelD=Qwneg
made
be
(unless
sek
to
is explicitly
null by the programmer).
member
be
can
many
there
record
Similarly,
occurrences in the data
base for a given set.
At any moment during the execution of an
one of those member
record
application program, no more than
DML
member.
commands
the
set's
allow
the
mirrent
occurrences is
any)
member
programmer
which
record
to
application
control
(if
occurrence is the current member of a set.

As soon

set,the

DML

as
can

record occurrence

becomes

be used:

the current

owner

to find any of its related members through that set (Chapter III),
to modify its data values (Chapter V),
to retrieve its data values (Chapter IV),
from the data base (Chapter
X),
to delete the record occurrence
etc.
As soon as
be used:

record becomes

the current

member

set, the

IJML

to find any of its related owners through that set (Chapter
to delete the record from the data base (Chapter IX),
to modify its data values (Chapter V),
to retrieve its data values (Chapter IV),
etc.

can

III),

Another kind of currency indicator that can be used during data
manipulation is called the CjjttMjt Q£ the ljji) jjjjit. A run unit is an
There are many record
executing instance of an application program.
data
a
base.
At
moment
during the execution of an
any
occurrences in
than
application program, no more
in the entire
one record occurrence
data base is the current record of that run unit. The current of a
found by the
that was mostDMLrecently
run unit is typically the record
by
commands
the
allow the
run unit).
application program (i.e.,
application programmer to control which (if any) data base record is
the current of run unit. As soon as a record becomes the current of
run unit, the DML can be used:
to delete the record from the data base (Chapter
to modify its data values (Chapter V),
to retrieve its data values (Chapter IV).

IX),

These can be any
a data base
schema has five sets.
Suppose
N:
N: M sets.
N,
An
mixture of l:
application
program can make
I:
There
use of any of eleven currency indicators.
are five current
owner indicators (one per set), five current member indicators (one
per set), and the current of run unit.
In a multiuser environment,
each application program that is using this data base will have
its
own eleven
currency indicators.

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

- II:

MANUAL

DMS

BACKGROUND

MDBS

DMS

MANUAL

to the three kinds of currency indicators already
addition
MDBS allows an application
programmer
to optionally define
of an application
scope
currency indicators within the
additional
be used
No
than 255
In

mentioned,

user-defined currency indicators can
These additional
within an application program.
currency indicators
employed to "remember"
can be usefully
the current owner of some set,
The same
before processing causes that current owner to change.
and
members
be
applied
the
current of run
principle can DML commandsto current
used
be
processing to
in
can
Various
subsequent
unit.
access the remembered
record. DML commands are also provided for the
user (i.e., application programmer) to define additional currency
indicators and to make the record that is a set's current owner (or
member or current of run unit) the current record for a user-defined
currency indicator.
program.

All currency indicators are null when an application program
begins execution, except the current owner of each system-owned set
and the current of run unit, which also has the SYSTEM
record as its
current record. A currency indicator remains null until a DML command
is executed to change it.
C.

Classes

The
has one

DML

Commands

commanás

fall
devoted to

chapter
classes is as follows:

into thirteen classes. Each command class
it. The order of presentation for these

Finding records (Chapter III)
(Chapter
IV)
Retrieving data from records
Modifying data in records (Chapter V)
Assigning currency indicators (Chapter VI)
Creating records (Chapter VII)
Connecting
records (Chapter VIII)
Disconnecting records (Chapter IX)
Deleting records (Chapter X)

Utilities
Boolean

(Chapter

XI)

operations (Chapter XII)
Special operators (Chapter XIII)
Multiuser locking (Chapter XIV)
XV)
Recovery operators (Chapter

The
the

within a given class are presented alphabetically
in
chapter for that class. In becoming acquainted with this manual,
is recommended that these chapters be examined in sequence.
Also,
the reader may want to ignore the advanced manipulation features on
the initial pass through this manual.
DML

commands

Stating

Each
mnemonic

DML

Conunand

command consists of a short mnemonic.
For instance, the
is used for Finding the first újember record connected to
A
the current owner of a set.
of zero, one, two, or three
arguments
is stated along with a DML command. An argument is either a
DML
FFM

list

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

- II:

BACKGROUND

MDBS

DMS

MANUAL

set name, record type name, area name, data item name, or data
block/program record name. For example, FEM needs a single argument:
a set
name,
to indicate for which set we want to find the first
member. Correct usage of a DML command depends on a knowledge
of the
kinds of arguments required by that commaná. If one of the arguments
record), the application programmer must
program
is a data block (or the
be aware of whether
command
will use the data block's variables as
inputs or outputs.
command can use currency indicators and can change currency
An application programmer must know which currency
indicators. a DML
command can use and which currency ináicators
indicators
can
(and
the
the
of
alterations)
nature
.
alter
A

DML

Command

Status

execution

The

of a DML command always results in aO cQIuDang
command
through
status is an integer in the range from
Státjjá.
2 55.
The command status number is returned as the value of a host
A command status of O
language
choosing.
variable of the programmer's
A
completetL
means that the execution of a command was successfully
command status of 255 means that the data manipulation system tried to
by the command,
but that the
find a record occurrence indicated
does
Any
indicated record occurrence
not exist in the data base.
the
command
command
execute
did not
normally.
other
status means that
Generally speaking, this is caused by either faulty logic of the
programmer, a mis-statement of the command, an attempt to violate
or integrity constraints specified in the DDL, failure to
security
A
have a needed disk on-line, or a hardware malfunction.
detailed
command
Chapter
each
such
XVI.
description of
status error appears in
A

Comnand

Form

employed
for stating a DML command depends on
The MDBS System Specific Manual for a
the host language being used.
given host language shows the syntax for using DML within that host
The

precise syntax

language.
interfaces:
a)

There

are flour

categories of host language

DML
invocation
ith
direct
some
some
Data block oriented with indirect DML invocation (e.g.,
BASICS)
Record oriented
with direct DML invocation (e.g., C,
PASCALS,
PL/l)
Record
(e.g.,
oriented with indirect DML invocation
COBOLS)
PASCALS,

Data

block

FORTRANS,

major

oriented

BASICS)

(e. g.

some
some
some

some

does not allow program
host language is data block oriented
be
Invoking a
record oriented.
is said to
record types; otherwise,
DML
a DML
command directly
means that the host language allows
a
mnemonic
be
treated as
host language function. This is not
to

if it

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

indirect

allowed in the

arguments
case the
ED

where

case,

are

parameters
of
command has the

FFM

("arguments")

FFM

BACKGROUND

- II:

MANUAL

DML

MDBS

mnemonic and
For instance,

function.
following generic form:
a

MANUAL

OMS

associated
its the
direct

is a host language variable that receives the command status
value returned by the FFM function. In the indirect case, the FFM
command
has the following generic form:
where

where

returned

("FFM,arguments")

OMS

host

by the

language

DMS

function

variable that receives the command status
as a result of executing the FFM command.
String

Command
When

quotes is
string are

command is stated, the portion
called the command string.* Two
separated
by

a
a
a

Two

DML

of that command within
elements in a command

series of one or more blanks,
comma,
comma

consecutive

or
embedded
commas,

series of blanks.

without

intervening

nonblank character,

indicate a missing element in a command string (e.g., "X,,Y"). A
command string with one fewer than the permitted number of elements
is
rightmost
treated as if the
element is missing (e.g.r if
typically
then the rightmost element
three elements are permitted,
is regarded
The exception is when the omitted element
as missing from "X,Y").
name)
have been a
(or
should
data block name
program record type
immediately following a data item or record type name (e.g., with the
CRS command).
In this case, the data block name is assumed to be the
a"s
same
the record type or data item name (e.g.,
is a data item
name, then "X,Z" is equivalent
to "X,Z,Z").

command string
there are no
All elements are missingsomefromDMLa commands,
ifpermissible
quotes.
For
is
for
a command
command string to be
the entire it
string
or
'missing (e.g., FE'S). Some DML commands have no command string (e.g~
DBCLS)
elements
in the
an argument in
.

Command

Descriptions

As each DML command is described in the following chapters,
examples of the four different categories of command usage are
Even within a category,
provided.
the exact syntax for using a
*

host languages do not use double quotes ("").
by a host language is described in
convention employed
specific manual.
Some

(C)

1981

Micro

Data

Base Systems,

Inc.

The

its

exact
system
7

MDBS

DMS

MANUAL

- II:

BACKGROUND

MDBS

DMS

MANUAL

command

may differ slightly from one host language to another.
To
repeat, the 4pprQptiat£ áYátéw áHqgi£ig wanml ahQula Kq cQn,ajjlkQg £ql
The mnemonic,
the exact §YjjtÁx L£AjjjL£g Ky a gjj¿qjj jjQSt l@Dgjj4ge.
arguments,
currency indicators used, currency indicators changed, and
impact on the data base for each dml command are all independent of
the host language used.
All of these factors
are described in
subsequent
Thus the logic employed
chapters of the MDBS DMS Manual.
the data manipulation language
is the same, regardless of the
iii using
used.
languages
host

In presenting the DML commands
following conventions are used:

in subsequent Chapters,

the

host language variable for the command status
itío the name of a data item defined with the DDL
k9g
the name of a record type defined with the DDL
áeF=LL 'M_?, sgt=3 the names of sets áefined with the DDL
áLé@
the name of an area defined with the DDL
name
the
klk
of a data block (or program record type)
whose host
name of adata block (or program recordtype)
ihlk the
language variables provide input to a DML command
oklk the name of a data block (or program recordtype) whose host
language
variables receive output from a DML command
CEUI
current of run jjnit indicator
CQSsqtL
gurrent Qwñer of the indicated set
CMLáétL
current wember of the indicated set
CiLLiL
gurrent ijser-defined indicator i (lSiS255)
example, CU(7) denotes the current record for the
for
seventh
user-defined indicator
EQ

Although the description

for a DML command may refer to a data block,
understood
should
that a program record type takes the place of
data block for record-oriented
host languages.
be

Multiuser

Environment

In a multiuser environment, many run units can simultaneously
code.
They also
share the same copy of serially reentrant MDBS.DMS
Each
has
a
common page buffer area.
share
run unit
its own programa
region, which contains the application program and program buffers.
run unit's program buffers are used by MDBS.DMS
to manage the specific
Each
operations pertinent to that run unit.
run unit has its own
group of currency indicators, which are maintained independently of
other run units' currency indicators.
and actively lock various
record
run unit can passively
them
from being altered and/or read by other
occurrences to prevent
The rules
governing active and passive locking are
run units.
Also presented
Chapter
XIV.
in that chapter are the DML
presented in
and
commands
unlocking and for controlling the
for active locking
number of times (and the time interval length) that a DML command will
re-try to access a previously locked record.
A

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

- II:

MANUAL

BACKGROUND

MDBS

DMS

MANUAL

is a mechanism that allows an
Built-in to the multiuser MDBS.DMS
|appiication
both
binary and n-ary deadlock
developer to prevent
a
unit attempts an access that will create a
situations.
run
If
command
a
deadlock
status error to that effect is returned
situation,
command
DML
The run unit can
use
the access.
that
attempted
for the
deadlock
a
"
avoid
control
to
structure
information
in
its
this
situation.
F.

Protecting

Data

Base

Consistency against External Factors

base for processing,
a run unit opens a data
can specify
images
then
in the
case,
page
is
the
read-only processing.
If this
buffer region are always identical to their corresponding pages
page
Thus
data
base
in auxiliary memory).
in the data base (i.e.,
power
(e.g.,
consistency is not damaged by an abnormal interruption
of the run unit, which does not allow the run unit to close
failure)
the data base.

When

unit does not open the data base for read-only
Since
these
then the run unit can alter the data base.
region,
are necessarily buffered through the page buffer
alterations
to the
can happen that a page image in this region is not identical
An abnormal
interruption of the run
corresponding data base page.
unit could leave the data base inconsistent since the latest changes
to page images in main memory might not have been written to the data
When
base.
to open the data base
efforts
this occurs, subsequent
command
a
backup
15.
a
copy of the data base
status error of
yield
must be used in this event or the recovery utility furnished with
the
RTL
form of MDBS can be used to restore the data base.
There are two
of such a situation.
ways to drastically reduce the likelihood
a
If
processing,

run

(DBSAVE)
One method makes use of a DML command
that rewrites
changed page images into the data base.
This memory flushing command
be used wherever
and whenever desired in an application
can
program.
when a run unit abnormally terminates,
no changes have been made
then the data base
to the page images in memory since the last flush,
is consistent and error 15 will not occur in a subsequent attempt to
open the data base for processing.

all

If,

The
second
method
is available with the RTL form of MDBS in
single user situations.
allows the run unit to specify a page-image
via the PIED command.
This method of preserving consistency is
particularly useful changethe run unit carries out a complex kind of
At some moment
transaction that can
records on several pages.
during the execution of a complex transaction, some changed page image
may
have been rewritten
into the data base, while other altered images
may
An abnormal termination
reside in the buffer region.
at
would
data
base inconsistent.
the data base
leave the
this point
could be restored to its former state,
that existed at the start of
complex
then
data
base would be consistent and
the
transaction,
that
be
the interrupted transaction could
reinitiated. This is the purpose
of the page image

file

still

file.

(C)

1981

Micro Data Base Systems,

Inc.

Rev.

85A

MDBS

DMS

MANUAL

- II:

BACKGROUND

MOBS

DMS

MANUAL

juncture in a run unit, the TRBGN command can be used to
When
commit
a
the beginning of a complex
transaction.
(TRCOM)
command
the
complex
invoked,
transaction
entire
is
is
committed
changes made since TRBGN
to the data base.
was
All
last
(TRABT)
invoked
incorporated into the data base.
are
an abort
If
command
made
TRCOM,
is invoked instead of
no changes that were
since
TRBGN
was last invoked
are incorporated into the data base.
If the
unit abnormally terminates after a TRBGN and before a TRABT
run
or
TRCOM,
command
then a subsequent
to open the data base finds the data
base
in the state that existed at the beginning of the complex
With operating systems that do not dynamically allocate
transaction.
is important to create a page image file of sufficient
sizes,
file
Because
size.
posting is not meaningful in multiuser
page image
available
situations,
only for the single user version of MDBS.
isTRCOM
TRBGN,
TRABT
commands are described in Chapter
The PIED,
and
XVI
and in the MDBS RTL Manual.
At
declare

any

it
it

The foregoing mechanisms do not help in the
Selective RQ11r)a.ck.
hardware
event of a
failure that physically destroys a portion of the
data
base.
In this case the RTL transaction logging and recovery
The DML commands
are used to restore the data base.
for
facilities automatic
a
unit are
run
transaction
logging within
utilizing
Thé transaction log
in the
presented in Chapter XVI.
file (defined Either,
DDL
specification)
is distinct from the page-image
file.
both, or neither can be used by a run unit. In the event of AIEL type
termination,
in the data base (due to abnormal
of inconsistency
data entry, etc.) the transaction log file
hardware
failure, incorrect
automatically be applied to a data base back-up copy by using the
can
RTL
This recovery can be selective
recovery utility (RCV).
logged
transactions are used to recover.
desired, so that only certain
Bad transactions
data
incorrect
entry) can be discarded during
(e.g.,
the selective rollback.

about the MDBS recovery facilities
available
details
form of MDBS,
of
including its use for surveillance
activities, are presented in the KDBS RTL Manual.

Full

the

RTL

Rev.

85A

(C)

1981

Micro Data Base Systems,

with
users'

Inc.

MDBS

DMS

MOBS

MANUAL

III.
a.

DMS

MANUAL

FINDCOMMANDS

Overview

Manipulation t,anguage supports twenty-four
find
providing an application programmer with many ways to find a
Thé principal
objective of any find command is to make
given record.
a record the current
the current member of a set, the
owner of a set,
The found
some
the
of
combination
or
of these.
run unit,
current
is
program
record becomes one of the records that the application
can
mirrmt.1v interested in; as soon as a record becomes current,
be processed
in various ways by other DML commands. The find commands
main groups:
into
four
fall
TPíe

MDBS

Data

conunands,

Find

member

record via
find the

some

record
set:

that

is related to

given

owner

member,
first
next member,

last member,
prior member,a
member
member
member

which

with
particular sort key value,
with a particular value for some data item,
with the same value for a data item or sort
key as an already found member.

is first, next, last, or prior depends on the
set's
order specified in the DDL.
If the member
order is sorted, members can quickly be found on the basis
of their sort key values.

member
member

Find an owner record that is related to
record via some set:
find the

given

member

owner,
tirst
next owner,

last owner,
prior owner, a
owner
owner
owner

with
particular sort key value,
a
with
particular value for some data item,
the
same
with
value for a data item or sort
key as an already found owner.

Which

owner is first,
next, last, or prior depends on the
the owner order
set's owner order specified in the DDL.
If
be
found
sorted,
owners
can
quickly
is
on the basis of their
sort key values.

(C)

1981

Micro Data Base Systems,

Inc.

Rev.

85A

MDBS

DMS

MANUAL

III:

FIND

COMMANDS

MDBS

DMS

MANUAL

If a record type was declared in the DDL to have a calc key,
then any of its records can be found "out Qt the blue,"
without reference to any set in which
the record type
MDBS.DMS
participates.
finds the desired record on the
basis of a calc key value furnished by the application
IE "duplicate
program.
calc keys are allowed, then all
records with the same calc key value can be fQund.

The

application prograiu can sequentially find the records in
desired area or areas.
This refers to the physical
sequence of recorcts.

find command returns a command status of zero, then the
the command
record was found.
then the
status is 255,
If
through a find command does not exist in the data
record requested
The branching and control structure of a host language
base.
program
is typically based quite tieavily on the command status returned by the
various find commands used in the program.

If
desired

security

DDL
schema
conditions,
in a
as defined
command
when
a find
are
specification,
automatically
enforced
is
the user of an application
a
invoked.
program
perform
attempts
to
If
codes,
a
read
access
with
user's
that
inconsistent
the
"find"
is
command
status will result which indicates that the find was not
performed.

Data

Corutµnci

Detai18
EiM Ruplicate Record

EREK

Command

based

calc Xey

EJ2RK

and Arguments

FDRK,rec,iblk
Currency

Indicators

chanqpd:

cru

record having duplicate
calc key value

cruc

Description
JLE
invQkea:
ila AQÉ nUí wtm
Un cl]rrent Qt
same
occurrence
as
Find an
the current of run
of the
record type
matches the calc key value
unit, and having a calc key value that
a
is found,
held in iblk's variab1e(s).
record
If such This
command
becomes the new current of run unit.
is valid only
the record that is the current of run unit is an occurrence of
rec and rec has been ctefined (in the DDL) as having a calc key.
The
calc key value indicated by iblk must duplicate the calc key
status
value of the current of run unit, otherwise a command
unit
is
altered).
(the
of
run
results
current
not
error
:

= jj=

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

FIND

- III:

MANUAL

COMMANDS

MDBS

DMS

MANUAL

of FRK, followed by repeated use of FDRK, will find all
records of a given record type having the same calc key value.
an FDRR
The order in which these are found is not guaranteed.
If
when
of a
command
there are no more duplicatesbecomes
is given
calc key value, then the current of run unit
particular
does not have read
a user
command status is 255.
and
the
null
If
access to all data items that form the calc key, then a command
status error is returned.
khe currmt Qt
jjñit is FRK.
null jÚj£jj EDEE is irlyQkeg: fork
tjjlj
has exactly the same effect as

Use

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
recorá/indirect...

ED
ED
ED

= FDRK
= DMS
= FDRK
= DMSD

Eind

EU
Commaná

("rec,iblk")

("FDRK,rec,iblk")
("rec", iblk)
("FDRK,rec",

Eirst

iblk)

Member

and Arguments

FFM,set-l
Currency

Indicators

IISM:

Chajjgeg:

CO(set-l)

member
CM(set-l)c
first
<——first member

CRU

(set-l)
(set-l)

Description

member connected
to the current owner of set—l becomes
first
member
of set-l and the current of the run unit.
the current
Which member is
depends
on the set-l member order, as
first
DDL.
owner of set-l has no
specified with thecommand If the current
member,
255,
the
then
the current of run unit
status is
becomes null, and the current member of set—l is null.
If a user
does not have read access to set-l, then a command status

The

error

is returned.

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

(C)

1981

Micro

ED
ED
ED

=
=
=
=

FEM
dms

ffm
DMS

Data

("set-l")
("set-l")

("FFM,set-l")
("FFM,set-l")

Base Systems,

Inc.

MDBS

DKS

MANUAL

- III:

EEQ

Eind

Command

FIND

Eirst

COMMANDS

MDBS

DMS

MANUAL

Qwner

EEQ

and Arguments

FFO,set-l
Indicatprs

Currency
u§£g:

ChaAgeg:

CM(set-l)

CO(set-l)<——£irst

c——first

CRU

Description
The

owner
owner

(set-l)
(set-l)

first

owner connected
to the current member of set—l becomes
owner
of set—l and the current of the run unit.
Which
depends
owner
on the
owner
order, as
is
member
has no
DDL.
with
the
the
of
current
specified
owner, then the command status is255, the current of run unit is
and the current owner of set-l is null.
a user
does not
null,
have read access
then a command status
to
is

the current

first

Command

...
...
...
record/indirect...
Eiñd

Command

ED
ED
ED

=
=
=
=

FFO
OMS
FFO
OMS

("set-l")
("set-l")

("FFO,set-l")
("FFO,set-l")

Eirst Sequential record

EES

and Arguments

FFS,area
Currency

error

Usage

block/direct
block/indirect
record/áirect

EES

set-l

set-l,

returned.

Examples

set-l

(the area argument

is optional)

Indicators

UáC9:

ch@ng£g:

none

first

cru(

record in area

Description
The record that is physically first within the indicated
area
becomes the current of run unit.
I: the indicated area has no
records, then current of run unit becomes null and the command
status is 255. When the area argument is omitted, FFS operates
on the main area and then on all subsequent
areas until a record
main
have
data recordsA
may
no
the
found
area
(i.e.,
is
E

allows a user with any access code to find the physically
record of an area regardless of the access codes of that
first
However,
the user will be unable to
record's record type.
FFS

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

FIND

- III:

MANUAL

DMS

COMMANDS

MDBS

DMS

MANUAL

retrieve data from the found record or modify its data unless the
user's access authorization permits read or write access to
occurrences oil the record type.
Examples

Command

block/direct
block/indirect
recorá/direct

Usage
ED

...
...
...

record/indirect...

ED
ED

=
=
=
=

Eind

ELM

Command

("area")
("FFS,area")
("area")
("FFS,area")

FFS
DMS
FPS
DMS

Last

or
or
or
or

ED
ED
ED
ED

=
=
=
=

FFS
DMS
FFS
DMS

")
("FE'S")
")
("
("FFS")

EIM

Member

and Arguments

FLM,set-l
Indicators

Currency

CO(set-l)

tlsé9:

ChgRgQd:

CM(set-l)
CRU

(

last

member

last member

(set-l)
(set-l)

Description
The

last member connected to the current owner of set-l becomes
the current member of set-l and the current of the run unit.
which member is last depends on the set-l member order, as
with the DDL.
the current owner of set-l has no
specified
member,
then the command status is 255, the current of run unit
a
becomes null and the current member of set—l becomes null.
If
does
have
command
a
read access to set-l, then
status
not
user
error is returned.

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

ED
ED
ED
ED

=
=
=
=

FLM
DMS
FLM
DMS

Eirid

ELQ

Command

("set-l")
("set-l")

("FLM,set-l")
("FLM,set-l")

Last Qwner

ELQ

and Arguments

FLO,set-l
Currency

Indicators

Ué9:
(C)

CM(set-l)
1981

Micro

Cbanged:

CO(set-lA——last

CRU

Data

Base Systems,

<———last

Inc.

owner
owner

(set-l)
(set-l)
15

MDBS

MANUAL

DMS

- III:

FIND

COMMANDS

MDBS

DMS

MANUAL

Description
The

last owner connected to the current member of set—l becomes
the current owner of set—l and the current of the run unit.
which owner is last depends on the set-l owner order,
as
member
has
with
the
the
of
no
current
ddl.
specified
If
set-l
owner, then the command status is 255, the current of run unit
becomes null, and the current owner of set-l becomes null.
If a
user does not have read access to set-l, then a command status
error is returned.
of

Examples

Command

Usage

block/áirect
block/indirect
record/direct

...
...
...
record/ináirect...
Eind

MI
Command

ED
ED
ED

= FLO
= DMS
= FLO
= DMS

Member

("set-l")
("set-l")

("FLO,set-l")
("FLO,set-l")

based

on data

Item

and Arguments

FMI,item,set-l,iblk
Currency

Indicators
CO(set-1)

tl§eg:

ch!angQg:

CM(set-l)

first

having

CRU

member(set-l)
data item value

Description

The
member record connected
to the current owner of set-l,
and having a value for itm that matches
the value of
becomes the current member of set—l.
also becomes the current
of run unit. Iii there are two or more member records for the
current owner of set-l, all having the iblk value for itin, which
depends on the set-l member order.
The command FNMI
one is
can be used to find the next member having the same ib1k value

first

iblk,

first

for itm.

host languagevariableof iblkmust be consistent in size and
type with the itm data item (as specified in the DDL).
If the
value of iblk's host language variable does not match the itm
value of any member record connected to the current owner of set—
then the command status is 255, the current member of set—l
I,
becomes
becomes
null, and the current of runa unit does
null. A
command status error is returned
have
read
not
user
access to both itm and set-l.
The

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

Examples

Command

COMMANDS

MDBS

DMS

MANUAL

Usage
ED

block/direct
block/indirect
recorá/direct

...
...
...
record/indirect...
Eind

Command

FIND

- III:

MANUAL

=
=
=
=

ED
ED
ED

FMI
DMS
FMI
DMSD

("itm,set-l,iblk")
("FMI,itm,set-l,iblk")
("itm,set-l",iblk)
("FMI,itm,set-l",iblk)

based

Member

EMSK

Sort Key

and Arguments

FMSK,set-l,iblk
Currency

Indicators
Cbanged:

CO(set-l)

QSé9:

CM(set-l)

first

CRU

having

Description

member

(set-l)

sort key value

member record that has the sort key value of iblk
first
connected to the current owner of set—l becomes
that is member
of set—l.
also becomes the current of the
current
It
a sorted member order.
have
must
unit.
Set-l
The

member records for the current
key value, the one that is

several
If
same sort

sort-clause

and

the
run

owner of set-l have the
depends
on the DDL
member order (either

first

the set-l
specification
for The
IMMATERIAL).
host language

variable(s) of
or
key
contain
there are
the
desired
value.
sort
iblk
If
key value
the
items
key,
the
data
sort
sort
for
set-l
multiple must be
for iblk
consistent with the sequence, types and sizes of
RECORD-TYPE
the data items in the DDL sort key specification.
If
the
key,
then
is part of
the name of the desired record type
sort
must appear as part of the iblk sort key value; the host language
variable holding the record type name must be consistent with a
string data item of 8 bytes in size.

LIFO,

FIFO,
must

current owner
If thematches
the sort
value

of the set-l has no member whose sort key
key value of iblk, then the command status
whose
255.
The
member
sort key value immediately follows the
is
becomes
key
the current member of set-l, as well
value
iblk sort
The exceptions are when the current
as the current of run unit.
owner of set-l has no members or when iblk's sort key value is
greater than the sort key value of the last member of set—l's
current owner.
In these cases, the current member of set—l
becomes null and the current of run unit becomes null.
command
access to
key.

(C)

status error

set-l

1981

and

Micro

all

isdatareturned

Data

items that

Base Systems,

does not have read
user
make
up the member sort

Inc.

MDBS

DMS

Examples

MANUAL

- III:

Command

COMMANDS

MDBS

DMS

MANUAL

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

=
=
=
=

ED
ED
ED

("set-1,iblk")
("FMSK,set-l,iblk")
("set-l",iblk)

FMSK
DMS
FMSK
DMSD

Eind

ENM

Command

FIND

("FMSK,set-l",iblk)

Member

and Arguments

FNM,set-1

Indicators

Currency
Yáé9:

CO(set-l)
CM(set-l)

chang£g:

CM(set-l)<——next member(set-l)
CRU
<µ——ñext member(set-l)

Description
the

ID£¡Dbqt oE set=l is ñQt null wheri ENÉI is inyQk£sj:
gjjrr£nt
member record (connected
to the current owner of set-l)
member
of set-l becomes the new current
the current
following
which
becomes
the current of run unit.
member of set—l.
also
member record is Itlogically next depends
member
on the set-l
order, as specified with the ddl. If the current member of set-l
current owner of set-l, then FNM
is the last member for the When
cannot find a next member.
there is no next member for the
command
of
the
owner
status is 255, the current
current
set-l,
member of set-l becomes null, and the current of run unit becomes
A conunand status
error is returned if a user does not have
null.
read

If
The

access

to set—l.

tjjQ current
If
has exactly the
Examples

Command

IDQIDkQK
same

is null

when enei

FFM.

injLQkeg:

fnm

Base Systems,

Inc.

Usage

block/áirect
block/indirect
record/direct

...
...
...
record/ináirect...

Qt set=1
effect as

(C)

ED
ED
ED

=
=
=
=

FNM
DMS
FNM
DMS

("set-l")
("FNM,set-l")
("set-l")

("FNM,set-1")

1981

Micro

Data

MDBS

DMS

- III:

MANUAL

FIND

COMMANDS

MDBS

DMS

MANUAL

Eind Bext Member based on data 1tem
Command

and Arguments

FNMI,itm,set-l,iblk
Currency

Indicators
m~

sI=a:

CO(set-l)

charlqed:

CM(set-1)

member(set-l)
CM(set-l)'
CO(set-l)<——first
owner
CRU

(C)

1981

Micro

Data

Base Systems,

t——first

Inc.

owner

MDBS

DMS

MANUAL

ASSIGNMENT

- VI:

COMMANDS

MDBS

DMS

MANUAL

Description
Set the current member of set—l to be the same as the current
member of set-2.
This command is valid only
set-l and set-2
have the same member record type(s).
The
owner
of the new
first
member
becomes
of
set—l
the
new
owner
of set—l
current
current
and the current of run unit.
the
member
new
of
current
set-l
has no owners via set—l, then If
the current owner oF set—l becomes
and a command status
null, the current of run a unit becomes
null
does
have
of 255 is returned.
read access to both
not
user
If
and
a
command
set-2,
then
status
set-l
error is returned and no
change.
indicators
currency

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

SMM
OMS
SMM
DMS

=
=
=
=

ED
ED
ED

Command

("SMM,set-l,set-2")

Member

Set

SMN

("set-l,set-2")
("SMM,set-l,set-2")
("set-l,set-2")
to NUl

SMN

and Arguments

SMN,set-1

Indicators

Currency
'tlsesk

ch!angesj:

none

Description

The cur"rent

member

set-l is unaffected.
1, then the

becomes
user does

set-l
a

current member of
status error is returned.

Examples

Command

...
...
...
record/indirect...

ED
ED
ED

Set

Command

set-l

null

The current
null.
have read

not

does not

owner of
access to setchange and a command

Usage

block/direct
block/indirect
record/direct
SKI

CM(set-l)(

= SMN
= DNIS
= SMN
= DMS

Member

("set-l")
("SMN,set-l")
("set-l")

("SMN,set-l")

based

SMQ

on Qwner

and Arguments

SMO,set-l,set-2
Currency

Indicators

Usésl:

Ch@ng£d:

CO(set-2)

CO(set-2)
CM(set-l)<
CO(set-lfé——first
owner
CRU

(C)

1981

first

Micro

Data

owner

Base Systems,

Inc.

"
'

MDBS

OMS

- VI:

MANUAL

ASSIGNL·1ENT

COL4MANDS

MDBS

DblS

MANUAL

Description
Set the current member of set-l to be the same as the current
This command is valid only i£ the member recora
owner of set-2.
type(s) for set-l is the same as the owner record type(s) for
member of set-l
set-2. The first owner of the new current
becomes
the new current owner of set-l and the current of run
the new current member of set-l has no owners via set
un
the current owner of set-l becomes null, the current
set"l, then becomes
a
and the command status is 255.
of run unit
null,
command
a
and
have
read
set-2, then
user cícjés not
access to set-l
status error is returned and no currency indicators change.
Examples of Command
Usage

it. If

block/direct

.
block/indirect ...
..
record/direct
...
recorá/ináirect.. .

áet

Command

Ell
£0
ED
ED

t1eInber

= SMO
= Dl4S
= Si·1O
= deis

("set-l,set-2")
("SbiO,set-l,set-2")
("set-l,set-2")
("SbiO,set-l,set-2")

baseá

on 9ser

indicator

and Arguments

SMU,set-l,
Currency

iblk

Indicators

g=d:

CU(i)

rh¶nq@d·

Cl4(set-l)<
CO(set-l)

CRU

CU(i)

first

f irst

owner
owner

Description
set the current member of set-l to be the same as the current
record of a user-defined
indicator. The value of the host
language variable for iblk determines which one of the userThe host
defined indicators is involved in this command.
language
variable must be consistent with an unsiqned data item
The variable's value must be an
one byte in size.
that is between
1 and 255, inclusive.
The
integer
first owner of the new
current member Qí set~l becomes the new current owner of set-l
and the current of run unit.
IE the new current member has no
via
owner of set-l becomes null,
then
the
current
owners
set"l,
the current of run unit become null, and the commaná status is
The AUI command (Chapter
255.
XI) is employed to allocate userdefined ind icators.
Examples

Command

Usage

block/direct

block/indirect ...
...
record/direct
record/indirect.

(C)

1981

.... .

Micro

ED
ED
ED
EC)

= SF4U
= DF4S
= SHU
= DI4SD

Data

("set-l,iblk")
("sMU,set-l,iblk")
("set-l",iblk)

("SMU,set-l" ,ib1k)

Base Systems,

Inc.

Rev.

85A

MDBS

DMS

MANUAL

- VI:

ASSIGN1·!ENT

COt.1l.!ANDS

MDBS

DEIS

áet Qwner based on Current of run unit

SQC

ComüanCi

MANUAL

SQC

and Arguments

SOC,set-l
Indicators

Currency

ilsm:

ch(anqpa:

cru

CO(set-l)<
CM(set-l)<
CRU

CRU

first
first

member
member

Description
The record that is the current
of run unit becoir,es the new
The
member connected to the new
current owner of set~1.
first
becomes
the new current meir.ber OF set-l
current owner of set~l
and the current of run unit.
the current owner of set—l has
then the current of run unit becomes null,
ñQ members via set-l,
the current member of set-l becomes null, and a command status of
255
is returned. If the user dQes not have read access to set-l,
a command status error
is teturned and no currency ináicators are

changed.

Examples

Command

Usage

block/direct

block/indirect ...
...
record/direct
...
record/ináirect...

EC
ED
EQ

= SOC
= DMS
= SOC
= OMS

("set-l")
("SOC,set-l")
("set-l")
("SOC,set-l")

aet Qwner to current of run unit

sqe
Command

(Exception)

SQE

and Mguments

SOE,set-l
Currency

Indicators

ch¡nq?r1:

cru

CO(set-l)<

CRU

Description
The record that is the current
of run unit becomes the new
The
of run unit remains
owner of set~l.
current
current
a
have
read
unchanged.
does
not
access to set-l, the
user
change
and
command status error
a
does
of
owner
current
not
set-l
is returned.
the record type of the current of run unit is
not an owner OÍ set~1, then a command status error is returned
and thecurrent ownerof set-l isunchanged.
acurrent member
and
by
indicated
the
the
record
current of run
for set-l exists
member
is
through
connected
not
to that
unit
set-l, then a
command
status error of 12 is returned.

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

Examples

ASSIGNMENT

- VI:

MANUAL

Command

MDBS

DMS

MANUAL

Usage

block/direct
block/indirect
record/direct

...
...
...
recorá/indirect...

ED
ED
ED

=
=
=
=

SOE
DMS
SOE
DMS

("set-l")
("SOE,set-l")
("set-l")

("SOE,set-l")

Set Qwner based

=
Command

COMMANDS

SCM

Member

and Arguments

SOM,set-l,set-2
Currency

Indicators

Uéd:

ch@ng£g:

CM(set-2)

CM(set-2)
CO(set-l) (
member
CM(set-l)<——first
CRU
<——first member

Description
Set the current owner of set—l to be the same as the current
member of set-2.
This command is valid only if the owner record
type(s) for set-l is the same as the member record type(s) for
The
set—2.
member of the new current
of set—l
owner
firstcurrent
becomes the new
member of set—l and the current of run
the new current owner of set—l has no members via set
unit. If
then
the current member of set—l becomes null, the current
set—l,
a
of run unit becomes null and the command status is 255.
If
does
have
set—l
command
read access to
andset—2, thena
not
user
status error is returned and no currency indicators change.
Examples

Command

Usage

block/áirect
block/indirect
recorá/áirect

...
...
...
record/indirect...
SQN

ED
ED
ED

=
=
=
=

Set

Command

SOM
DMS
SOM
DMS

("$et-l,set-2")
("SOM,set-l,set-2")
("set-l,set-2")
("SOM,set-l,set-2")

Qwner

to Null

SQN

and Arguments

SON,set-l
Currency

Indicators

tlseCk

(C)

none

1981

chan!g£g:

Micro

CO(set-l)<

Data Base Systems,

Inc.

null

MDBS

DMS

MANUAL

- VI:

ASSIGNMENT

COMMANDS

MDBS

DMS

MANUAL

Description
The current owner of set—l becomes
null. The current member of
does not have read access to
a user
set—l is unaffected.
setIf
then the current owner of set-l does not change and a command
l,status
error is returned.
Examples

Command

block/direct
block/indirect
record/direct

Usage
ED

.G.

...
...
record/indirect...
SQQ

ED
ED

SON
DMS
SON
DMS

("set-l")
("set-l")

("SON,set-l")
("SON,set-l")

Qwner based

Set

Command

=
=
=
=

on Qwner

SQQ

and Arguments

SQO,set-l,set-2
Currency

Indicators

Usési:

CO(set-2)

cbánmk

Description
Set the current
owner of set-2.

CO(set-2)
CO(set-l)<
member
CM(set-l)<——first
CRU
<——Uirst member

of set-l to be the same as the current
This command is valid only
set-l and set-2
The
have the same owner record type(s).
member of the new
first
current owner of set—l becomes the new current member of set—l
and the current of run unit.
If the new current owner of set-l
has no members
via set-l, then the current member of set-l
becomes null, the current of run unit becomes null, and a command
a user does not have
read access
status OE 255 is returned.
If
a
and
then
command
set—2,
both
status
to
error is returned
set-l
change.
and no currency indicators

Examples

Command

block/direct
block/indirect
record/direct

owner

Usage
ED

...
...
...

record/indirect...

(C)

ED
ED
ED

=
=
=
=

SQQ
OMS
SQQ
DMS

("set-l,set-2")
("SOO,set-l,set-2")
("set-l,set-2")
("SOO,set-l,set-2")

1981

Micro

Data

Base Systems,

Inc.

MDBS

- VI:

MANUAL

DMS

SC9I

Set

Command

ASSIGNMENT

Qwner based

COMMANDS

on Rser

MDBS

DMS

indicator

MANUAL

SC9I

and Arguments

SOU,set-l,iblk
Indicators

Currency
tIaqg:

CU(i)

chang£g:

cU(i)
CO(set-l)<
member
CM(set-l)<——first
CRU
<——-first member

Description
Set the current owner of set-l to be the same as the current
record of a user-defined
indicator. The value of the host
language variable for ib1k determines which one of the userThe host
defined indicators is involved in this command.
be
unsigned
data
an
language
item
variable must
consistent with
be
The
must
an
in
size.
value
one
byte
variable's
that is
The
member of the
and 255, inclusive.
integer between
first
new
current owner of set—l becomes the new current member of set1 and the
current of run unit. IE the new current owner has no
members via set-l, then the current member of set-l becomes null,
the current of run unit becomes null, and the command status is
255.
The AUI command (Chapter
XI) is employed to allocate userdefined indicators.

Examples

Command

Usage

block/direct
block/indirect
recorá/Urect

...
...
...
record/indirect...
am

Set

Command

ED
ED
ED

Aser

= SOU
= DMS
= SOU
= DMSD

("set-l,iblk")
("SOU,set-l,iblk")
("set-l",iblk)

indicator

("SOU,set-l",iblk)
to Current of run unit

snc

and Arguments

SUC,ib1k
Currency

Indicators

U,áési:

chai]ggsj:

cru

CU(i)<

cru

Description
Set the current
as the current

recordof a user-defined
indicator to be the same
The
of run unit.
value of the host language
one of the user-defined
variable for iblk determines which
The host language
indicatorsmustis beinvolved in this command.
with
consistent
unsigned
data item that is
an
variable
The variable's value must
be an integer
one byte in size.
between l and 255, inclusive. The AUI command (Chapter XI) is
employed

(C)

to allocate

user-defined indicators.

1981

Data

Micro

Base Systems,

Inc.

MDBS

DMS

MANUAL

Examples

Command

COMMANDS

MDBS

DMS

MANUAL

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...
Set

am
Command

ASSIGNMENT

VI:

ED
ED
ED

=
=
=
=

sue
DMS

sue
DMSD

("iblk")
("SUC,iblk")
(iblk)

("SUC",iblk)

indicator

tIser

Member

SñM

and Arguments

SUM,set-l,iblk
Indicators

Currency

CM(set-l)

tIs£g:

ch4ngesj:

CU(i)

(

CM(set-1)

Description
Set the current recordof auser-defined
indicator to be the same
The value of the host language
as the current member of set-l.
one of the user-defined
variable for ib1k determines which
command.
The host language
involved
in
this
indicatorsmustis be
with
unsigned
data item that is
an
consistent
variable
The variable's value must
be an integer
one byte in size.
The AUI command (Chapter XI) is
and 255, inclusive.
between
employed to allocate user-defined indicators.

Iii

read access to set—l, no currency
user does not have
indicator changes and a command status error is returned.
Examples

Command

Usage

b
ED

block/direct
block/ináirect
record/direct

...
...
...
record/indirect...
Set

SUN

Command

ED
ED
ED

=
=
=
=

tIser

SUM
OMS
SUM
DMSD

("set-l,iblk")
("SU"M,set-l,iblk")
("set-l",iblk)

("SUM,set-l",iblk)

indicator

to Núll

SñN

and Arguments

SUN,iblk
Currency

Indicators

IISU:

char]geg:

none

(C)

cwm

1981

Micro

null

oata

Base Systems,

Inc.

MDBS

DMS

ASSIGNMENT

- VI:

MANUAL

COMMANDS

MDBS

DMS

MANUAL

Description
Set the current record of a user-defined indicator to be null.
The value of the host language variable for iblk determines which
one of the user-defined indicators
is involved in this command.
The host language variable must be consistent
with an unsigned
The variable's value must be
data item that is one byte in size.
and 255,
between
an integer
inclusive. The AUI command
XI) is employed to allocate user-defined indicators.
(Chapter

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

SñQ

ED
ED
ED

=
=
=
=

Set User

Command

SUN
DMS
SUN
DMSD

("iblk")
("SUN,iblk")
(iblk)

("SUN",iblk)

indicator

SñQ

to Qwner

and Arguments

SUO,set-l,iblk
Indicators

Currency
y§£sj:

CO(set-l)

ch!ang£g:

CU(i)l

CO(set-l)

Description
Set the current recordof a user-defined indicator to be the same
The value oÍl the host language
as the current owner of set—l.
determines
which
one of the user-defined
variable for iblk
command.
The host language
involved
in this
indicatorsmustis be
with
an
consistent
unsigned
data item that is
variable
The variable's value must
be an integer
one byte in size.
The AUI command (Chapter XI) is
between
and 255, inclusive.
employed to allocate user-defined indicators.

a
user does
If
indicator changes

Examples

Command

not have
and

...
...
...
record/ináirect...

1981

command

=
=
=
=

SUO
OMS
SUD
DMSD

Usage

block/direct
block/indirect
record/direct

(C)

read access to set—l, no currency
status error is returned.

Micro

EC
ED
ED

Data

("set-l,iblk")
("set-l",iblk)

("SUO,set-l,iblk")
("SUO,set-l",iblk)

Base Systems,

Inc.

MDBS

DMS

MANUAL

Set

Command

ASSIGNMENT

- VI:

tjser indicator

COMMANDS

MDBS

DMS

to tlser indicator

MANUAL

sam

and Arguments

SUU,iblk
Currency

Indicators

tiseSk

cU(j)

changQg:

cU(i)1g-—cU(j)

Description
Two host language variables, say i and jr are defined for ib1k.
Each must be consistent
with an unsigned data item that is one
Each must have an integer value between
and 255,
byte in size.
command
sets the current record of a userinclusive. This
defined indicator (determined by i's value) to be the sanie as the
(determined by
current record of another user-defined indicator
The
command
(Chapter
XI)
employed
AUI
is
to allocate
j's value).
user-defined indicators.

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

(C)

ED
ED
ED

=
=
=
=

SUU
OMS
SUU
DMSD

("iblk")
(iblk)

("SUU,iblk")
("SUU",iblk)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

MDBS

VII.
A.

DMS

MANUAL

CREATIONCOMMANDS

Overview
There

DML
commands that can be used to create a
are two MOBS
One
record occurrence.
forces MDBS.DMS
to create the record in a
command
a
by
indicated
desired
argument. However,
area,
particular
was not assigned to in the
the record cannot be forced into an area
DDL specification.
This command cannot be used with a record type that
has a calc key.

allows MDBS.DMS
to place the new
a
record in any area
to in the DDL specification.
If
mode
CALC
the
was
record in
defined for
or clustering
record location
the DDL, then MDBS.DMS physically positions the new record
accordingly.
In the case of clustering, the new member (owner) record
member) of the
is clusteredon the basisof the current owner (current
clause
(as
specified in
set indicated in that record type's clustering
the DDL).
The

other

command
was assigned

creation

Data to be stored in the new record is transferred from the host
language
variables of a data block (or program record type) in to the
base.
The types, sizes and sequence
data
of these variables must be
and
sequences
consistent with the types, sizes
of the record type's
data items as specified in the DDL. The values of these variables
must conform
to the feasibility ranges specified for the record type's
data items in the DDL specification.
they do not, the record is
not created and a command status error is returned.
Data compression
and encryption are automatic, where applicable.

the user has write access to all
record can be created only
data items of that recordtype,
write access to the area in which that
record is to be created, and write access to all sets in which that
record type participates as an automatic owner or member.
In the
event that there is no space left, in the area(s)
in which MDBS.DMS is
permitted to create an occurrence
of the record type, a command status
error to that effect is returned.

pointerIf

(C)

data base has multiple areas, then all areas which permit
indices must be on-line during record creation.
a

1981

Micro

Data

Base Systems,

Inc.

Rev.

83A

9DBS

DMS

Comnand

MANUAL

- VII:

COMMANDS

MDBS

DMS

MANUAL

Details

Create

Command

CREATION

Record

in Area

CEA

and Arguments

CRA,rec,area,iblk
Currency

Indicators

tI£esj:

...if

rec is AUTO
of set

member

ch!aRgesj:

cru(

...if

is AUTO
of set

CO(autoset)

...ifownerrec ofis set

AUTO

rec

member

newly

CM(autoset)

created record

<——newly

...ifownerrec ofis set

created record

AUTO

CM(autoset)

CO(autosetR—-newly

created record

Description

occurrence
of the record type rec is created in the indicated
area. The values of the host language variables for iblk are
The sequence,,
stored into that record occurrence.
types, and
sizes of host lanquage variables defined for iblk must correspond
to the sequence,
types, and sizes of data items defined for rec
DDL
in the
specification. The values of the variables must
conform to
ranges specified for the record type's
data items. feasibility
they do not, a command status error is returned,
If
the record is not created, and no currency indicators change.
An

physical placement of the newly created record is consistent
for rec (either clustered or systemwith the DDL specification
A
a
determined).
record with
caíc key cannot be created with CRA.
a
record with CRA, a user must have write
In order to create
access to rec, to the area in which the record is to be created,
and to
type participates as an
all sets in which the a record
does not have this security
user
automatic owner or member.
If
clearance, a command status error is returned, the record is not
created, and no currency indicator is changed.
The

rec has been declared
If
newly created record is

to be the

member

of a set, then the
connected
to the current
automatically
the
new
the
becomes
and
record
current member
owner of that set
The
according
place
connection takes
to the member
of that set.
(SORTED,
DDL
the member
the
FIFO,
etc.).
specified
with
order
If
£or
NEXT,
record
new
the
then
the
order
set is
is connected
set's
immediately
the
inserted)
current
after
(i.e., logically
member,
member.
the
record
no
there
current
is insertedas
is
If
For PRIOR member order, the new record is
the first member.
before the set's current member.
logically connecteá immediately
member,
the
no
current
there
recordis insertedas the last
is
If
AUTO

member.

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

COMMANDS

CREATION

- VII:

MANUAL

MDBS

DMS

MANUAL

rec has been declared to be the AUTO owner of a set, then the
If
newly created record is automatically connected to the current
and the new record becomes the current owner
member
of that set
of that set. The connection occurs according to the set's owner
order, as specified with the DDL (SORTED, LIFO, NEXT, etc.). If
the owner order for the set is NEXT (or PRIOR), then the new
immediately after (or before) the
record is logically connected
there is no current owner, the record is
set's current owner.
If
the
inserted as
first (last) owner.
of

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

=
=
=
=

ED
ED
ED

Create

CBS

Command

CRA
DMS
CRA
DMSD

("rec,area,iblk")
("CRA,rec,area,iblk")
("rec,area",iblk)
("CRA,rec,area",iblk)

Record

and

CRS

Store

and Arguments

CRS,rec,ib1k
Indicators

Currency
g,aQg:

...if

rec is AUTO
of set
CO(autoset)

member

...ifownerrec ofis set

AUTO

CM(autoset)

changeg:

CRU<——newly

...if

is AUTO
of set

rec

member

CM(autoset)

created record

<—-newly

...ifownerrec ofis set

created record

AUTO

CO(autoset)<——newly

created record

Description

of the record type rec is created in a permissible
values of the host language variables for ib1k are
The sequence,
stored into that record occurrence.
types, and
sizes oft host language variables defined for ib1k must correspond
to the sequence,
types, and sizes of data items defined for rec
must
in the DDL specification. The values of the variables
conform to feasibility ranges specified for the record type's
data items.
they do not, a command status error is returned,
If
the record is not created, and no currency indicators change.
An

occurrence
area. The

The

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

as an

automatic

CREATION

- VII:
owner

security clearance,
record is not created,

or member.

COMMANDS

to be the

DMS

user does not have
error is returned,
indicator is changed.

command status
and no currency

rec has been declared
If
newly created record is

MDBS

AUTO

member

MANUAL

this

the

set, then the

connected to the current
automatically
new
becomes
member

of that set and the
record
the current
of that set. The connection takes place according to the member
FIFO, etc.).
order specified with the ddl (SORTED,
If the member
order for the set is NEXT, then the new record is connected
(i.e., logically inserted) immediately
after the set's current
member, the record is inserted as
member.
no
there
current
is
If
For PRIOR member order, the new record is
the first member.
connected
immediately before the set's current member.
logically
If there is no current member, the record is inserted as the last

owner

member.

rec has been declared to be the
If
newly created record is automatically

of a set, then the
connected to the current
member of that set and the new record becomes the current owner
of that set. The connection occurs according to the set's owner
order, as specified with the DDL (SORTED, LIFO, NEXT, etc.). If
the owner order for the set is NEXT (or PRIOR), then the new
immediately af ter (or before) the
record is logically connected
set's current owner.
there is no current owner, the record is
If
the
inserted as
f irst (last) owner.
AUTO

Examples

Command

block/direct
block/indirect
recorá/direct
record/indirect.

owner

Usage
ED

...
.. .
.....

(C)

ED
ED
ED

=
=
=
=

CRS
DMS
CRS
DMSD

("rec,iblk")

("CRS,rec,ib1k")
("rec",ib1k)
("CRS,rec",iblk)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

MDBS

VIII.

DMS

MANUAL

CONNECTCOMMANDS

Overview

connect commands allow two record occurrences to be
connected to
other through a set relationship. The record that
connected to the current owner of
is the current of runtheunit becomes
member
indicated
of an indicated set, depending
an
set or
current
When
a record
on which connect command is used.
is connected as a
member (owner),
is inserted into a set relationship on the basis of
that set's member (owner) order. During record connection, all areas
allowing pointer indices must be on-line.
The

MDBS

each

the manual insertion
are used to accomplish
This
is
set
into
relationship.
typically needed in
cases where a)
set insertion has been defined for a set's owner
has been declared in the
or member record type, b) AUTO set insertion
DDL
and
member
is
owner
record
of an N: m set, c)
both
the
types
for
a
a
or
owner
record
(perhaps,
to
to
reconnect
different
necessary
has been disconnected.
member record) after
Connection

commands

record

a
MANUAL

creation of a member (owner) record does
not automatically connect
to an owner (member) record of the set.
and when such a connection is desired,
is accomplished with a
If
command.
second
case, suppose that a member (owner)
connect
In the
N:
an
record of
set is created. It is automatically connected to one
(member)
owner
record.
to additional
is desired to connect
If
command is used.
In the third case,
owner (member) records, a connect
is sometimes important to disconnect a member (owner) from an owner
(member)
and later connect that member (owner)
to the same or a difRegardless
whether
ferent owner (member).
of
there is AUTO or MANUAL
accomplished
command.
by a connect
set insertion, this reconnection is
In the

MANUAL

case,

the

A command
The integrity of all set relationships
i.s preserved.
an attempt is made to connect a member with
status error results
more than one owner in a l: or I: N set, to connect an owner with more
than one member of l: or N: set, or to connect a member with an
owner to which
is already connected.

l ll

If
connect

user does not have write access to the set involved in a
command,
the connection does not take place and a command
status error to that effect is returned.

B.
IMS

Command

Details
Insert

Command

Member

into Set

IMS

and Arguments

1MS,set-l
Currency
Indicators
E!áM:
CO(set-l)

Changgg:

CRU

(C)

1981

Micro

Data

CM(set-l)<

Base Systems,

Inc.

CRU

Rev.

83A

MDBS

DMS

MANUAL

- VIII:

CONNECT

COMMANDS

MDBS

DMS

MANUAL

Description
The record that is current of run unit becomes connected to the
current owner of set—l. This new member for the current owner of
set-l ismade the current member of set-l. The insertionof this
member record among the existing member records, connected
new
to
the current owner of set—l, is made in accordance with the member
order declared for set-l in the DDL specification.
If the member
order is NEXT (or PRIOR) then the new member is logically
inserted after (or before) the set's current member;
the set
has no current member,
the record is logically inserted as the
first (or last) member.

multiple owners can exist for this new member, the record that
is the current owner is logically inserted into those owners
according to the owner order of set-l. The exception is
the
owner order is NEXT (or PRIOR), in which case the record that is
the current owner becomes the logically first (or last) owner of
the set's new current member.

of run unit must be an occurrence of a record type
of set-l. A user must have write access to setthat is
a member record to an owner
connect
record.
l, in order to

The

current

amember

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
recorá/indirect...

ED
ED
ED

=
=
=
=

IMS
OMS
IMS
DMS

Insert

IQS
Command

("set-l")
("1MS,set-l")
("set-l")
("1MS,set-l")

Qwner

into Set

IQS

and Arguments

IOS,set-l
Currency
Usqg:

Indicators
ch4l]geg:

CM(set-l)

CRU

CO(set-l)

CRU

(

Description
The record that is current of run unit becomes connected to the
current member of set-l. This new owner for the current member
The insertion of
of set-l is made the current owner of set-l.
the
new
existing owner records, connected
owner record among
this
member
of set—l, is made in accordance with the
to the current
Iii the
owner order declared for set-l in the ddl specification.
NEXT
PRIOR)
(or
owner
then the new
owner order is
is logically
the set
inserted after (or before) the set's current owner;
has no current
as the
inserted
record
is logically
owner, the
(or last) owner.
first

Rev.

82A

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

- VIII:

CONNECT

COMMANDS

MDBS

If
is

DMS

MANUAL

multiple members can exist for this new owner, the record that
the current member is logically inserted into those members
the
The exception is
according to the member order of set-l.
member order is NEXT (or PRIOR), in which case the record that is
the current member becomes the logically
(or last) member
first
the
new
of
set's
current owner.

The

current of run unit must be an occurrence of a record type
that is a owner of set—l. a user must have write access to set1, in order to connect
an owner record to a member record.

Examples

Command

block/áirect
block/indirect
record/direct

Usage
ED

...
...
...

record/indirect...

(C)

1981

Micro

ED
ED
ED

=
=
=
=

lOS
OMS
lOS
DMS

Data

("set-l")
("IOS,set-l")
("set-l")

("IOS,set-l")

Base Systems,

Inc.

Rev.

82A

58.1

MDBS

DMS

MANUAL

- VIII:

CONNECT

COMMANDS

MDBS

DMS

MANUAL

This page

58.2

Rev.

82A

(C)

intentionally left blank.

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

MDBS

DMS

MANUAL

IX. DISCONNECTCOMMANDS
A.

Overview

The MDBS
member record
each
other.

disconnect commands allow an owner record and a
that are connected via a set to be disconnected from
the current member or all members
can be
Either
a
disconnected from
set's current owner.
Similarly, either the
current owner or all owners can be disconnected from a set's current
Removing
between
a set connection
member.
two occurrences does not
those
the
data
base.
from
delete
occurrences
DML

set has fixed retention, no disconnections can be made for
be deleted
a
a record must
to be disconnected.
this case,
If
does
a
have
that
cannot
not
set, then
user
user
write access for
During disconnection all
perform any disconnections
on that set.
areas allowing pointer indices must be on-line.

it;

Command

Details

BMS

Member

Bemove

Command

from

BMS

Set

and Arguments

RMS,set-l
Currency

Indicators

LISWj:

CM(set-l)
CO(set-l)

Cbangqg:

CM(set-l)<——next
CRU

E——next

member
member

Description

the connection between the current owner and current
of set-l. The next member (following the member that was
becomes the new current
of the current owner of
of set-l and the current set-l
of run unit. which member is
depends
the
member
on
order of set—l, as declared
logicallyDDLnext
in the
there
is no next member,
the
specification.
If
member
set—l
becomes
the current of
for
indicator
current
null,
run unit becomes null, and the command status is 255.
If a user
does not have write access
to set-l, then the current member is
not disconnected, no currency indicators change, and a command
status error is returned.
Examples of Command
Usage
Remove
member
removed)
member

block/direct
block/indirect
recorá/direct

...
...
...
record/indirect...

(C)

1981

Micro

ED
ED
ED

=
=
=
=

RMS
DMS
RMS
DMS

Data

("set-l")
("RMS,set-l")
("set-l")

("RMS,set-l")

Base Systems,

Inc.

Rev.

83A

MDBS

DMS

MANUAL

DISCONNECT

- IX:

BQS

Remove

Command

COMMANDS

Qwner from

MDBS

DMS

MANUAL

Set

and Arguments

ROS,set-l
Indicators

Currency

CO(set-l)
CM(set-l)

USU:

CO(set-l)

changfa:

CRU

(

next owner

<——next

owner

Description

Remove the connection between
the current member and current
The
owner of set—l.
next owner (following the owner that was
removed)
of the current member of set—l becomes the new current
which owner is
of set—l and the current of run unit.
owner
next depends on the owner order of set-l, as declared
logically
in the DDL specification.
there is no next owner, the current
owner indicator for set-l becomes null, the current of run unit
does not
a user
becomes null, and the command status is 255e
have write access
owner
the
then
to
current
is not
disconnected, no currency indicators change, and a command status

set-l,

error

Examples

is returned.
Command

Usage

block/áirect
block/indirect
record/direct

...
...
...
record/indirect...

RSM

ED
ED
ED

=
=
=
=

Bemove

Command

ROS
OMS
ROS
OMS

("set-l")
("ROS,set-l")
("set-l")

("ROS,set-1")

all

Set

Members

RSM

and Arguments

RSM,set-l
Currency

Indicators

ysQg:

CO(set-l)

chanmSk

CM(set-l)

null

(

Description

connection between the current owner of set-l and each
of set-l becomes null.
its members. The current member
a user does not have write access
to set-l, then the members
the current member of set-l does not
are not disconnected,
and a command
change,
status error is returned.

Remove the
one of

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

Examples

DISCONNECT

- IX:

Command

MDBS

DMS

MANUAL

Usage
ED

block/direct
block/indirect
recorá/direct

...
...
...
record/indirect...

RáQ

ED
ED
ED

=
=
=
=

RSM
OMS
RSM
DMS

all

Bemove

Command

COMMANDS

("set-l")
("RSM,set-1")
("set-l")

("RSM,set-l")
RSQ

Set Qwners

and Arguments

RSO,set-l
Currency

Indicators

usqg:

CM(set-l)

Ch,arlg2d:

CO(set-l)(

null

Description

Remove the connection between
the current member of set—l and
each one of its owners.
The current owner of set-l becomes null.
a user does not have write access
to set—l, then the owners
are not disconnected, the current owner of set-l does not chanCler
and a command status error is returned.

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

(C)

1981

Micro

ED
ED
ED

=
=
=
=

RSO
DMS
RSO
OMS

Data

("set-l")
("RSO,set-1")
("set-l")
("RSO,set-l")

Base Systems,

Inc.

MDBS

DMS

MANUAL

- IX:

This page

(C)

DISCONNECT

COMMANDS

MDBS

DMS

MANUAL

intentionally left blank.

1981

Micro

Data

Base Systems,

Inc.

MDBS

JJMS

MANUAL

MDBS

DMS

MANUAL

DELETIONCOMMANDS

X.
Overview

deletion commands deletes a record
A record must
from
data
base.
have been found before
the
occurrence
Thus there are commands to delete the record that
can be deleted.
is the
Each

of the three

MDBS

DML

current of run unit,
current owner of an indicated set, or
current member of an indicated set.
A

record that has been remembered

be deleted,
owner, or a
when

after first
current member

in a user-defined indicator
the current of run unit,

(with an assignment

record that owns

deleted,
is
and

also
current

can
a

command).

disconnects
from every
The
owns.
from every member record that
occupied
by
and
the
pool
space
that record is nulled
is returned to
of
free space, so that
Deletion
can later be reused by MDBS.DMS.
commands can have extensive effects on currency indicators.
a

record

making

it
it

MDBS.DMS

user is not allowed to delete a record without write access to
the record type's data items, write access to all sets in which
of
all
and write access to the area containing
that record type participates,
the record and all areas containing records connected to the record
An attempt to violate
being deleted.
these security constraints
does
the
record and
not affect
results in a command status error.
a

In the case of multiple areas, all areas
indices must be on-line for record deletion.
B.

Command

that can contain pointer

Details

DBC

Relete Becord that is Current of run unit

Command
DRC

DBC

and Arguments
(no argument)

Currency
Indicators
usgsj:
cru

cjjangQg:

cru(
null
also see description

Description
The record that is the current of run unit is disconnected from
set relationships and is physically deleted from the data
all
base.
The current
of run unit becomes null.
the deleted
record is the current owner of any set, the current Ifmember of any
set, or the current record of any user-defined indicator, then
a
those indicators become null.
user does not have write
If
the
current of run unit's record type, to the record's
access to
(C)

1981

Micro

Data

Base Systems,

Inc.

Rev.

83A

MDBS

DMS

MANUAL

DELETION

area and to
no deletion

all sets in

Usage

COMMANDS

which

Command

block/direct
...
block/indirect
...
record/direct
record/.indirect... ...

ED
ED
ED
ED

=
=
=
=

DRC
OMS
DRC
OMS

Command

MANUAL

)

(

("DRC")
)

(

("DRC")

that is

Delete Becord

ñRM

DMS

then
type participates,
changes,
and a command

that reccnd
occurs, no currency indicator
status error is returned.

Examples

MDBS

Member

RRM

and Arguments

DRM,set-l
Currency

Indicators

Uáésj:

Ch4I)ged:

CO(set-l)
CM(set-l)

CM(set-l)<——next
CRU

(

member
member

also see description

Description
The record that is the current member of set-l is disconnected
from all set relationships and is physically deleted from the
data base. The next member that isownedby the current owner of
the current member of set-l and the current of run
set-l becomes member
on the member order of set-l.
is next depends
unit. which next member,
then
the
there is no
current of run unit becomes
If
becomes
member
of set—l
null, theand the command
null the current
being
255.
the
record
deleted
is
current owner
status is
If
member
of
than
any
any
of
set other
set, the current
set-l, or
the current record of any user-defined
then those
indicator,
indicators become null.

If the user does not have write access to set-l's member record
type, to the record's area and to all sets in which that record
then no deletion occurs, no currency indicator
type participates,
and a command status error is returned.
changes,
Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

(C)

= OMS
= DRM
= OMS

ED
ED

DRM

("set-l")
("set-l")
("DRM,set-1")

("DRM,set-l")

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

DELETION

COMMANDS

MDBS

DMS

DBQ

Delete Record that is Qwner

DBQ

Command

MANUAL

and Arguments

DRO,set-l
Currency

Indicators

tlseSk

charlgqg:

CM(set-l)
CO(set-1)

CO(set-l)<
CRU

next owner

<——next

also see description

owner

Description
The record that is the current owner of set—l is disconnected
from all set relationships and is physically deleted from the
data base. The next owner that is owned by the current member of
set—l becomes the current owner of set—l and the current of run
unit. which owner is next depends on the owner order of becomes
set-l.
no next owner, then the current of run unit
If therethe iscurrent
owner of set-l becomes null, and the command
null,
255.
status is
If the record being deleted is the current member
of any set, the current owner of any set other than set-l, or the
of any user-defined indicator,
then those
current record
indicators become null.

If the user does not have write access to set—l's owner record
then
type and to all sets in which that record type participates,
changes,
and a command
no deletion occurs, no currency indicator
status error is returned.
Examples

Command

block/direct
block/indirect
record/direct

Usage

...
...

...
record/indirect...

(C)

1981

Micro

ED
ED
ED
ED

=
=
=
=

DRO

("set-l")
("set-l")

OMS
DRO

("DRO,set-l")

OMS

("DRO,set-l")

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

- X:

This page

(C)

DELETION

COMMANDS

MDBS

DMS

MANUAL

intentionally left blank.

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MDBS

MANUAL

XI.
A.

DMS

MANUAL

UTILITY COMMANDS

Overview

Utility commands fall into the following groups:
and closing a database
or database
l. OpeningDBCLS,DBCLSA,DBOPN,DBOPNA

area

Flúshing the page buffers

DBSAVE

Allocating

user-defined

AUI

Getting the owner

indicators

(member)

for

count

member

(owner)

GMC,GOC

Getting the type

GTC,GTM,GTO

record occurrence

Testing for the type of a record occurrence
the equality of currency indicators

and checking

for

TCT,CCU,TMT,TOT

Acquiring database

DBSTAT

Nulling

NCI

all

Customizing

DBCNV,

Deta:

Command

statistics

currency indicators
the data base control
DBENV

system's behavior

íls
Állocate Rser Indicators

AUI
Command

EUZI

and Arguments

AUI,ib1k
Currency

Indicators

jLáU:

c.h&nqpd:

none

see

description

Description

be
must
host language
variable is defined For iblk.
It
consistent with a one byte unsigned data item. The value of that
and 255,
variable must be between
This value tells
inclusive.
how many user-defined
MDBS.DMS
indicators are to be allocated.
If the value is O, then no user-defined indicators are allocated.
One

(C)

1981

Micro

Data

Base Systems,

Inc.

Rev.

85A

MDBS

DMS

MANUAL

- XI:

UTILITY

COMMANDS

MDBS

DMS

is 12, then user indicators
through
If the value the
allocated.
value is 139, the user indicators
If
139 are allocated.

MANUAL

are

through

can be invoked
program
repeatedly within an application
to
increase or decrease the number of user-defined
indicators,
as
When
a data
base is opened Eor data manipulation (with
desíred.
command),
dbopn
the
indicators
four
user-defined
are
These
two
automatically
allocated and set to null.
user
first
DML
indicators
(1,2) are needed when performing a Boolean
command.
does not use
a
Boolean
application
an
program
If
command
the AUI can be used
and does not need any user indicator,
indicators.
zero
user
Ifi more than four user
to allocate
needed,
AUI
are
is used to allocate
indicators
the desired
When
number.
AUI
is employed to increase the number of user
the records that were current for already
indicators,
allocated
The new indicators
are
user indicators
current.
are set to
When
employed
decrease
number
AUI
the
of user
to
null.
is
indicators, only those records that are current for the resultant
F'or instance,
indicators are
user
current.
ten user
indicators
are allocated and AUI is used to reduce this to five,
1
then
only those records that were current for user indicators
5
Knowledge about
through
are
current after invoking AUI.
which
records
current for user indicators 6 through 10 is
not maintained.
AUI

still

still
=e

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...
Check

SXA
Command

Qirrent

ED
ED

=
=
=
=

AUI
DMS

AUI
DMSD

("iblk")
(iblk)

("AUI,iblk")
("AUI",iblk)

of run unit against Qser indicator

GCtl

and Arguments

CCU,iblk
Currency

Indicators

jL=á:

c,ha.nqed:

cru

CU(i)

none
,

Description

to determine whether the record that is current for a userdefined indicator is the same record that is the current of run
language
variable determines the
iblk's host
unit. The value ofwhich
That variable must
check
made.
for
is
user indicator
this
be
the
data item.
consistent with a one byte, unsigned
If user
is the same record as the specified
current of run unitcommand
is not, then the
indicator,
then the
status is O. If
command
status is 255.

Check

(C)

1981

Micro Data Base Systems,

Inc.

DMS

MDBS

Command

Examples

UTILITY

- XI:

MANUAL

MDBS

MANUAL

DMS

Usage

block/direct

block/indirect ....
..
record/direct
record/indirect. ...
..

ED
ED
ED
ED

=
=
=
=

CCU
DMS
CCU
DMSD

("iblk")
("CCU,iblk")
(iblk)
("CCU", iblk)
PFN.T q

Base £Lo,áe

Rata

ñFN,T c
Command

COMMANDS

and Arguments
(no arguments)

DBCLS

Indicators

Currency
9áéá:

Description
In a

all'í

c.hanqpd:

none

null

sinqle-qser

DBCLS
enx/ i.ronmen.t ,
should be the last DML
DBCLS
invoked
nulls
of
in an application program.
s
program'
of( the
indicators,
eliminates
that
all
currency
program' s
e. ,
indicators,
user
flushes the page buffers
changed
have
since entering main memory,
rewrites all pages, that
form of
into auxiliary memory) , and performs a TRCOM (for the
the system) . No further data manipulation can be performed after
DBCLS,
until the data base is reopened (with DBOPN) .
command

all
i.

rtl

Failure to close a data base can leave its contents inconsistent,
the data base was opened for modification.
This inconsistency
The data
subsequent
the
data
base.
prevent
efforts to open
will
base
can be
restored to a consistent state with the MDBS RCV

utility.

n1u1ti-|?ser
epvj ronmenr T many application
programs share the
page buffers.
Invoking DBCLS within an application proqram
and
nulls
out all of that program' s currency indicators
el iminates all of the program's user indicators.
also
flush the page buffers
no other application
program currently
has
the data base open for processing.
In order to flush the
page
buffers,
irrespective
of whether other programs have the
base
data
open for processing, the DBSAVE command
should be used.
data
Aii application
manipulation
program can perform no further
DBCLS,
has invoked
reopens the data base (with
after
until

same

It will

DBOPN)

Examples

and

Command

block/direct
block/indirect
record/direct
record/indirect.

(C)

1981

Usage
. . .
.
. . .

..
..

Micro

ED
ED

=
=
=
=

DBCLS
DMS
DBCLS
DMS

(

)

("DBCLS")
(

)

("DBCLS")

Data Base Systems,

Inc.

Rev.

85A

MDBS

DMS

MANUAL

- XI:

ñFTUP

Rata

Command

UTILITY

COMMANDS

Base CIKSe

MDBS

DMS

For Area

MANUAL
pRcTqB

and Arguments

DBCLsA,area

Indicators

Currency

cpha.nqea:

none

Description

flushes all page buffers that contain pages from the
indicated
"Flush" means to rewrite
pages,
that have
area.
changed
main
A
since entering
memory,
into auxiliary memory.
have
read
must
user
either
or write access to the indicated area
in order to use this command. The file on which the area resides
is closed by the operating system.

DBCLSA

Examples

Command

Usage

biock/direct

blocklináirect ...
00.
record/direct
...
record/indirect...
nRlcrrT

ED
ED
ED

Rata

Command

=
=
=
=

("area")

DBCLSA
DMS ("DBCLSA,area")
DBCLSA
DMS ("DBCLSA,area")

Base

("area")

format GclNSLersion

ppQjv

and Arguments

DBCNv,iblk

Indicators

Currency
jZSM:

Crhanqed:

none

Description

unit

none

the DBCNV command to cause the data base
system
control
to automatically convert date values into an
alternative
format as they are transferred between that run unit
and a data base.
As a value is transferred
to a data base,
is
from
the
alternative format to the standard MDBS format
converted
(mm/dd/yyyy
Conversely, as a
for date, prior to compression).
is converted from the
value is transferred to the run unit,
MDBS
the
standard
alternative format.
format to

run

can use

format is indicated by the value of
desired alternative
language
variable¢
This variable must be consistent
iblk's a host
The permissible
unsigned
data
one byte,
with
item.
iblk
correspcinding
and
formats are:
variable values
their
The

mm/dd/yyyy
dd/mm/yyyy
yyyy/mm/dd
yyyy/dd/mm

l
2
3
4

Rev.

85A

(C)

(the standard

1981

MDBS

date

format)

Micro Data Base Systems,

Inc.

MDBS

MANUAL

DMS

DBCNV

between

UTILITY

- XI:

can be invoked
various date

COMMANDS

times

multiple
formats.

MDBS

within

run

DMS

unit to

MANUAL

switch

also be used to allow (or disallow) null date or
The standard MDBS default condition is that null
times are not allowed.
and null
Additional
permissible
variable values and their effects are.as follows:
DBCNV

values.

can

null dates
null dates
null times
null'times

5
6
7
8

are
are
are
are

time
dates

iblk

allowed on input
not allowed on input (default condition)
allowed on input
not allowed on input (de£ault condition)

refers to any attempt to create or alter the value
IE a null date or time is involved
data item.
a sorted relationship,
null values are sequenced after nonvalues.
null
"input"

Here,

of
in

Examples

date

time

Command

Usage

block/direct

block/indirect ...
...
record/direct
...
record/indirect
...

ED
ED
ED
ED

Command

("iblk")
(iblk)

DBCNV
DMS ("DBCNV,iblk")
DBCNV
DMSD
("DBCNV",iblk)

Base ENjLironment

Rata

nFlF1\FT

=
=
=
=

options

ñPFBF

and Arguments

DBENV,iblk
Currency

Indicators

iZ=±

chanqpcí:

none

Description

run
unit can use this command to customize
its processing
environment
by specifying how the data base control system should
behave when interacting
The value of iblk's
with that run unit.
host language variable governs which aspect oF the environment
is
2 or 3 then
MDBS.DMS
altered.
the value is
behavior is
has
altered for ,áu run units for as long as any of them
The
base
the data
open.
host language variable for ib1k must be
Since option
consistent with a one byte unsigned data item.
some
checking
by
alleviates
of the
that is otherwise performed
MDBS.DMS,
the
can increase
processing speed of an application
program that modifies a data base.
This option is typically used
in an application program that is known to be "bug" free.

still

the variable has
If check
to determine

record
set.

(C)

tor

1981

value of

then MDBS.DMS
does
l,record
being connected

not perform
to an owner
set is already owned by that owner record via that
a

whether

Micro Data Base Systems,

Inc.

Rev.

85A

70.1

MDBS

DMS

MANUAL

UTILITY

- XI:

the variable has
If
are not suppressed.

COMMANDS

MDBS

DMS

MANUAL

value of 2, then checksums
on disk reads
the variable has a value of 3, the
MDBS.DMS
automatically performs a DBSAVE whenever a DML command
change
a
causes
Although these two
to a page(s) in memory.
options provide additional integrity safeguards, they will result
in slower processing.
a

has
variable
If iblk'swill
be performed

checking

value

of 4,

then no passive

for the run unit that invokes

lock

DBENV.

Though this option results in faster
DML commands,
should be used QJCljtL

processing of the run unit's
Ukh eYtreme rpÁl1r.inn because
a significant
eliminates
portion of the built-in integrity
When
checking.
passive
checking is disabled, the run
lock
its
unit will be allowed to alter records that are pasively locked by
other run units.
not be allowed to actively lock a
will
It
The usual record
record that is passively locked by others.
and
set removal integrity
deletion (see Table
restrictions are
enforced
XIV-l).

still

has
iblk's variable
If
based
record
on
find

value of 5, the run unit's attempts to
sort key (e.g., with FMSK) awill be
a
processed in
record
slightly different way than usual.
does
with an indicated sort key value cannot be found (because
(CRU
and
not exist), then the pertinent currency indicators
and
command
255.
eitherCOorCM)
becomenull
the
status is
a

the variable has a value of 6, the automatic FFM or FFO that
normally carried out for assignment commands (e.g., som is
In some situations this allows the run unit's
not performed.
control logic to be more concise.

If
is

of the
After DBENV has been invoked to alter some aspect
environment, that aspect of the environment can be restored to
its default behavior. This is accomplished by invoking DBENV
again, using a variable value that is lOó greater than what was
For instance,
previously used.
iblk's variable has a value of
105, thentheeffectof
formerly ifinvokingDBENVwith a value of 5
DBENV
is invoked with a value of lOl,
is no longer in force.
If
102, or 103 then the normal MDBS.DMS
behavior is restored for all
run units.
Examples

Command

Usage

block/direct

block/indirect ...
...
record/direct
...
record/indirect...

70.2

Rev.

85A

(C)

ED
ED
ED
ED

("iblk")
(iblk)

= DBENV
= DMS ("DBENV,ib1k")
= DBENV
= DMSD

("DBENV",iblk)

1983

Micro Data Base Systems,

Inc.

MDBS

DMS

- XI:

MANUAL

UTILITY

Data

DBQEN
Command

Base

COMMANDS

MDBS

DMS

MANUAL

DEQRN

Q12eN

and Arguments

DBOpN,iblk
Currency

Indicators

tIs2g:

cbaljgQg:

none

CO(system-owned
CO(other
sets)

set)

CRU

<——system
<——null
<——null
F——system

CU(1),CU(2),CU(3),CU(4)

(

CM(all sets)
Description
DBOPN
An

opens

data base for processing by an application
program.
IDJJmÁÉ
invoke
the DBOPN command hQfQrg any
program
the data base can be accessed. There are four host

application
data held in
language variables
type), which MDBS.DMS

l.
2.
3.

null

The
been

the iblk data block (or program record
forexpects
in the following sequence:

user's name that has
This variable must be
data item of no more than 16

is
variable's value
first
in the DDL.
specified

string
The second variable's value is the user's password as
specified in the ddl. This variable must be consistent
with a string data item of no more than 12 bytes.
The third variable's value indicates
the type of processing that the program will perform. This variable
must be consistent
with a string data item of no more
than 4 bytes. If the variable's value begins with r,
the program is allowed to perform retrieval only (i.e.,
read access only, regardless of a user's write access
codes). If it begins with M, the program can modify
(as well as retrieve) data.
If the variable's value
begins
with e, the run unit has exclusive modification
and
access to a data base, subject to
retrieval
security constraints;
in a multiuser environment
this
prohibits any other application program from accessing
a data base,
until the program with exclusive access
invokes dbcls.
Since it is not sharing the data base
with other run units, a run unit with exclusive access
had r or
access.
will execute Easter than if isit the
The fourth variable's value
fully qualified file
name for the main area of the data base being opened.
This variable must be consistent with a string data
item; the maximum length is operating system dependent.
qualified file
It cannot exceed the length of a fully
system
consistent
bytes.

with

permitted in the operating
appropriate system specific manual).
name

(C)

1981

Micro

Data

Base

Systems,

Inc.

(consult

Rev.

83A

the

MDBS

DMS

MANUAL

- XI:

COMMANDS

UTILITY

MDBS

the iblk data block
In block-oriented languages,
data block defined (see DEFINE command) before
This block and all other data blocks defined
DBOPN
after invoking DBOPN.
are inoperative
defined again, after DBOPN, in order to be used

must

DMS

MANUAL

last

the

invoking DBOPN.
before invoking
(They

after

must

DBOPN.)

Upon opening a data base
and the current owners of

processing the current oÍl run unit
for system-owned
sets become the SYSTEM
all
record occurrence. All other currency indicators are null. Four
user-defined currency indicators are automatically allocated.
If
on the page-image file, they are used to
any page images
exist data
The
base
page-image
automatically

consistency.
restore
file
delcared with the PIFD command (Chapter XV) prior
For the RTLform, a command status warning of
to invoking DBOPN.
74 is returned
no log file is present; this does not prevent
have

must
the

data

been

base

from

being

opened.

Although DBOPN opens only the main area of the data base, other
areas are automatically opened by MDBS.DMS when the application
These are opened
program needs to access records in those areas.
main area.
a command
for the same type of processing as the
an area that needs to be automatically
status error results
A command
opened is not on-line.
the
status error results
does
have
read access or write access to the area that
not
user
needs to be opened.

Examples

and

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
recorá/indirect...

DBQRNÁ

Command

ED
ED
ED

=
=
=
=

Data

("iblk")
("DBOPN,iblk")
(iblk)("DBOPN",iblk)

DBOPN
CALL
OMS
DBOPN
CALL
DMSD

QEeN

Base

DBQRNÁ

Area

and Arguments

DBOpNA,area,iblk
Currency

Indicators

UsQg:

Rev.

83A

chmmsk

none

(C)

none

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

Description

UTILITY

- XI:

COMMANDS

MDBS

DMS

MANUAL

indicated
area for processing.
area on the file indicated by the
value of ib1k's host language variable. This variable must be
consistent with a string data item; its size is operating system
dependent, but cannot exceed the maximum length of a fully
name
allowed by the host operating system (consult
qualified file system
The value of the variable
specific manual).
the pertinent
a
be
must
the fully qualified name of
on-line when
that ismatch
file
DBOPNA
need
does
the file
to
not
is invoked. This name
DDL
name assigned to the area in the
specifications. If54 the
command
a
is
status of
indicated
is not beon-line,
used
by
the
application
developer to
This fact can
returned.
determine whether an end user of the application program has the
they are not, a corresponding
appropriate
disks on-line;
be
end
the
prompt
user.
issued to
can
the
opens
explicitly
expects to find this

DBOPNA
MDBS.DMS

file

variable has
on the
exists
area
(or
specifications
its

iblk's host thelanguage
If
assumes that
in the DDL
specified).
and

Examples

Command

block/direct

Usage

...

E0=DBOPNA("area,iblk")
= DBOPNA
("area")
or
ED

block/indirect

record/direct

=
=

...
...
record/ináirect...

("area",iblk)

Ease

("DBOPNA,area",iblk)
np)qpvF

SAYE

and Arguments

Currency

(no arguments)

Indicators

U,áU:

("DBOPNA,area,iblk")
ED
= DMS ("DBOPNA,area")

DBOPNA
CALL
DMSD

Data

DBSAVE

OMS

nFlq)TTF
Command

null value, then MDBS.DMS
for that area
file specified
name,
default
if none is
a

-"(

charlgeg:

none

Description

flushes the page buffers, regardless of whether the run
unit is executing in a single-user or multiuser environment.
This saves all changes that have been made to pages (in the page
buffers) since they entered main memory. These changed pages are
saved by rewriting them into the data base that exists in auxis advisable to invoke DBSAVE after extremely
iliary memory.
It
that change data base contents.
This
crucial transactions
guarantees
that those transactions are immediately incorporated
In the event of an
into the permanent copy aof a data base.
abnormal interruption of
run unit, the following rule holds.
base since the last
If no changes have been made to the data and
DBSAVE, then the data base is consistent
can be re-opened
DBSAVE

(C)

1981

Micro

Data

Base Systems,

Inc.

9DBS

DMS

MANUAL

- XI:

UTILITY

COMMANDS

MDBS

DMS

MANUAL

(i.e., without a command status error of 15). In a
environment,
the data base control system may
multiuser
DBSAVE
invoke
independently of any
many times,
automatically
executing run unit. Thus an abnormal interruption may
leave the data base in a consistent
can be
state so that
successfully re-opened.
successfully

still

Examples

Command

Usage

block/direct
block/indirect
recorá/direct

...
...
...
record/indirect...

ED
ED
ED

=
=
=
=

Base

STáTistics

changgsj:

none

Rata

DBSTAT
Command

)
(
DBSAVE
OMS ("DBSAVE")
)
(
DBSAVE
DMS ("DBSAVE")

DBSMT

and Arguments

DBSTAT,oblk
Currency

Indicators

USC9:

none

Description

returned as values of
Statistics on data base utilization areEach
of these variables
oblk'sbefive host langugagea variables.
The
two byte, unsigned data item.
must
consistent with
the
sequence of
five returned statistics is as follows:

the number
memory,

the

the number

the

buffers

of read requests
data

base,

in main

allocated

currently

the

issued by

data

base)

different
MDBS.DMS

that
page

since

of write requests issued since the data base
that were due to DBSAVE or to background
processing in a multiuser environment,

the total number of write requests issued by
since opening the data base.

the number
was opened

Command

MDBS.DMS

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

page

number of times (since opening
the most recent page access was
than the last page access,
opening

Examples

(C)

ED
ED
ED

=
=
=
=

("oblk")

DBSTAT
dms
("DBSTAT,oblk")
DBSTAT
DMSD
("DBSTAT",oblk)

(oblk)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

UTILITY

- XI:

GMC

Member

Get

Command

COMMANDS

MDBS

DMS

MA-NUAL

GMC

Count

and Arguments

GMC,set-l,oblk
Indicators

Currency
tI££g:

changgg:

CO(set-l)

none

Description

of member records connected to the current owner oft
is
returned
in the host language variable defined for oblk.
set-l
This variable must be consistent with a four byte, unsigned data
does not have read
a user
item (see system specific manuals).
If
and a command
member
the
returned
to
count
not
access
set-l,
is
status error is issued.
Examples of Command
Usage
The number

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

ED
ED
ED

GQC

=
=
=
=

GMC
DMS
GMC
DMSD

("set-l,oblk")
("GMC,set-l,oblk")
("set-l",oblk)

("GMC,set-l",oblk)

Get Qwner Count

Command

GQC

and Arguments

GOC,set-l,oblk
Currency

Indicators

tlÁéSl:

CM(set-l)

charlg£g:

none

Description

The number

of owner records connected to the current member of
is
in the host language variable defined for ob1k.
returned
set-l
This variable must be consistent with a four byte, unsigned data
item (see system specific manuals).
If a user does not have read
access to set—l, the owner count is not returned and a command
status error is issued.

Examples

Command

Usage

block/áirect
block/indirect
record/direct

...
...
...
record/indirect...

(C)

1981

Micro

ED
ED
ED

=
=
=
=

GOC
OMS
GOC
DMSD

Data

("set-l,oblk")
("GOC,set-l,oblk")
("set-l",oblk)

("GOC,set-l",ob1k)

Base Systems,

Inc.

MDBS

DMS

MANUAL

GTC

- XI:
Get Type

Command

UTILITY

COMMANDS

MDBS

DMS

of kurrent of run unit

MANUAL

GTC

and Arguments
,

GTC,oblk
Currency

Indicators

tl§qg:

cru

Description

The name

unit

is
be

must
Examples

ChangQgj:

of the record type for the record that is current of run
That variable
returneá in oblk's host language variable.
consistent with an eight byte, character data item.

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

ED
ED
EC

GTM

=
=
=
=

GTC
DMS
GTC
DMSD

("oblk")
("GTC,oblk")
(oblk)
("GTC",oblk)

Get Type

Command

none

Member

and Arguments

GTM,set-l,oblk
Currency

Indicators

ljscd:

CM(set-l)

chAngqg:

none

Description

The name of the record type for the record that is the current
member of set-l is returned in oblk's host language variable.
That variable must be consistent with an eight byte, character
a
a user does
data item.
not have read access to
command status error is returned and the value of oblk's host
language
variable is unchanged.

Examples

Command

set-l,

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

(C)

ED
ED
ED

=
=
=
=

GTM
OMS
GTM
DMSD

("set-l,oblk")
("set-l",oblk)

("GTM,set-l,oblk")
("GTM,set-l",oblk)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL
,

- XI:

UTILITY

COMMANDS

MDBS

DMS

MANUAL
GTQ

get ;jype of Qwner

GTQ

Command

and Arguments

gTO,set-l,ob1k
Currency

Indicators
c[,hanqed:

CO(set-l)

none

Description

of the record type for the record that is the current
variable.
of set-l is returned in oblk's host language
be
variable must
consistent with an eight byte, character
a user
does not have read access
to set-l, a
data item.
If
command
and
host
the value of oblk's
status error is returned
language
variable is unchanged.

The
owner
That

Examples

name

Command

Usage

block/direct

...
block/indirect ...
record/direct
...
record/indirect...

ED
ED

Null

NCL

Command

all

GTO
DMS
GTO
DMSD

("set-l,oblk")
("gTO,set-1,oblk")
("set-l",oblk)

("gTO,set-1"oblk)

Currency

1Micators

ÁCI

and Arguments
(no arguments)

NCI
Currency

=
=
=
=

Indicators
Chanqed:

none

all

currency indicators

null

Description

All

currency indicators are made null, with the exceptions of
The active lock
current owners of system-owned sets.
statuses
MCP
Thus,
is in effect, NCI nulls the
are not affected.
current of run unit; but as soon as the current of run unit again
becomes non-null,
its record is actively locked.

Examples

Command

block/direct

Usage
ED

block/indirect ...
...
record/direct
...
record/indirect...

(C)

1981

ED
ED
ED

=
=
=
=

NCI

(

DMS

("NCI")

NCI

(

DMS

("NCI")

)

Micro Data Base Systems,

Inc.

Rev.

85A

MDBS

DMS

MANUAL

- XI:

UTILITY

COMMANDS

MDBS

DMS

Test Current of run unit flor Null

Command

TCN

and Arguments
(no arguments)

TCN

Indicators

Currency
KZáOi:

command

none

status of 255 is returned
is not null, the command

If it

null.
of

Examples

ch1'ínqpc1¶

cru

Description
A

MANUAL

Command

block/direct

block/indirect
record/direct
record/indirect

the current
if status
is

of run unit is

Usage
ED
ED
ED
ED

...
...
...
...

)

(

= TCN
= DMS
= TCN
= DMS

("TCN")
(

)

("TCN")

Test Current of run unit Type

=
Command

and Arguments

TCT,rec
Currency

Indicators
ch(Anqpd:

cru

none

Description

record type of the current of run unit is compared
to rec.
command
O.
the
the
is
are
same,
they
they
are not
status
If
If
the same, the command status is 3.

The

Examples

Command

Usage

block/direct

block/indirect ...
...
record/direct
...
record/indirect...

Rev.

83A

(C)

ED
ED
ED
ED

= TCT
= DMS
= TCT
= DMS

("rec")
("TCT,rec")
("rec")
("TCT,rec")

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

- XI:

TMN

Member

Test

Command

COMMANDS

UTILITY

MDBS

DMS

MANUAL

TMN

for Null

and Arguments
.

TMN,set-l
Currency

Indicators

tlswj:

Description
the current
If
is returned.
Examples

chaQgea:

CM(set-l)

of
is not

member

If it

Command

a
set-l isthenull,
command
null,

status of 255
status is O.

command

Usage

block/direct
block/indirect
record/direct
record/indirect

...
...
...
...

= TMN
= OMS
= TMN
= OMS

ED
ED
ED

TMT

Test

Command

none

("set-l")
("set-l")

("TMN,set-l")
("TMN,set-1")
Member

TMT

Type

and Arguments

TMT,rec,set-l
Currency

Indicators

9áWj:

CM(set-l)

Ch¢nggd:

none

Description
The record type of the current member of set-l is compared
to
O.
the
command
the
are
same,
they
is
they
are
status
rec. If
If
not the same, the command status is 3.
Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/ináirect...

(C)

1981

Micro

ED
ED
ED

=
=
=
=

TMT
OMS
TMT
OMS

Data

("rec,set-l")

("TMT,rec,set-l")
("rec,set-1")
("TMT,rec,set-l")

Base Systems,

Inc.

Rev.

83A

78.1

MDBS

DMS

MANUAL

- XI:

TQN

UTILITY
Qwner

Test

Command

COMMANDS

MDBS

DMS

for Null

MANUAL

TQN

and Arguments

TON,set-l

Indicators

Currency
nsqg:

CM(set-l)

Description
the current
If
returned.
If
of

Examples

status of 255 is
is O.

Usage

block/direct
block/indirect
record/direct
record/indirect

...
...
...
...

=
=
=
=

ED
ED
ED

TQT

TON
OMS
TON
OMS

Test

Command

none

acommand
is null,
set-l
command
the
status
null,

of
is not

owner

Command

chang2g:

("set-l")
("set-l")

("TON,set-l")
("TON,set-l")

Qwner Type

TQT

and Arguments

TOT,rec,set-l
Currency

Indicators
CO(set-l)

U,áC9:

cbaL]g£g:

none

Description
The record type of the current owner of set-l is compared to rec.
they are the same, the command status is O. If they are not
If
the same, the command status is 3.
Examples

Command

Usage

block/direct
...
block/indirect
...
record/direct
record/indirect..Q ...

78.2

Rev.

83A

(C)

ED
ED
ED
ED

=
=
=
=

TOT
OMS
TOT
DMS

("rec,set-l")
("TOT,rec,set-l")
("rec,set-l")
("TOT,rec,set-l")

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

TñN

Test

Command

UTILITY

- XI:
User

COMMANDS

indicator

MDBS

DMS

MANUAL

TUN

for Nüll

and Arguments

TUN,iblk
Currency

Indicators

úáU:

cbaDgqg:

CU(i)

none

Description
The value of iblk's host language variable determines the user
indicator which is tested for being null. That variable must be
consistent with a one byte, unsigned data item. A 255 command
the indicated user indicator is null. If
status is returned
command status is returned.
is not null, then a

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

(C)

1981

Micro

ED
ED
ED

=
=
=
=

TUN
OMS
TUN
DMS

Data

("iblk")
("TUN,iblk")
(iblk)

("TUN",iblk)

Base Systems,

Inc.

Rev.

83A

MDBS

DMS

MANUAL

- XI:

This page

(C)

UTILITY

COMMANDS

MDBS

DMS

MANUAL

intentionally left blank.

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

XII.
A.

DMS

MDBS

MANUAL

BOOLEANCOMMANDS

Overview

supports the Boolean int£rsect (i.e., logical AND) and
Each Boolean DML command has three sets
Ái: Efermce operators on sets.
The
to the
as arguments.
first two sets are used to specifyset inputs
whose member
The third set is a system-owned
Boolean operation.
record occurrences, after the execution of a Boolean command,be are the
either
set must
result of the Boolean operation. This system-owned
be
SSYSSET
whose
a
types
could
occurrences
or
set that owns all record
The
a
of the Booleanoperation.
two set names may or may
result
first
used
be
(SSYSSET
be
set). The third set
input
can
as
an
the
same
not
The user of a
can be the same as either of the first two sets.
Boolean
command must have read access to the first two sets and write
access to the third set.
MDBS

Each

DI4L

Boolean

indicators. These
Boolean command.
command and can be
There

reallocated

four intersect

are

the first two user-defined
allocated prior to invoking the
by the DBOPN
automatically
allocated

utilizes
been
by the

as needed.

AUI command,

commands.

Take the

intersection

the members of the owner of the first set (as indicated by
the first user indicator) and the members of the owner of
the second set (as indicated by the second user indicator):

AMM:

command
must have
They are

the members of the owner of the first set (as indicated by
the first user indicator) and the owners of the member of
the second set (as indicated by the second user indicator):

AMO,

the owners of the member of the first set (as indicated by
the
user indicator) and the members of the owner of
the first
second set (as indicated by the second user indicator):
AOM,

the owners of the member of the first set (as indicated by
the first user indicator) and the owners of the member of
the second set (as indicated by the second user indicator):

AOO.

Similarly,

l.
2.

commands.

Exclude

from

the members of the owner of the first set (as indicated by
the first user indicator) those records that are also
members of the owner of the second set (as indicated by the
XMM,
second user indicator):
of the owner of the first set (as indicated by
indicator) those records that are also owners
first
of the second set (as indicated by the second
of the
XMO,
user indicator):
the members

the

(C)

there are four difference

user
member

1981

Micro

Data

Base Systems,

Inc.

Rev.

82A

MDBS

MANUAL

DMS

BOOLEAN

- XII.

COMMANDS

MDBS

DMS

MANUAL

the owners of the member of the first set (as indicated by
the first user indicator) those records that are also
members of the owner of the second set (as indicated by the
XOM,
second user indicator):

the owners of the member of the first set (as indicated by
the
those records that are also owners
user indicator)
first
the
member
the
second
of
of
set (as indicated by the second
XOO.
user indicator):

In the case of multiple areas, all areas allowing pointer
on-line during the execution of Boolean commands.

Command

Details
And

UM
Command

arrays must

of Members with Members

and Arguments

AMM,set-l,set-2,set-3
Currency

Indicators
CU(l)
CU(2)

Q8Q!á:

Description

ch@ngqg:

CM(set-3kc——null
CRU

intersection
(logical AND) of the members of the owner
(denoted
by
the
and the members of
user indicator)
of set-l
first
second
by
the
the owner of set-2 (denoted
user indicator). All
Any
records in the intersection are made members of set—3©
the
member

Take

the

of set-3 that is not in
intersection is disconnected
amm.
The current member of
set—3
during
execution
of
from
the
and
become
of
run
the
unit
null and the command
set-3 becomes current
255.
the
member
of
order
set-3 is not sorted,
status
then the ordering of members of set-3 after AMM is a function of
$SYSSET
the member order of set-l and the member order OE set-2.
has FIFO ordering.

reasonable to use AMM unless the member recordtypes of
isnot
It
set—l and the member record types of set-2 have at least one
Otherwise, the intersection will be
record type in common.
empty.
Íojját qwji each tQGOÚi
IE set=3 iS jjQt SSXSSETl then
L¥K2Q khat La tmth a wmoker
Qt sek=L ariáita wmoker QÉ set=2.
If
the intersection
is empty, then set-3 will have no members€
Examples

and

Command

Usage

block/direct
block/indirect
recorá/direct

...
...
...
record/indirect...
82

Rev.

83A

(C)

ED
ED
ED

=
=
=
=

AMt4
OMS
AMM
OMS

("set-l,set-2,set-3")
("set-l,set-2,set-3")

("AMM,set-l,set-2,set-3")
("AMM,set-l,set-2,set-3")
1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

And

AMQ

Command

BOOLEAN

- XII.

COMMANDS

MDBS

DMS

MANUAL

AMQ

of Members with Qwners

and Arguments

AMO,set-l,set-2,set-3
Indicators

Currency

ch!angQg:

cu (l)
CU(2)

u££g:

Description

(set-3) <——nu1l

cm
CRU

<——

null

of the members of the owner
of
of set-l
first user indicator) and the owners All
the member of set-2 (denoted by the second user indicator).
Any
records in the intersection are made members of set-3.
member of set—3 that is not in the intersection
is disconnected
The current member of
from set—3 during the execution of AMO.
command
and
become
the
of
null and the
run unit
set-3 becomes current
255.
the
member
not
sorted,
is
order
of
set-3
status
If
then the ordering of members of set-3 after AMO is a function of
the member order of set-l and the owner order and of set-2.
SSYSSET
has FIFO ordering.

Take

the

intersection
(logical
(denoted
by the

AND)

to use AMO unless the member record types of
record types of set—2 have at least one
Otherwise, the intersection will be
record type in common.
mast Qwñ mcb tQCQtá
set=3 iS ñQt SSXSSETt theri
empty.
Kypq that is tmth q uímoket OF sek=L and an S2WñQL
S£t=2.
If
the intersection is empty, then' set-3 will have no members.

It is not reasonable
set—l and the owner

Examples

and

Command

block/direct
block/indirect
record/direct
record/indirect.
AQK

Usage
ED

...
. ..
.... .
áná

Command

CZ:E

ED
ED
ED

=
=
=
=

AMO
DMS
AMO
DMS

("set-l,set-2,set-3")
("AMO,set-l,set-2, set-3")
("set-l,set-2,set-3")
("AMO, set-l, set-2, set-3 ")

of Qwners with Members

and Arguments

AOM,set-l,set-2,set-3
Currency

Indicators

Usq±

cu (l)
CU(2)

chanmí

CM(set-3)

(

CRU

<——

null
null

(C)

1981

Micro

Data

Base Systems,

Inc.

Rev.

82B

MDBS

DMS

MANUAL

BOOLEAN

- XII.

COMMANDS

MDBS

DMS

MANUAL

Description
the

AND)
of the owners of the member
intersection
(logical
of set-l (denoted by the first user indicator) and the members of
the owner of set-2 (denoted by the second user indicator). All
Any
records in the intersection are made members of set—3.
member of set—3 that is not in the intersection
is disconnected
The current member of
from set—3 during the execution of ADM.
and
become
the
of
run
current
unit
set-3 becomes 255.
null and the command
the member order of set-3 is not sorted,
status
If
then the oráering of members of set-3 after AOM is a function of
$SYSSET
the owner order of set-l and the member order of set-2.
has

Take

ordering.

FIFO

not reasonable
to use ADM unless the owner record types of
and the member record types of set-2 have at least one
be
Otherwise, the intersection
record type in common.
each
Qwñ
SSXSSET.l
m,ak
tecaúi
thmi
empty. IE set=3 iS ijQt
Xyp9 that ia hoth álj QWljGt SU set=L an9 a lD£u)ket QÉ aet=2.
have no members.
the intersection
is empty, then set—3

It is
set-l

will

and

Examples

Command

block/direct
block/indirect
record/direct
record/indirect.

Usage
ED
.C@
ED

.. .
...
..

ED
ED

And

áQQ

Command

=
=
=
=

ADM
DMS
ADM
DMS

("set—l,set-2,set—3")
("AONl,set-l, set-2,set-3")

("set-l,set-2,set-3")

("AOM,set-l, set-2, set-3"}

of Qwners with Qwners

AQQ

and Arguments

AOO,set-l,set-2,set-3
Currency

Indicators

uuj:
Description

ch,angeg:

cu (l)
CU(2)

CM(set-3)

(

CRU

<——

null
null

of the owners of the member
and the owners of
user indicator)
of set-l
first
second
the
(denoted
by
set—2
the member
user indicator).
of
All
Any
records in the intersection are made members of set-3.
member of set-3 that is not in the intersection
is disconnected
AOO.
The
current member of
from set-3 during the execution of
set—3 and the current of run unit become null and the command
is not sorted,
status becomes 255. If the member order of set-3
AOQ
a function
members
the
is
of
of set-3 after
ordering of
then
$SYSSET
and
of
set-2.
order
owner
the
the owner order of set-l
has FIFO ordering.

Take

the

Rev.

82B

(logical
intersection
(denoted
by the

(C)

AND)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

BOOLEAN

- XII.

COMMANDS

MDBS

DMS

MANUAL

reasonable
to use ADO unless the owner record types of
It is not
and the owner record types of set-2 have at least one
set-l
Otherwise, the intersection will be
record type in common.
se:
k=3
§SXSSETl
then
wjjst Qwñ each recoÚi
empty.
jjQt

thatIf is

Lypq

the intersection
Examples

Command

and

is
áD

kQth

Usage

block/direct
block/indirect
record/direct

...
...
...
recorá/ináirect...

ED
ED
ED

= ADO
= OMS
= AOO
= DMS

eXclude

=
Command

qsu)£k Qt &Qt=1 ansi ájj QjLljeL QÉ se: k=2.
empty, then set-3 will have no members.

("set-l,set-2,set-3")
("set-l,set-2,set-3")

("AOO,set-l,set-2,set-3")
("AOO,set-l,set-2,set-3")

Members from

XMN

Members

and Arguments

XMM,set-l,set-2,set-3
Currency

Indicators

WQáv

CU(l)
CU(2)

cjj8ngesj:

null

CM(set-3)

CRU

<——null

Description
from the members of the owner of
Exclude (logical difference)
by
(denoted
the first user indicator) those records that
set-l
members
of the owner of set-2 (denoted by the second
are also
records
in the difference are made members of
indicator). All
set-3. Any member of set-3 that is not in the logical difference
The
from set-3 during the execution of XMM.
is disconnected
current member of set-3 and the current of run unit become null
and the command status becomes 255.
the member order of set-3
If
then
sorted,
the
not
membersof
set-3 after XMM is
is
orderingof
a function of the member
order of set-l and the member order of
$SYSSET
has FIFO ordering.
set-2.

is not reasonable to use
It
set—l and the member record

unless the member record types of
types of set-2 have at least one
record type in common. I£set=3isnQtSSYSSET&thenik
Íojjst QWlj
each l:cgql!j Lye?q that is hath a ioember Qt set=1 arid g idqiÚ2Ql aE
set=2.
If the difference is empty, then set-3 will have no
XMM

members.

Examples

and

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/ináirect...

(C)

1981

Micro

ED
ED
ED

=
=
=
=

XMM

DMS
XMM
DMS

Data

("set-l,set-2,set-3")
("XMM,set-l,set-2,set-3")
("set-l,set-2,set-3")

("XMM,set-l,set-2,set-3")

Base Systems,

Inc.

Rev.

82B

MDBS

DMS

MANUAL

- XII.
eXclude

XMQ

Command

BOOLEAN

COMMANDS

Members from

MDBS

DMS

Qwners

MANUAL

and Arguments

XMO,set-l,set-2,set-3
Currency

Indicators

tlsé9:

CU(l)
CU(2)

chaRgqg:

CM(set-3)+——ñull

CRU

null

Description
Exclude (logical difference)
from the members of the owner of
by the
(denoted
indicator) those records that
user
set-l
first
are also owners of the member of set-2 (denoted by the second
records in the difference are made members of
indicator).
All
member
set-3. Any
of set-3 that is not in the logical difference
The
from set-3 during the execution of XMO.
is disconnected
set—3
and
member
oft
become
of
run unit
the current
current
null
and the command status becomes 255.
the member order of set-3
If
set-3 after XMO is
is not sorted, then the orderingof membersof
and
a function of the member
order of set-l
the owner order oF
$SYSSET
has
FIFO
ordering.
set-2.
reasonable to use
is not
It
and the owner record
set-l

XMO

unless the member record types of
types of set-2 have at least one

recordtype in common. I£sQtz3i£Dgt§sYSSETLtheDitwAst qwij
l2gqksj Ky1?£ that is tmtb a umotmt QÉ ae: E=L ami g¡j qwilqk Qt
sek=2.
If the difference is empty, then set-3 will have no
2@gb

members.

Examples

and

Command

block/direct
block/indirect
record/direct

Usaqe
ED

...
...
©0.

record/indirect...

Rev.

82B

(C)

ED
ED
ED

=
=
=
=

XMO
OMS
XMO
DNIS

("set-l,set-2,set-3")
("XMO,set-l,set-2,set-3")
("set-l,set-2,set-3")

("XMCl,set-l,set-2,set-3")

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

COMMANDS

Qwners from

eZclude

XQM

Command

BOOLEAN

- XII.

MDBS

DMS

MANUAL

XQM

Wembers

and Arguments

XOM,set-l,set-2,set-3
Currency

Indicators

tIsé9:

chÁrlg£g:

CU(l)
CU(2)

CM(set-3)<——null
CRU
<——null

Description
from the owners of the member of
Exclude (logical difference)
by
(denoted
the first user indicator) those records that
set-l
are also members of the owner of set-2 (denoted by the second
are made members of
indicator). member
All records in the difference
the
not
Any
logical difference
in
set-3.
of set-3 that is
The
from set-3 during the execution of XOM.
is disconnected
become
set—3
and
member
of
the current of run unit
current
null
and the command status becomes 255.
the member order of set-3
If
not sorted, then the orderingof members of set-3 after XOM is
is
a function of the owner
order of set-l and the member order of
SSYSSET
has FIFO ordering.
set-2.
not reasonable
to use XOM unless the owner record types of
and the member record types of set-2 have at least one
record type in common. Ifset=3isnQtSsYssETLthQBit Íojjst Qwñ
each l£cqkáj t¥p: é that is Emth an Qwrlet Qt set=í and ,a umoker Qt
have no
§QtÁñÁ
the difference
is empty, then set-3
members.

It is
set—l

will

Examples

and

Command

block/direct
block/indirect
record/direct

Usage
ED

...
...
...

record/indirect...

ED
ED
ED

=
=
=
=

XOM
OMS
XOM
DMS

("set-l,set-2,set-3")
("XOM,set-l,set-2,set-3")
("set-l,set-2,set-3")
("xOM,set-l,set-2,set-3")

(C)

1981

Micro

Data

Base Systems,

Inc.

Rev.

82B

MDBS

DMS

MANUAL

BOOLEAN

- XII.
eZclude

ZQQ

Command

Qwners

COMMANDS

from

MDBS

DMS

Qwners

MANUAL

XQQ

and Arguments

XOO,set-l',set-2,set-3
Currency

Indicators

UsM:

changesj:

CU(l)
CU(2)

CM(set-3)<
CRU

null
null

(

Description
from the owners of the member of
Exclude (logical difference)
by
(denoted
the first user indicator) those records that
set-l
are also owners of the member of set—2 (denoted by the second
indicator). member
All records in the áifference
are made members of
Any
not
set-3.
in the logical difference
of set-3 that is
The
from set-3 during the execution of XOO.
is disconnected
set—3
and
member
become
of
the
current
current of run unit
null
and the command status becomes 255c
the member order of set-3
If
is not sorted, then the ordering Qtof membersandof set-3 after XOO is
a function of the owner
order
the owner order of
set-l
$SYSSET
has FIFO ordering.
set-2.
reasonable
to use XOO unless the owner record types of
It is--not
and the owner
record types of set-2 have at least one
set-l
msist qwjj
record type in common. I£aek=3iaQQt§SYSS£T^thgRit
L=L and ál) Qwñer czF
each KégQLsj FYpe that ia both an Qwnqt Qt
=:
the difference is empty, then set-3 will have no
aQt=2.
If
members.
Examples

and

Command

Usage

..:
...
...
record/indirect...

block/direct
block/indirect
record/direct

Rev.

82B

(C)

ED
ED
ED
ED

=
=
=
=

XOO
DMS
XOQ
OMS

("set-l,set-2,set-3")
("XOQ,set-l,set-2,set-3")
("set-l,set-2,set-3")
("XOO,set-l,set-2,set-3")

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MOBS

MANUAL

OMS

MANUAL

SPECIALCOMMANDS

XIII.
Overview

that are used only within
are several MDBS DML commands
These are referred
languages
host
to as
or environments.
certain
commands
some
commands.
For instance, there are
that are used
special
extend, and
only in block-oriented host languages in ordercommand
to define,
employed
Another
in
is
undefine data blocks.
special
languages
that do not allow DML commands
to be used as functions that
This command is used to set up the
take on a command status value.
language
Yet another
variable that will hold the command status.
host
command
command
the
used
is
special
end-of-set
to alter
status number
FORTRAN,
be
255
For
can
(255).
instance, with
altered to -l; this is
useful in branching structures involving an arithmetic IF statement.
There

host
important special command, used with nearly every
very SETPBF.
used at the start of a program to set up
is
is
buffers that ItMDBS.DMS will utilize for that run unit.
In
a
single user environment, the program buffers are used as the page
buffer region.
is advisable to allocate as much space as possible
for page buffers. It In a multiuser environment,
the page buffer region
shared
by
by an
and
many
users
is
therefore
not allocated
is
have its own program
Each run unit may however,
individual run unit.
buffers that are used by MDBS.DMS when interacting with the run unit.
a run
unit uses SETPBF to allocate its program
buffers.
In some
environments
that
multiuser
there is yet another special DML command
allows each run unit to control its own throughput priority level.
A

language,
the program

The

RTTFn"l

=er

Command

host language

a
commands

are

and

available

environment
in that

Details

Command

specific manual for
of these
special

system
which

indicates
setting.

EM Qf £et

gTTFn"F

and Arguments
(no arguments)

ALTEOS

Currency

Indicators

We±

c,.ha.n.qeq:

none

Description

The command
status value of 255 that is normally used to indicate
the scope
an end-of-set
of the application
is altered withinALTEOS
program that uses ALTEOS.
is permitted within a given
the
system
host language,
specific manual for that language

indicates

"l).
(C)

the altered

1981

end-of-set

command

Micro Data Base Systems,

status value

Inc.

Rev.

(usually

85A

MDBS

DMS

- XIII.

MANUAL

Examples

Command

block/indirect ...
...
record/direct
...
record/indirect...
Rata

Command

COMMANDS

MDBS

DMS

MANUAL

Usage

block/direct

PFTNTT

SPECIAL

ED
ED
ED
ED

(
)
= ALTEOS
DMS
("ALTEOS")
=
(
)
= ALTEOS
= DMS ("ALTEOS")

control

Base

system

1NITialization

and Arguments

variables

DBINIT,host language
Indicators

Currency

none

Description

chanqed:

is available,

none

DML command
the
is invoked aslanguage
(or
more)
variables
host
or
of
unit.
Tlie nature of these arguments
constants are used as arguments.
and the precise actions performed
by DBINIT are operating
system
See
manual.
system
speci£ic.
the appropriate
specific
In
general, DBINIT initializes the data base control system(s)
to be
used by a run unit.

When

DBINIT
a
run

run
DBINIT
Examples
See

units

have

Command

system

use

Usage

specific

manuals.

Rata

Base aEL,ection

and Arguments

DBSEL,host
Currency

first

a single
that support DBINIT,
can
run unit
MDBS
data
bases
multiple
open simultaneously.

ñFNFT
Command

Two

variable

language

Indicators

9SM:

ch.gnqu:

none

Description

none

Where DBSEL is available,
can be used by a run unit to select
MDBS data
bases for
the
processinq.
open
concurrently
any one of
The host language
variable (or constant) is used to indicate
which of the data bases is to be processed.

Examples
See
90

Rev.

Command

system
83A

Usage

specific
(C)

manuals.
COPYRIGHT

1981

Micro Data Base Systems,

Inc.

MDBS

DMS

SPECIAL

- XIII.

MANUAL

ñFFTNF

PFFTNF

Command

data

MDBS

COMMANDS

DMS

MANUAL

PFFTNF

block

and Arguments
t

DEFINE,blk,list
Currency

Indicators

jZSM:

chkanqed:

none

Description
This

none

is used with host languages that do not support
record types.
defines the blk data block to have the
The composition of
characteristics
indicatedIt in list.
is
list
a
host language dependent.
consists
of
least
at
It typically
make
language variables
the
data
of
the
host
that
block.
up
list
FtíLl details for each host language
appear in the system specific
command

program

manuals.

data block must have been defined with the define command
A
before
can be used as an argument in any other DML command.
given host language variable can appear more than once in the
Many
same
data blocks can be
or different data blocks.
different
used
a
language
the
data
Only
in
host
block
program.
last DBOPN.
DBOPN
be£ore
Ariy
defined
invoking
using
exist
after
will
data block defined after the data base is opened will continue to
exist until
is undefined (with the UNDEF command).

Examples

Command

block/direct

Usage
ED

block/indirect ...
...

(C)

1981

=
=

DEFINE
DMSD

("blk",list)

("DEFINE,blk",list)

Micro Data Base Systems,

Inc.

Rev.

83A

90.1

MDBS

DMS

MANUAL

- XIII.

SPECIAL

pMqq1Tp

Command

aet

COMMANDS

MOBS

DMS

iLumR

MANUAL

rírmr

and Arguments

DMssjp,host language

jump

description,

command

status array

Indicators

Currency
lláéd:

Chq¡nqed:

none

Description
This special command pertains to
host languages and provides a
The indicated host language
concise error trapping mechanism.
jump description
is a pointer to a stack environment. The values
of the indicated array specify which command status numbers are
The last element
of this
to be exempted from the error trapping.
O.
have
a
must
value
of
array
C

is invoked,
its first argument indicatescommandthe
a
to which control is transferred whenever
This
status other than those specified in the array occurs.
remains
condition
in force until DMSSjP is re-invoked with a
argument
(indicating a different error handling module
different
a
of exempt command status numbers).
set
different
or
If the
O,
then standard error handling is resumed.
argument
is
first
command
then
the second argument is
rather than an array,
all
and 255 are trapped.
status numbers other than

when DMSSjP
environment

Example

Command

system

See

Usage

specific

manuals.

F"TFNP

data block

F"TFNñ

and Arguments

Command

ExTEND,blk,list
Indicators

Currency

g=d:
Description
This

chanqed:

none

with host languages that do not support
is used to extend
the previously
record types.
program
It
by
assigning
variables
more host language
defined blk data block
and they
These
variables
indicated
in
additional
are
to
list
variables
defined
the
already
for
data block.
follow the
will
dependent.
The composition of list is host language
It typically
variables.
consists of at least a list of the additional
FUI
details for each host language appear in the system specific
command

used

it.

manuals.

90.2

Rev.

85A

(C)

1981

Micro Data Base Systems,

Inc.

MDBS

DMS

SPECIAL

- XIII.

MANUAL

WJBS

COÍ4MANDS

MANUAL

DMS

blk áata block must have been defined with the DEFINE command
can be used in an EXTUD command (otherwise a command
before
7 is returned).
A given host language
oF
status
variable can
data
than
blocks.
same
appear more
once in the
or different

The

Examples

Command

Usage

block/direct

ED
ED

block/indirect ...
...

= EXTEND
= DMSD

MUtiuser

Comínand

,list)
MEL

2rkxity Level

and Arguments

!4PL,
Currency

("blk",list)

("EXTEND,blk"

iblk
Indicators

u=já:
Description

rh'ínqF'a:

none

is of interest in multiuser processing
varying
situations. It enables different arun units to have 1·!PL,
the
degrees of throughput priority. IF run unit invokes
value of iblk's host language variable is used to set that run
unit's priority. The iblk host language variable must be
consistent with a two byte unsigned data item. Its value can be
from
10.

The

any

MPL

command

integer

through

highest possible priority level is
Selecting this level
results in throughput that is at least asl. East as level 2. Level
2 throughput,
in turn, is at least as fast as level 3, and so
forth. A runMPLunit that does not require fastest throughput
should use
to set its priority level lower than
(i.e.,
2-10) . a run unit that requires more than minimal throughput
should use MPL to set its priority level higher than 10 (i.e.,
to alter its own
9-l) . A run unit can invoke 14PL repeatedly
priority level at desired points in the program.
The

An interactive
MPL to
invokes

level
priority
priority.

Examples

Command

run

get
of

block/indirect ...
.. .
record/direct
record/indirect. ...
. .

COPYRIGAT

1981

unit has a priority level of 3 until
different priority. a batch runa unit has ita
to get
until it invokes
different
¢·1PL

Usage

block/direct

(C)

a
7

Micro

ED
ED
ED
Ell

=
=
=
=

MPL
DEIS
blPL
D14SD

Data

("iblk")
("MPL, iblk")
(iblk)
("MPL" ,iblk)

Base Systems,

Inc.

Rev.

85A

MDBS

DMS

MANUAL

- XIII.

'FTPRF

Command

SPECIAL

Exogram

COMMANDS

BtiEfer

MDBS

DMS

region

MANUAL

"FTPBF

and Arguments

SETpBF,list
Indicators

Currency

=g:

chAnqec1:

none

Description
This

none

allocates the region of main memory that is to be
SETPBF
must appear
for program buffers.
is invoked,
If
command
DML
needs
before any other
that
buffers.
to use program
The composition
dependent
and
of list is environment
is fully
discussed in the various system specific manuals.
It typically
flor
consists of a starting address and a length (in bytes)
the
For
instance, with fortran the starting
buffer
page
area.
address
could be indicated by an array name and the length would
be the number
of bytes occupied by that array.
In the
language,
example,
for
the SBRK function is a dynamic
memory
allocation function; the value returned by SBRK can be used as an
input to the SETPBF DML command.
command

used

the programmer can optionally omit SETPBF.
many environments
a single-user
environment, MDBS.DMS itself sets up
omitted
in
If
region possible.
program
largest
the
(i.e., page) buffer
MDBS.DMS
a
multiuser
environment,
allocates adequate
omitted in
For a given operating environment,
the system
program buffers.
specific manual indicates whether SETPBF can be omitted.
In

Examples

Command

system

See

Usage

specific

manuals.

ñNñf'Pine

!1NñFF

Command

data blocks

!1NT)FP

and Arguments
(no arguments)

UNDEF

Currency

Indicators

USU:

chanqed:

none

Description

data blocks previously defined in the program are undefined
employed in host
they no longer exist). This is UNDEF
typicallyinvoked
(i.e.,
before the
is
language
that use chaining.
programs
needed data blocks are redefined
and
chained
subprogram
a
to
call
within the subprogram.

ALL

Rev.

82B

(C)

1981

Micro Data Base Systems,

Inc.

DMS

MDBS

Examples

SPECIAL

- XIII.

MANUAL

Command

block/direct
block/indirect

MDBS

DMS

MANUAL

Usage
ED

...
...

=
=

)
(
UNDEF
DMS ("UNDEF")

yABiable for
Command

COMMANDS

CoMmanO

string

and Arguments

VARCMD,host

language

variable

Description
This special command is used in some host languages to specify a
host language variable, whose value is treated as a DML command
The application
program sets the value of this variable
string.
DML command and arguments)
command
to the desired
string
(i.e.,
the
data
base
each
control system.
invocation of
prior to
Examples

See

Command

system

Usage

specific

manuals.

!lÁUable for

JIABCS
Command

Command

JIABCS

Status

and Arguments

VARCS,host
Currency

language

variable

Indicators

Uscd:

Cb@Rg£d:

none

Description
The indicated host language variable
will hold the command status
that results from invoking a DML command. VARCS is needed only
in those very few host languages that do not permit function
(see
subprograms.
for a hostDMLlanguage
If VARCS is available
should be the
command used
system specific manuals),
first
in an application program. An exception to this is the case
where DBINIT is also available, in which case VARCS is invoked
after DBINIT.

Examples
See

(C)

Command

system

Usage

specific

1981

Micro

manuals.

Data

Base Systems,

Inc.

Rev.

83A

92.1

MDBS

DMS

MANUAL

XIII.

This page

92.2

Rev.

82B

(C)

SPECIAL

COMMANDS

MDBS

DMS

MANUAL

intentionally left blank.

COPYRIGET

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MDBS

MANUAL

DMS

MANUAL

XIV. MULTIUSERLOCKINGCOMMANDS
A.

Overview

In a multiuser environment, MDBS
supports two kinds of record
A record is passively
locking:
passive and active.
locked
is
the current of any run unit, the current owner or current member of
the current record occurrence of any record
any set for any run unit,
type for any run unit (for 3a only:
see Appendix A),
or the current
A record can
record for any user-defined indicator in any run unit.
be actively
locked by invoking a DML multiuser locking command
(of
which
As long as a record is locked by one
there are several).
run
denied either read, write, or read and write
unit, other run units are The
type of access denied depends on whether
access to that record.
the record is actively or passively locked.

III

if it

Restrictions
to access caused by multiuser locking do not affect
security restrictions on a user's access.
All security restrictions
are enforced independently of whether
an environment
is single user or
(though
multiuser
page image posting is unavailable for
multiuser).
Using a multiuser locking command
in a single user environment has no

effect.

In a multiuser environment, a record can be read
is not
locked or
is passively locked. A record cannot be read
is
A run unit
cali modify a record,
actively locked.
that record is
As long as a record is actively
not locked by any other run unit.
or
by
passively locked
one run unit, no other run unit can modify it.
The programmer
of application systems for a multiuser environment

if it

should keep the following facts in mind:
a record is not actively
locked and a run unit has that
l. If
record passively locked (i.e.,
is a current record for
that run unit), any run unit can read it.*

If a run unit has a record actively locked, no other run
unit can read that record until the active lock is removed
(with a DML command described in this chapter).

If a record is not actively locked and more than one run
unit has that record passively locked, then no run unit can
change
have
or delete the record until all other run units
removed their passive locks on that record (e.g., with a dml
assignment
or find command).

If
unit
is

run unit has a record actively
can possibly change that record
removed.
a

locked, no other run
until the active lock

There
are
four types of active locking commands, which
differ
One
according to the scope of records that they actively
lock.
actively
which
locks the current of run unit,
is normally only
*
MDBS
(C)

QRS

utilizes passive locking.
1981

Micro

Data

Base Systems,

Inc.

Rev.

83A

MDBS

DMS

MANUAL

Table

MULTIUSER

XIV.

COMMANDS

MDBS

DMS

MANUAL

Multiuser Locking Contention protocols

XIV-l:

.
Run Unit
attempt8

B
Find

Run Unit
hm

locked
record

Modify
locked
record

permitted

nk permítted*"not

retrieve
a

Pa8sive
lock
on a record

Connect
record

or
Create
record

set-2

permitted

not

if a
same

into

relevant

Disconnect
all member
(owner)
records
from sec-2

Disconnect
a record
from
set-2
permitted
A has the
same CO and Qq
B
for set~2

,
Delete
record

permitted
not
has Ehe
CO(CM) for
set-2
as B and
CM(CO) of set-2
for A Is non-

permitted

null
Active
on

lock

not

permítted

ncic relevant

not

relevant

not

relevant

not

relevant

permitted

not

relevant

not

permitted

not

relevant

not

permitted

not

relevant

not

relevant

permitted

not

permitted

not

permitted

not

permitted

not

permitted

not

permitted

a record

Active

lock
on
records
of
type
a record

all

Active

all

lock
record8

8et—l

on
of

not permitted
through
aet-l

if attempt
modify

sort

key value
set~l

not permitted
í£ record
Is
auto owner
member of

is permitted
Modification
by
invoking DBENV with
altered
Rev.

85A

(C)

ifset—2set-l

permitted

ifset-2sec-l

if record
owner or
ber

is
mem—

set-l

set"l

if3et-2set-l

has
B's run unit environment
ifhost
language variable value of

been
4.

Micro Data Base Systems,

Inc.

1981

MDBS

DMS

MANUAL

XIV.

MULTIUSER

COMMANDS

MDBS

DMS

MANUAL

command
Another
passively locked.
allows a run unit to declare that
one
more user-defined indicators
or
(rather than
are to be actively
Another
passively) locked.
kind of active locking command places an
The fourth actively
active lock on all occurrences
of a record type.
a
meaning
unit
can
that no other run
locks
set,
utilize that set and
member
and
record types are
owner
that the occurrences of that set's
Tíie
actively
locked.
effects of these locks on record retrieval,
modification,
creation,
connection, disconnection and deletion
are
A special DML command
Tab1e
in
presented
for setting run unit
XIV-l.
(see Chapter XIII).
priority levels is available in some environments

(or
set)
unit attempts to access a record occurrence
then
a
such
the
prohibited,
that
locked in
way that access is
be
access
either
access
attempt will
is
re-tried periodically until
accomplished
In
or some number of failed access tries have occurred.
a command
indicating that a needed
the latter case,
status message,
a
At any juncture in
record is locked, is returned to the program.
(MCC)
the
the programmer
specify
program,
can use a DML command
to
number
of retries and the time units between
Defaults for
tries.
MDBS
these
(see
System
are
Specific
operating system dependent

Ifis

one run

Manuals).
As

locked
B.

soon
as
are freed.

Command

run

unit invokes

had

Details
MUtiuser

MAIL
Command

all records that

DBCLS,

Active User indicators

EAU

and Arguments

MAU,iblk
Currency

Indicators

M:
Description

user

indicators

Cphanqer1:

none

host language
be
variable is defined for iblk.
It must
consistent with a one byte unsigned data item. The value
of that
must be an integer between
and 255
variable
inclusive.
This
value indicates how many user-defined indicators are to be made
actively locked, rather than passively locked.
If the value is
O,
then all user-defined indicators
revert to their normal state
of being
passively locked.
is 12, then user
If the value
indicators
through 12 are actively
locked and all other
MAU can be used
allocated user indicators are passively locked.
rún
a
repeatedly within
unit to alter the number of user
indicators that are actively locked.
One

indicator must have been allocated (with AUI) before
can
declared to be actively locked.
a command
status message
63
MAU
62
from
the
of
results
any record that is
or
current

user
be

(C)

1981

Micro Data Base Systems,

Inc.

Rev.

85A

MDBS

DMS

MANUAL

MULTIUSER

- XIV.

COMMANDS

MDBS

DMS

MANUAL

a
is already actively
user indicator
or passively
mau
another run unit.
In this case,
will not affect
the current active/passive status of user indicators.

record
locked

Examples

Command

Usage

block/direct

block/indirect ...
...
record/direct
...
record/indirect...

ED
ED
ED
ED

=
=
=
=

Multiuser

=
Command

MAU

("iblk")
(iblk)

("MAU,iblk")

MAU

("MAU",iblk)

Contention Count

MCC

and Arguments

MCC,iblk

Indicators

Currency

g=d:

ch(7lnqpc1:

none

Description
This

none

sets the number of re-tries and the time units
be enforced by MDBS.DMS
when an access
tries that will
This is enforced
attempt is prohibited due to multiuser locking.
for all DML commands that follow MCC,
another !4CC is
until
Tlíe
an
invoked.
first host language variable for iblkThe has
second
integer value that indicates the number of re-tries.
variable defined for iblk has an integer value that indicates the
The time unit is
number of time units between tries.
operating
dependent
(see system specific manuals),
system
but is never
Both of ibik's variables
must
be
smaller than .01 seconds.
unsigned
consistent with an
data item that is two bytes in size.
command

between

Examples

Command

Usage

block/direct

block/indirect ...
...
record/direct
...
record/indirect...

=
=
=
=

MCC
DMS
MCC
DMSD

("iblk")
("MCC,iblk")
(iblk)
("MCC",ib1k)

Multiuser Current of run unit Eree

Command

and Arguments

Currency

(no arguments)

MCF

Indicators

=Á:
96

ED
ED
ED
ED

ch&nqed:

CRU

(C)

none
1981

Micro Data Base Systems,

Inc.

MDBS

DMS

MANUAL

XIV.

MULTIUSER

COMMANDS

MDBS

DMS

MANUAL

Description
the record that is the current of run unit has been actively
If
is
invoking MCF will free that record so that
locked by MCP,
only passively locked.

Examples

Command

Usage

block/direct

block/indirect ...
...
record/direct
...
record/indirect...

ED
ED
EC
ED

= MCF
= DMS
= MCF
= DMSD

(

)

("MCF")
(

)

("MCF")

Mu1tiuser Gurrent of run unit Erotect

Comnand and itrguments
(no arguments)

MCP

Currency

Indicators

lZáéá:

ch(inqeíí:

CRU

Description

when this
unit
run
run unit.

none

is executed, the record that is the current of
is actively locked for as long as
is the current of
After MCP has been invoked (and before invoking MCF),
a
record can become the current of run unit only
is not
When
actively
or passively locked by some other run unit.
does
become the current of run unit,
becomes actively
locked
and
the former current of run unit is no longer actively
locked
(by way of MCP).
command

if it

reinstate the current of run unit to its normal condition
being only passively locked, the MCF command is used.
To

Examples

Command

Usage

block/direct

block/indirect ...
...
record/direct
...
record/indirect...

(C)

1981

Micro

ED
ED
ED
ED

= MCP
= DMS
= MCP
= dmsd

Data

(

)

("MCP")
(

)

("MCP")

Base Systems,

Inc.

Rev.

83A

MDBS

DMS

MANUAL

XIV.

MULTIUSER

COMMANDS

Eecord

Type Eree

MUtiuser

==
Command
'

MDBS

DMS

MANUAL

and Arguments

(rec

MRTF,rec

is optional)

Indicators

Currency

CrMnqer1:

none

Description

They are
record occurrences of rec are freed.
no longer
the
The exception is that
run unit.
actively locked by
one of
those occurrences is actively
locked through some other multiuser
then
command,
is
actively locked (until the
protect
corresponding multiuser tree command is invoked).
If no record
type is specified with this command, then every record type that
is actively locked by the run unit is freed.

All

Examples

Command

still

Usage

biock/ciirect
block/indirect
record/direct

...
...
...
record/indirect...

ED
ED
ED
ED

=
=
=
=

MRTF
OMS
MRTF
DMS

("rec")

("MRTF,rec")

("rec")

("MRTF,rec")

Multiuser Becord

==
Command

;jype

2rotect

and Mgwnents

MRTP,rec
Currency

Indicators

cha.nqed:

none

Description
type rec are actively locked by the
All occurrences of the record
run
no other
run
unit has locked any of those
unit,
of
any occurrence
occurrences (either actively or passively). the
If MRTP
by
request
then
run
another
is
locked
unit,
rec is and a command
status message to that effect is returned.
refused

Examples

Command

Usage
ED

block/direct

block/indirect ...
...
record/direct
...
record/indirect...

Rev.

85A

(C)

EC
ED

= MRTP
= OMS
= MRTP
= DMS

("rec")

("MRTP,rec")

("rec")

("MRTP,rec")

1981

Micro Data Base Systems,

Inc.

MDBS

DMS

MANUAL

XIV.

Multiuser

=
Command

Set

MDBS

DMS

MANUAL

Eree

and Arguments

(set-l is optional)

MsF,set-1
Currency

COMMANDS

MULTIUSER

Indicators

úáU:

Chq¶nqe¿i:

none

Description

has been
locked
actively
indicated
freed
set-l is The
and
owner
of
the
occurrences
record
earlier in the run unit.
member record types are no longer actively
there
unless
locked,
is also an active lock on one or more of those record types or on
a
free
record occurrence (until the corresponding multiuser
command
run
of
the
is invoked).
no set is specified,
all
If
locked
sets are freed.
units' actively

if it

The

Examples

Command

Usage

block/direct

ED
ED
ED
ED

block/indirect ...
...
record/direct
...
record/indirect...

= MSF
= DMS
= MSF
= DMS

Multiuser

=
Command

("set-l")
("MSF,set-l")
("set-l")

("MSF,set-l")

Set

Zrotect

and ít,rguments

MSP,set-l
Currency

Indicators

!=a:

chanqed:

none

Description
An
has
a
active lock is placed on set-l,
no other run unit
and
a
lock (either
active or passive) on both an owner record
member
record of that set.
is locked by
any such occurrence
If
command
MSP
then
a
and
another run unit,
the
request is refused
status message to that effect is returned.

Examples

Command

Usage

block/direct

block/indirect ...
...
record/direct
...
record/indirect...

(C)

1981

Micro

ED
ED
ED
ED

= msp
= DMS
= MSP
= DMS

Data

("set-l")
("MSp,set-l")
("set-l")

("MSP,set-l")

Base Systems,

Inc.

Rev.

85A

MDBS

DMS

MANUAL

XIV.

This page

lOó

(C)

MULTIUSER

COMMANDS

MDBS

DMS

MANUAL

intentionally left blank.

1981

Micro Data Base Systems,

Inc.

MDBS

DMS

MDBS

MANUAL

RECOVERYCOMMANDS

XV.

DMS

Overview

features and commands described in this chapter are available
in various versions of the RTL form of the MDBS data base management
The RTL form requires a larger minimum buffer size than the
system.
command
same
standard form.
follows the
Invoking a recovery
DML
commands
command.
Thé
conventions as invoking any other
recovery
two
groups:
into
fall
The

those that deal with page image posting of
transactions (TRABT,TRBGN,TRCOM,PIFD), and
those that deal with the logging of transactions

1.
2.

complex

(LGFILE,LGFLSH,LGMSG,TRBGN,TRCOM).

Page image posting may be considered to form a
line of
defense
against data base inconsistency due to external factors such
the
as power
failures. The transaction logging commands providepower
including
kinds,
of
many
against
defense
failures
ultimate
and erroneous
(although authorized)
failures, hardware malfunctions,
both
Either or
of the two recovery approaches can
data modification.
be used by an application
However, page image posting is not
program.

first

meaningful in multiuser

situations.

posting allows the application developer to specify
(with the TRBGN
sequence
the beginning of a complex transaction
caused by the transaction
command).
The data base changes
sequence
the data base until the commit command
are not incorporated
into
(TRCOM)
A transaction
sequence can be aborted by invoking
is invoked.
An abnormal
command.
the abort (TRABT)
termination of the program in
a
transaction
the data
sequence
the midst of
complex
will not leave
When
base inconsistent.
the data base is re-opened,
is consistent.
is current up to the point of the last invocation of TRBGN before
the interruption.
Page

image

used by MDBS.DMS
preservation
to provide
isThe
file
image
page
automatic
this
recovery capability.
file must be
declared with the PIFD command prior to opening the data base.
If
of!
a page
image
PIFD is not invoked,
no posting occurs.
file
If
size is used, then the data base could become
insufficient
a transaction
inconsistent
sequence is abnormally interrupted.
In
a
command
status error to that effect is returned when an
this event, made
is
attempt
to re-open the data base. The log of transactions can
be
used to recover from such a situation.
A

page

image

Transaction logging allows an application program to make use of
the log file defined in the DDL specification. The name of the file
used for logging a program's transactions
can be changed
with the
the
data base back-up are
LGFILE command.
transactions
since
last
áll
The log
used by the
automatically logged onto the log file.
is be
file
RCV
RCV
used to
RTL
(provided
the
form).
can
with
automatically re-apply transactions to an old back-up copy of the data
base,
The user has
thereby recreating
an up-to-date
data base.
extensive control over which transactions are re-applied.

utility

(C)

1981

Micro

Data

Base Systems,

Inc.

Rev.

83A

101

MDBS

MANUAL

DMS

XV.

COMMANDS

RECOVERY

MDBS

DMS

MANUAL

used to indicate the start of a complex
for the purpose oil transaction logging. The
the complex
transaction sequence started by
TRBGN.
RCV
ignore any logged transactions
that occur after an
TRCOM
TRBGN,
a subsequent
Other
was not reached during a run unit.
commands that can be used in conjunction with transaction logging are
LGFLSFI
and LGMSG which flush the log
buffers and insert messages
the
into
respectively.
log
The TRBGN command
sequence of transactions,
TRCOM
command terminates

will

file

file,

RTL

A complete
Manual.

Command

description

RTL

form

is presented in the

MDBS-

Details
LoG

TCFTTF

Command

of the

specification

EILE

TCFTTF

and Arguments

LGFILE,iblk
Currency

Indicators

USU:

chanmk

none

Description

none

which transactions
can be
language
This
variable. whose
is must be
a
with
consistent
data
item,
string (see the
variable
maximum length is operating system dependent
appropriate
system specific manual for size information). If the file to
are to be logged is the same as the log file
which transactions
DDL
in
the
specification,
thismustcommand need not be
specified
command
appear before the
invoked. If
is invoked, this

The

name
fully qualified
specified by

logged

Command

Usage
ED

block/direct
block/indirect
recorá/direct

...
...
...
record/indirect...

102

Rev.

command.

DBOPN

Examples

to
tile
host
iblk's
of

83A

(C)

ED
ED
ED

=
=
=
=

LGFILE
DMS

LGFILE
DMSD

("iblk")
(iblk)

("LGFILE,iblk")
("LGFILE",iblk)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

TgFTqH
Command

RECOVERY

XV.

file

LOG

COMMANDS

MDBS

DMS

buffer ELuSH

MANUAL

TWUH

and Arguments
(no arguments)

LGFLSH

Indicators

Currency

=g:
Description
The

chanqec1:

none

holding transactions to be logged are flushed to the
LGFLSH
invoked.
is automatically
file
especially useful when an important
by the system.
can be written
It
the
log
before
the
log
is
to
file
file buffer
full.
log

buffers

when this command
is
invoked
by DBSAVE.
This is
transaction has been processed
Examples

Command

Usage

block/direct

block/indirect ...
...
record/direct
...
record/indirect...

EC
ED
ED
ED

=
=
=
=

(
LGFLSH
OMS ("LGFLSH")
(
LGFLSH
dms
("LGFLSH")

)

TgMqc

file

MeSsaGe

chanqpd:

none

LOG

Command

TCM"C

and Arguments

LGMSG,iblk
Currency

Indicators

g=d:

none

Description

The message

specified in iblk's host language variable is written
be consistent with a string
the
log
to
file. This variable must Messages
data
item not exceeding 90 bytes.
written to the log
RCV
be
can
using
the
listed
file
utility program. The use of the
LGMSG command
is especially useful for surveillance.

Examples

Command

Usage

block/direct

block/indirect ...
...
record/direct
...
record/indirect...

(C)

1981

Micro

ED
ED
ED
ED

("iblk")

= LGMSG
= DMS ("LGMSG,ib1k")
= LGMSG
("LGMSG",iblk)
= DMSD

(iblk)

Data

Base Systems,

Inc.

Rev.

85A

103

MDBS

DMS

MANUAL

XV.

RECOVERY

Eage Image
Command

COMMANDS

MDBS

DMS

Eile Oeclaration

MANUAL

ELER

and Arguments

pIFD,iblk
Indicators

Currency

u=g:

chanqed?

none

Description

none

file
declared to

fully qualified

indicated by iblk's host language
name,
a
be
variable, is
for use by MDBS.DMS
page image
command
image
invoked
must
be
in page
posting.
This
prior to use
TRCOM,
and TRABT commands.
The host language
of the TRBGN,
The
must be consistent with a string data item.
variable
size
dependent
and
documented
system
(in bytes) is operating
is
in the
1£ ELER ía invnkedú
corresponding system specific manual.
npenea.
data
makappmr befnre
la
Tlie

file

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

ED
ED
ED
ED

("iblk")
(iblk)

= PIFD
=
= PIFD
= DMSD

DMS-("pIFD,iblk")
("PIFD",Áblk)

TRansaction
Command

AEott

TP9BT

and Arguments
(no arguments)

TRABT

Currency

Indicators

jkM:

chñnqec1:

none

most

currency indicators

<——nu1l

escription
PIFD has been invoked):
Posting Effects (occur only
sequence
This command
that was
aborts a complex transaction
TRBGN
A transaction
command.
be
by
cannot
the
aborted
initiated has
TRCOM
committed
command).
been
(with
the
already
after command
invokes
NCI
that
no
This
internally to ensure
inconsistent currency indicators will be present.

Effects:

Logging
TRABT

the
RCV

104

Rev.

be invoked
only
transaction sequence
may

if PIFDis
that

recovery processor.

83A

(C)

1981

invoked, in which case
aborted will be ignored by the

has been

Micro Data Base Systems,

Inc.

MDBS

DMS

Examples

MANUAL

Command

COMMANDS

MDBS

DMS

MANUAL

Usage

block/direct
block/indirect
recorá/áirect

...
...
...
record/indirect...

ED
ED

=
=
=
=

TRABT
DMS
TRABT
DMS

(

)

("TRABT")
)

(

("TRABT")

T8ansaction BeGiN

TRBGN
Command

Currency

TRBGN

and Arguments
(no arguments)

TRBGN

(no arguments)

LGCPLX

Indicators

tIsQsj:

RECOVERY

XV.

cbang2g:

none

Description
Posting Effects (occur only if PIFD has been invoked):
transaction
This command denotes the beginning of a complex
DML
The changes
commands.
the
use of several
involving
sequence,
DML
do
base
commands
cause in the data
not become
that these
TRCOM
TRCOM
command
commits
invoked.
permanent until the
is
command aborts a
The TRABT
these changes to the data base.
has been invoked,
complex transaction.
After TRCOM or TRABT complex
TRBGN
must be re-invoked to initiate another
transaction.
TRBGN
a TRABT or TRCOM
is
re-invoked
without
having
issued
If
command, a command status error is issued
and the re-invocation
of TRBGN is ignored by MDBS.DMS.
Logging

Effects:

When this command
complex
sequence of

is invoked,

transactions. it

logged, RCV will
automatically
TRBGN
unless a subsequent
follow
The TRBGN and TRCOM commands are
complex
either all or none which
(if aform

the transactions,
by RCV during recovery.
Examples of Command
Usage
block/direct
block/indirect
recorá/direct

...
...
...
record/indirect...

(C)

1981

Micro

ED
ED
ED

=
=
=
=

part

the beginning of a
Although
all transactions are
ignore any transactions
that
TRCOM
command is encountered.
used in tandem to ensure that
sequence
is not completed) of
of a complex sequence, are used
indicates

(
)
TRBGN
DMS ("TRBGN")
(
)
TRBGN
DMS ("TRBGN")

Data

Base Systems,

or
or
or
or

ED
ED
ED
ED

Inc.

=
=
=
=

(
)
LGCPLX
DMS ("LGCPLX")
(
)
LGCPLX
DMS ("LGCPLX")

Rev.

82A

105

MDBS

DMS

MANUAL

TPCñM

XV.

RECOVERY

TBansactiQn

Command

COMMANDS

MDBS

DMS

CQtjmit

MANUAL

¶?CñM

and Arguments

TRCOM

Currency

(no arguments)

LGENDX

Indicators

úSé9:

Changea:

none

Description
Posting Effects (occur
This command commits a
the TRBGN command, to
clearing the contents

none

pifd has been invoked):
transaction, that was initiated by
added effect of
base.
It has thedeclared
of the page image
with the
file

only

complex
the data

PIFD command.

Logging
Effects:
This command indicates the end of a complex sequence of
Any transactions
transactions.
logged since the last TRBGN
be
processed
by the RCV
command was invoked
can now
utility for
data base restoration.
Examples

Command

block/direct
block/indirect
record/direct

Usage
ED

,..
...

...
record/indirect...

106

Rev.

82B

(C)

ED
ED

=
=
=
=

)
(
TRCOM
OMS ("TRCOM")
)
(
TRCOM
OMS ("TRCOM")

1981

or
or
or
or

Micro

ED
ED
ED
ED

Data

=
=
=
=

)
(
LGENDX
oms
("LGENDX")
)
(
LGENDX
OMS ("LGENDX")

Base Systems,

Inc.

MDBS

DMS

MANUAL

MDBS

XVI.

DMS

MANUAL

COMMANDSTATUSDESCRIPTIONS

Overview

This chapter describes the different command status messages that
For each command
may result from the execution of a DML command.
and
255), the possible reasons for which that
status (other than
command status could be obtained are described.
In almost all cases,
a solution
suggest
the reasons themselves
to the problem.
O

Command

Status Details

**1**

Invalid

area

**1**

name

Possible Causes:
1. Typographical error in spelling area name.
2. Incorrect order in command
string.
3. Command
string not terminated properly.
**2**

Invalid

set

**2**

name

Possible Causes:
error in spelling set name.
l.2. Typographical
order in command string.
Incorrect
3. Command
string not terminated properly.
**3**

Invalid

record type

**3**

name

Possible Causes:
Typographical error in spelling record type name.
l.
2. Incorrect order in command
string.
3. Command
string not terminated properly.
**4**

Invalid

data

item for

this record

type

**4**

Possible Causes:
Typographical error in spelling data item name.
2. Incorrect order in command
string.
3. Command
string not terminated properly.

(C)

1981

Micro

Data

Base Systems,

Inc.

107

mDBS

DMS

MANUAL

**5**

Invalid

COMMAND

XVI.
owner

STATUS

MDBS

DMS

this set

record type for

MANUAL

**5**

Possible Causes:
The record occurrence
specified has not been defined as the
the
owner for
set specified.
2. Typographical error in spelling set name.

**6**

Invalid

record type for

member

this set

**6**

Possible Causes:
record occurrence
specified has not been defined as the
l. The
member
for the set specified.
2. Typographical error in spelling set name.
**7**

Invalid

data

block

**7**

name

Possible Causes:
data block specified in the command string has not been
l. Adefined.
2. A blank data block name was specified for a "DEFINE" command.
command does not immediately follow a "DEFINE"
3. An "EXTEND"
command.

Invalid

**8**

name

Possible Causes:
There was a syntax error related to
specification
in a DBOPN or DBOPNA command.
2. Invalid drive specification.

Invalid

**9**
Possible Causes:
An invalid
number

**10**

Syntax

was

filename

**9**

number

passed

error on

the

DBCNV

command

DBENV.

line

**10**

Possible Causes:
l. Self-explanatory.
Record

**11**

already member/owner

**11**

of set

Possible Causes:
attempt was made to connect a member record to an owner
l. Anrecord
for a set, when that member was already connected to
that owner for that set.
2. An attempt was made to connect
an owner record to a member
record for a set, when that owner was already connected to
that member for that set.
108

Rev.

83A

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

Record

**12**

COMMAND

- XVI.

MANUAL

does

not belong

STATUS

MDBS

Invalid

area

for

SOE)

Data

base

area

The

or DBOPNA (for
twice.
languages,
2. For interpretive

DBOPN

**15**

Data

base

given area) command was invoked
DBCLS

not consistent

Area

DBCLSA

was

not called.

not closed previously

possible Causes:
The data base may be inconsistent
previously.
**16**

record

**14**

already open

possible Causes:

command

**13**

this record type

possible Causes:
hasbeen specified intheCRAcoinwandandthe
l. Anarea
does
type
not belong to this area.
**14**

MANUAL

**12**

to set occurrence

Possible Causes:
Ttie record occurrence
specified by the SME (or
member
isnóta
or owner of the specified set.
**13**

DMS

**15**

since

with main area

was

not closed

**16**

Possible Causes:
A referenced area
was not consistent with the main area.
2. An old copy of the area was on-line rather than a copy
the area that is up-to-date with the on-line main area.

**17**

space

available in data

base

possible Causes:
No
space is available in the data
processing the requested transaction.

(C)

1981

Micro

Data

Base Systems,

Inc.

**17**

base or area

for

109

MDBS

DMS

MANUAL

**18**

comnands:
The error

is very
rare
CRS,

CRA,

for pointers

**19**

IMS,

occurs

MDBS

DMS

MANUAL

and is
lOS.

**18**

returned from the

to insufficient space being
allocated.

due
be

duplicate

STATUS

internally inconsistent

Set

possible Causes:
l. This error

COMMAND

XVI.

Following
available

record allowed

**19**

Possible Causes:
No
duplicates have been allowed in the
l. for
the record type.
**20**

Possible Causes:
l. Self-explanatory.
The user

should check
command.

DML

**21**
Possible Causes:

command
l. The
this set.
command
2. The

possible Causem

l.
2.

The

this
Tite

command

Rev.

85A

changed

FLO,

SOM,
FNO,

SQQ

SOU
SMC,

FPO,

was

not invoked

SMM,

SMO

status 255 previously.

SME,

SMC,

set.

command
FFM,
command

(C)

FL!4,

SMM,
FNM,

SMO
FPM,

SMU
SOC,

the

**21**

For
SMU

**22**

current member of set type

returned

110

the currency indicators

SOE,

SOC,

FEO,
command

**22**

**20**

current owner of set type

returned

specifications

current of run unit

DDL

was

not invoked

SOM,

SQQ

for
SOU

status 255 previously.

1981

Micro Data Base Systems,

Inc.

MDBS

DMS

MANUAL

**23**

Possible Causes:
2.

STATUS

The command
invoked
for
The command

CR,

CRS,SRC,SRM

this
DRC,

record type.

**24**

DRQ,

DRM,

current record of

this

SRO

ORR

record type.

Possible Causes:
is no current record of
l. There
indicator.

Possible Causes:
l. A referenced user-defined
Current of run

possible Causes:

The command
an argument,

indicated

MANUAL

**23**
previously

not

was invoked

for

user-defined

not allocated

**25**

has

not been allocated.

unit not in specified

has been invoked
and the current

area.
Inappropriate

the

referenced

indicator

FNS

**27**

was

**24**

User-defined currency indicator

**26**

DMS

current user record

**25**

MDBS

current record of record type

COMMAND

XVI.

**26**

area

with an area specified
of run unit is not in

the

**27**

set

Possible Causes:
For example,
set appeared as an argument.
l. Anthe inappropriate
last set specified in a Boolean command is not system—
2.

owned.
The
N:

first

**28**

second

set specified with

Inappropriate

Possible Causes:

(C)

FRK

command

has been

1981

Boolean

command

record type
invoked

type has not been declared as having

Micro Data Base Systems,

**28**
a
a

Inc.

record whose
calc key.
Rev.

85A

record

Ill

MDBS

DMS

MANUAL

**29**

Cannot

COMMAND

XVI.

STATUS

MDBS

DMS

obtain based on record type

MANUAL

**29**

Possible Causes:
attempt was made to obtain a record based on a sort
l. Aninvolving
the record type names. Use the corresponding
command
and GETC instead.
**30**

out of range

Data

The data being input is Óutside
the range
as indicated in the DDL specifications.
Tlie
value of an input argument to a DML
permissible value for that argument.

Insufficient

**31**

room

find

**30**

possible Causes:

key

of possible values
command

is not

in memory

**31**

Possible Causes:

languages
For
using the SETPBF command, not enough buffer
has
been
space
allocated.
For languages
not using the SETPBF command, the DMS has been
ORGed
too high in memory, or the FIRST and LAST word in
memory do not allow enough room.

**32**

Data

base opened

Possible Causes:
l.2. Self-explanatory.
Invalid read/write
**33**
based

**34**

read

Rev.

command.

**33**

conversion error

been
on the

obtained
DDL

such

ítem

during data
specifications.

conversion

**34**

routine

Possible Causes:
l. Typographical error in spelling

112

OPEN

2.
3.
4.

**32**

only

access

specifications

Data

possible Causes:
An
error has
l. MDBS.DMS

for

command

name.
cominands have been used without the RTL form of MDBS.
A command
using wrong entry point (DMS or DMSD).
was invoked
command
A
that attempted to perform explicitly
was invoked
disabled processing (e.g., disabled by NOCALC or NOFLOAT).
Logging

85A

(C)

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

COMMAND

- XVI.

MANUAL

STATUS

**35**

Duplicatedatablockname

±*35**

possible Causes:

The'

command was invoked

DEFINE

exists.

for

data

Possible Causes:
name/password
l. User
specifications.
Invalid

**37**

Too

many

**36**

Data

exactly

not

DNIL

base not

command

string.
**38**

open

needing to access the data base,
before the data base was opened.

command,

invoked

**39**

Set

Possible Causes:

The

FOSK

**40**

FMSK

command

User

may

read

access

1981

Micro

codes

Data

has

not sorted
is invoked

codes
of the

non-sorted set.
**40**

have no common elements
set being processed.

Base Systems,

been

**39**

not read this set

Possible Causes:
l. The user's read access
the

DDL

**37**

Possible Causes:

match

of arguments

specified

arguments

**38**

does

number

Possible Causes:

(C)

block that already

Invalidpassword

**36**

MANUAL

DMS

MDBS

Inc.

with

113

MDBS

DMS

MANUAL

- XVI.

**41**

User

COMMAND

STATUS

not write

may

MDBS

DMS

this set

MANUAL

**41**

Possible Causes:
user's write access codes have ñQ elements in common
l. The
with the write access codes of the set being processed.
**42**

User

not read

may

Possible Causes:
The user's read access

the

read

**43**

codes

access

User

**42**

codes have no elements
in common
of the record being processed.

not write

may

this record

**43**

Possible Causes:
elements
The user's write access codes have no common
the write access codes of the record being processed.

with

**44**

User

may

possible Causes:
l. The user's read access
the

read

access

User

**45**

codes

may

read

not

write

not

**44**

this item

codes have
of the item

with

elements
in common
being processed.

with

**45**

this item

possible Causes:
codes have no elements in common
The user's write access
codes
the
of the item being processed.
write access
with

User

**46**

may

not

possible Causes:
l. The user's read access
the

114

read

access

(C)

codes

read

this

area

codes

have

elements

of the specified

1981

Micro

**46**
in common with

area.

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

**47**

User

COMMAND

XVI.
may

STATUS

this

not write

MDBS

DMS

MANUAL

**47**

area

possible Causes:
The user's
in
write access codes have no elements
l. with
the write access codes of the specified area.
**48**

value labels defined for

Possible Causes:
l. The specified

field presently
Invalid

**49**

data

**48**

this field

has no

common

value labels.
**49**

base key

Possible Causes:
value input to the SCD command is not the data base key
l. The
a
for
valid record occurrence in the data base.
may
2. A record whose data base key was formerly saved by SDC
have since been deleted or moved.
**50**

Checksum

**50**

error

Possible Causes:
MDBS.DMS
automatically
closes the data base when
occurs.An
when a checksum
error was encountered

performed

**51**

on the

data

this error

base pages.

was

Disk read or write error

being

**51**

Possible Causes:
This command status is returned as a result of any I/O error.
MDBS.DMS
automatically closes the data base when this error
occurs. Some of the possible causes are:
sector on disk.
l.2. Bad
Disk drive misaligned.
3. The operating system has detected an error when trying
to read/write from/to disk.
Invalid

**52**

data

base

format

**52**

Possible Causes:
An
when the system
performed
a
error was encountered
MDBS.DMS
check
data
base
synchronization
on the
pages.
automatically
closes the data base when this error occurs.
This may mean that:
1. Disk is in the wrong drive.
2. The correct area disk is not on-line.

(C)

1981

Micro Data Base Systems,

Inc.

Rev.

85A

115

MDBS

DMS

MANUAL

XVI.

**53**

COMMAND

base

Dáta

STATUS

DMS

MANUAL

not expanded

Possible Causes:
The data base was initialized
l. was
not expanded with MDBS.DMU.
**54**

MDBS

**53**

with the

option,

Pile not present

but
**54**

Possible Causes:
l. Disk in wrong drive.
2. File name misspelled.
**55**

Log

file

I/O error

Possible Causes:
l. An I/O error was encountered
2.

file.
See
also

**56**

Command

**55**

when

trying

file

not current

log

**56**

Possible Causes:
l. The log file is not up-to-date.
Logging

inhibited

**57**

Possible Causes:
An I/O
error was detected on the log
l.
2. Ttte log file may already be open.
**59**

the

Status 51.

Log

**57**

to open

Needed area

not on-line

file.
**59**

possible Causes:
the result oF a DML command, the data base control system
l. As
attempted to reference an area that is currently off-line.
2. For record types, whose records can exist in any area, a CRS
invoked without having on-line the
was
first (as specified
in the DDL) extra area with sufficient space.
3. FFS or FNS was invoked
for an off-line area.
4. All areas allowing pointer indices were not on-line for data
base

**60**

alteration.

Data

base

not available

**60**

Possible Causes:
command
status is returned only when multiple users are
l. This
data base.
the
accessing
some
2. The user is not allowed to open the data base because
other user has opened the data base on an exclusive basis.
116

Rev.

85A

(C)

1981

Micro Data Base Systems,

Inc.

MDBS

DMS

MANUAL

**61**

COMMAND

XVI.

STATUS

MDBS

MANUAL

DMS

**61**

Exclusive open refused

Possible Causes:
command
status is returned only when multiple users are
l. This
accessing the data base.
2. An exclusive open was not granted as some other user had the
data base already open.
**62**

Operation rejected due to active lock

**62**

Possible Causes:
command
status is returned only when multiple users are
l. This
accessing the data base.
2. Ttte operation requested
since there was an
was not performed
active lock on the record or set specified.
3. The run
unit is attempting to access a record when the
deadlock
a
would
cause
access
granted,
request,
situation.
4. Tlie
error is issued after the waiting time specified with
MCC is exhausted.
5. T!ie run unit encountering this situation
can invoke NCI (and
TRABT,
and
This is
applicable)
restart its processing.
the run unit is in the midst of logging a
not advisable
complex transaction.

**63**

Operation rejected due to passive lock

**63**

Possible Causes:
command
status is returned only when multiple users are
l. This
the
data base.
accessing
2. Tkie
operation requested was refused as there was a passive
lock on the record specified.
3. Ttte run
unit is attempting to access a record when the
a
deadlock
would
access
cause
granted,
request,
situation.
4. The error is issued after the waiting time specified
with
MCC is exhausted.
5. Tlie run unit encountering this situation
can invoke NCI (and
TRABT,
This is
applicable) and restart its processing.
not advisable
the run unit is in the midst of logging a
complex transaction.
6. The SYSTEM
record cannot be actively locked because
is
always the current owner of every system-owned
set (i.e.,
is always passively locked).
"

Invalid

**65**
Possible Causes:

(C)

The
key.

CRA

1981

command

use

was used

CALC

for

**65**

record
a

Micro Data Base Systems,

record type having

Inc.

Rev.

calc

85A

117

MDBS

DMS

MANUAL

**66**

Record

COMMAND

XVI.

STATUS

Possible Causes:
retention
for the set specified
l. The
fixed in the DDL specifications.
**67**

coUnt

U8er
1.

Too many run
base.

**70**

transaction

declared

access

the data
**70**

in progress

command
TRCOM,
LGENDX
The TRABT,
or
complex transaction was in progress.
TRBGN
or LGCPLX has not been invoked.

was invoked

when

Transaction already in progress

**71**

Possible Causes:

The TRBGN
or LGCPLX
complex
transaction
LGENDX
command.

was invoked
was terminated by a
command

Possible Causes:
1.

command
The TRABT
without
was invoked
invoked
pifd.
PIFD has not been invoked
before opening

Posting table overflow

**73**

**71**
before

TRABT,

prior

the

TRCOM

Posting not active

**72**

**67**

exceeded

possible Causes:

MANUAL

**66**

has been

units attempted to concurrently
No

DMS

not'be removed from fixed set

may

possible Causes:

MOBS

**72**
having

previously

the data base.
**73**

Possible Causes:
command
status can be returned from TRCOM or TRABT when
l. This
posting is active.
2. The transaction is committed
to the data base, even though a
TRABT
was attempted.
3. Consider
defining several shorter transaction sequences
to
replace the existing transaction sequence.
**74**

Log

file

not present

**74**

possible Causes:
the RTL form of MDBS, the data base was opened without
l. Using
the log file being present. processing continues.
P

118

Rev.

85A

(C)

1981

Micro Mta Base Systems,

Inc.

MDBS

DMS

MANUAL

XVI.

COMMAND

STATUS

Unable

re-insert record into all sets

possible Causes:
1. The value

**75**

MDBS

DMS

MANUAL

**75**

sort key field changed and there was
the affected set
resorting
for removed
insufficient
from
is
occurrences.
all set occurrences
for which there is insufficient resorting room.
memory
The record

**80**

Load

error from

**80**

DMSLDR

possible Causes:
1. An attempt was made to load a non-executable
file.
2. There are presently too many operating system files open to
allow another to be opened.
Communications

**81**

Failure

**81**

Possible Causes:
This command status can appear only in versions of the system
that require interprocess communication (e.g., multiuser
versions).
2.
indicates
that an unexpected communication error was
encountered during interprocess communication (e.g., a user
tries to start a run unit while the data base control system
is not executing).

(C)

1981

Micro

Data

Base Systems,

Inc.

Rev.

85A

119

MDBS

DMS

MANUAL

COMMAND

XVI.

**100-199**

STATUS

MDBS

Catastrophic errors

DMS

MANUAL

**100-199**

Command

status errors lOó through 199 are particular cases of a
general "catastrophic" error, which would result in the integrity of
the data base being destroyed.
any of these extremely
rare command
status errors is obtained, the user should contact the Micro Data Base
Systems,
Inc. technical support staff for aid in solving the problem.
A few general notes
on some of these errors are provided below.

100

table inconsistency.
is on each

Hole

how much room
free bytes than
101

The table
page in this

which specifies
area
lists more
No

workaround.
itself lists.
An invalid record id was
record occurrence.
Invalid
encountered
when trying to determine the record type of
the record occurrence. If possible, remove this record
from

the page

the set.

103

find a connected record when resorting. When
reordering a sorted set, problems with set connections
This could happen only for a "put"
encountered.
are
commancL
No

Cannot

workaround.

104

Record

connected. When
order is next or
record was encountered.

not

into a set
connected

fully

whose

inserting a record
prior, a partially

106

comparison
operation.
item values, an invalid
record occurrence was encountered.

107

Pointer not found in higher level index (DPA) during
when moving
a
insertion.
Invalid pointer encountered
commands
Use
DPA.
Possible workaround:
Boolean
to
remove all members from
move all members into SSYSSET,
the original set, then reinsert the members back from

id encountered during
Invalid record
When
comparing
two

$SYSSET.

120

Rev.

determine item type. When trying to locate an
item, the data base control system could not find an
item type in the item descriptors.

108

Cannot

109

Cannot determine
An invalid record
key value.

85A

(C)

record type during
id was found when

1981

Micro

Data

"find" command.
building the sort
a

Base Systems,

Inc.

MDBS

DMS

MANUAL

XVI.

COMMAND

STATUS

MDBS

DMS

MANUAL

during insertion.
find pointer in higher level
when
encountered
Invalid pointer
splitting DPA.
Use
Boolean commands to move all
Possible workaround:
members
members
from the
into $SYSSET, remove all members
back
from
the
then
set,
original
reinsert
SSYSSET.

líO

Cannot

Ill

Cannot

removal.
find pointer in higher
level during
a record from
when removing
Invalid pointer encountered
a set.
possible workaround: Use Boolean commands to
move all members into $SYSSET,
remove all members from
the original set, then reinsert the members back from
$SYSSET.

112

SYSTEM

list
113

is not owner of
system-owned
set,
SYSTEM
as an owner.

Cannot

Invalid

a set.
This set is expected to
but the set descriptor does not

in higher level during insertion.
find pointer
DPAS
when
encountered
pointer

updating higher

Possible workaround:
after
first element has changed. members
Use Boolean commands to move
into $SYSSET,
all
from
then
members
reinsert
remove all
the original set,
members back from $SYSSET.
the

(C)

114

Record

116

when doing a
not found in set descriptor.
a
operation,
record was encountered that could
"find"
not be found in the set descriptor for this set.

117

SYSTEM

The
reference not found in DPA during removal.
record for which removal was attempted
is not
completely connected
in this set.
Record

When doing a "find"
record DPA not found.
operation, a record was encountered that could not be
found in the set descriptor
for this set.

1981

Micro Data Base Systems,

Inc.

Rev.

85A

121

MDBS

DMS

MANUAL

119

120

121

126

STATUS

possible,

Rev.

85A

DMS

MANUAL

remove

the record from the

When
checking for
not found in set descriptor.
encountered
that could not be
duplicates, a record was
found in the set descriptor
for this set.

Error

unable
descriptor was
Master

(C)

An invalid record id was
to determine the record type of
If possible, remove the record

record.
locating
when

trying
the record occurrence.
from the set.

122

MDBS

Record

encountered

130

Invalid record type in aset descriptor. a When doing a
record was
operation on
sorted set,
'find'
be
encountered
could
in
found
the set
not
that
descriptor for this set.
When removing a
Record not found in set descriptor.
from
a set, a record was encountered
that could
record
not be found in the set descriptor for this set.
Invalid record type encountered during Boolean
An invalid record id was encountered when
operation.
trying to determine the record type of the record
occurrence.
set.

124

COMMAND

XVI.

to deallocate user descriptor.
not found when processing user

1981

The user

logout.

Micro Data Base Systems,

Inc.

MDBS

DMS

MANUAL

MDBS

DMS

MANUAL

Appendix A

Obsolete DML Commands Available
with Version 3a

(C)COPYRIGFIT

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

MDBS

Appendix

DMS

MANUAL

Introduction

from MDBS Version
purposes
of upward compatibility
to N!DBS
3a,
and
command
commands
names are
Version
additional
alternative
in version 3a. The additional commands primarily involve
available
the use of a kind of currency indicator
not described earlier in this
3a,
Version
record
manual.
type has a current record,
In
every
DDL
invoked
provided the
with the -v option.
Analyzer was
At any
a
moment during the execution of a run unit, one occurrence
record
of
(CRO)
a
the
is
occurrence
of that record type.
type
current record
schema has nine record types,
there are nine currency indicators
beyond
Although these
those described earlier in this manual.
3a,
in
they are never
Version
additional currency indicators exist
LqgjjjLQg for processing;
they exist solely to provide upward
can
so that application
programs
compatibility
written for Version
be used by Version 3a with
only minimal (iii any) changes.

For

The

effects of a few Version 3 DML commands differ
slightly, in
their effect on currency indicators, from Version l commands of the
same name.
This manual fully explains the effect of each Version
command.
the
those
the FMSK,
Most
3

notable among
differences are
for
and ORO.
"wildcard"
In Version 3, the FMSK (FOSK)
feature leaves the current member (owner) indicator positioned at the
next record rather than the prior record as is the case with the
Version l FMSK (FOSK). The version 3 remove and delete commands do
not leave the set's current member (or current owner for ORO)
member (or owner)
indicator null as they do in Version l. The 3 next
SMM,
SMO and SMC do not
becomes current.
Also note that theVersion
command
when
They return a
a
12
there is no owner.
return
status of
command status of 255 in this situation.
the
Version 3 SMR
Similarly,
appendix)
command
a
255
(described in this
status, rather
will return
than a 12 as in version l.
FOSK,

B©

RMS,

DRN!

Alternative

Command

Alternative

Names

Command

(Supported
yqLsiQDs_l-aDsj-3aL
Name

Command

ACS
CLOSE
CMT
COT
ERRSET
FINDM
FINDO
OPEN
SFC
SFM
SFO
STAT
TOGGLE

(C)

1981

Name

y§Qd_jn_tbis-Manygl
IMS
DBCLS
TMT
TOT
VARCS
FMI

FOl
DBOPN
PFC
PFM
PFC)

DBSTAT
DBENV

Micro

Data

Base Systems,

Inc.

Rev.

82B

A-l

MDBS

DMS

MANUAL

The

Version 3a

DBENV,
DBOPN
and
TOGGLE,
OPEN
DBOPN
and DBSTAT

Additional

MDBS

TOGGLE,

DBSTAT
and STAT

OPEN

respectively)
commands.
manual.

this

MANUAL

commands

(while identical to
differ
slightly from the Version
See the descriptions of DBENV,

STAT

Commands

Add

m
Command

and

DMS

Member

to Set

and Arguments

AMS,rec,set-l
Currency

Indicators

tlseSk

CO(set-l)

cljangeg:

CRO(rec)

CM(set-l>'

CRO(rec)

Description
The record that is current
record occurrence of rec becomes
connected
of set-l. This new member for the
to the current owner
current owner of set—l is made the current member of set-l. The
member
insertion OF this new member record among the existing made
records, connected to the current owner of set-l, is
in
accordance with the member order declared tot set-l in the DDL
specification.
current record occurrence of rec must be an occurrence of a
record type that is a member of set-l. A user must have write
a member record to an owner
access to set-l, in order to connect
record.

The

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

A-2

(C)

ED
ED
ED

=
=
=
=

AMS
OMS
AMS
DMS

("rec,set-l")
("AMS,rec,set-l")
("rec,set-l")
("AMS,rec,set-l")

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MDBS

MANUAL

Becord

Create

Command

DMS

MANUAL

and Arguments

CR,rec

Indicators

Currency
tls£d:

...if

changQg:

none
rec

member

...if

is auto
of set

rec

member

created record

CO(autoset)<——newly

CM(autoset)

of the record type
No

is AUTO
of set
AUTO

AUTO

occurrence
has no data.

created record
created record

...ifownerrec ofis set

...ifownerrec ofis set
An

<——newly

CM(autoset)<——newly

CO(autoset)

Description

cru
CRO(rec)

range

checking

rec is created.
is performed.

This occurrence

physical placement of the newly created record is consistent
with the DDL specification
for rec (either CALCed, clustered, or
system-determined).
In order to create the record, a user must
have write access to rec, to the area in which the record is to
be created, and
to all sets in which the record type participates
a user does
as an automatic owner or member.
not have this
If
command
a
returned,
the
clearance,
status
security
error is
record is not created, and no currency indicator is changed.

The

rec has been declared to be the AUTO member of
If
newly created record is automatically connected
and the new
becomes the
owner of

set, then the
to the current
that set
record
current member
The
takes
place
of that set.
connection
according to the member
(SORTED,
DDL
the
the member
FIFO,
order specified with
etc.).
If
NEXT,
order for the set is
then the new record is connected
inserted) immediately after the set's current
(i.e.,
logically
no current
member.
member, the record is inserted as
If there is For
PRIOR member order, the new record is
the first member.
before the set's current member.
logically connected immediately
member,
no
there
the
record is insertedas the last
current
is
If
a

member.

(C)

1981

Micro

Data

Base Systems,

Inc.

A-3

MDBS

DMS

MANUAL

MDBS

rec has been declared
If
newly created record

to be the

DMS

MANUAL

of a set, then the
is automatically connected to the current
member of that set and the new record becomes the current owner
of that set. The connection occurs according to the set's owner
order, as specified with the DDL (SORTED, LIFO, NEXT, etc.). IE
the owner order for the set is NEXT (or PRIOR), then the new
record is logically connected
immediately after (or before) the
the record is
set's current owner.
there
is
no current owner,
If
inserted as the first (last) owner.

Examples

oft

Command

...
...
...
record/indirect...

ED
ED
ED

Delete Becord

Command

owner

Usage

block/direct
block/indirect
record/direct

RRB

AUTO

= CR
= OMS
= CR
= OMS

("rec")
("CR,rec")
("rec")
("CR,rec")

that is current Becord

occurrence

ORR

and Arguments

DRR,rec
Currency

Indicators

RsU:

CRO(rec)

CbqLjgqsj:

CRO(rec)
CRU

null
null

also see description
Description
The record that
disconnected from

is the current recordandoccurrence Qt rec is
is physically deleted
set relationships
all The
from the data base.
current record oÍl rec and the current of
run unit becomes null.
If the deleted record is the current
owner of any set, the current member of any set, or the current
record of any user-defined
indicator, then those indicators
does not have write access to the current
a user
become null.
If
of run unit's record type, to the record's area and to all sets
then no deletion occurs,
in which that record type participates,
and
command
a
changes,
no currency indicator
status error is
returned.

Examples

Command

block/direct
block/indirect
record/direct

Usage
ED

.e.

...
...
record/indirect...

A-4

(C)

ED
ED
ED

= DRR
= DMS
= ORR
= DMS

("rec")

("DRR,rec")

("rec")

("DRR,rec")

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

MDBS

GETB

data

GET

Command

from

DMS

MANUAL

GETB

Becord

and Arguments

GETR,rec,oblk
Currency

Indicators

tláM:

CRO(rec)

cjjaRge!a:

none

Description
of rec are
All data values in the current record occurrence
returned in the host language variables oblk. The types, sizes
and sequence of these variables must be consistent
with the data
items that make up the rec record type. A command status error
a user does not have read access
to all data items
is returned
of the rec record type.

Examples

Command

block/direct
block/indirect
recorá/direct

Usage
ED

...
...
...

=
=
=
=

ED
ED

record/indirect...

("rec,ob1k")
("GETR,rec,oblk")
("rec",oblk)
("GETR,rec",oblk)

GETR
OMS
GETR
DNISD

GEB

Eield from Elecord

Get

Command

GEB

and Arguments

GFR,itm,rec,oblk
Currency

Indicators

tjseGk

chang£g:

CRO(rec)

none

Description
The value of the item data item (field) in the current record
occurrence ofi rec is returned in the host language
variable of
ob1k.
The type and size of this variable must be consistent with
A command
the type and size of itm in the DDL specification.
a
does
have
user
read access to
status error is returned
not
the itm field.

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

(C)

1981

Micro

ED
ED
ED

=
=
=
=

GFR
OMS
GFR
DMSD

Data

("itm,rec,oblk")
("GFR,itm,rec,oblk")
("itm,rec",oblk)
("GFR,itm,rec",oblk)

Base SYstems,

Inc.

A-5

MDBS

DMS

MANUAL

MDBS

PÍIT data

EñTB

Command

DMS

MANUAL

into Record

PñTR

and Arguments

pUTR,rec,iblk
Indicators

Currency

tl§üi:

CRO(rec)

chang£g:

none

Description

values of the iblk host language variables put into the
of rec. The types, sizes and sequence
current record occurrence
oft these variables
must be consistent
with the data items that
A command status
make up the rec record type.
error is returned
the user does not have write access to all data items that
make up the rec record type and to the area containing
the record
A command
the
to be changed.
status error is also returned
value of an ib1k variable is outside the feasibility range
defined for the corresponding data item.
Data

Examples

Command

block/direct
block/indirect
record/direct

Usage
ED

...
...
...

record/indirect...

SCB

Set

Command

ED
ED
ED

=
=
=
=

PUTR
OMS
PUTR
DN!SD

("rec,iblk")
("rec",iblk)

("PUTR,rec,iblk")
("PUTR,rec",iblk)

Current of run unit based on Becord

SCB

and Arguments

SCR,rec
Currency

Indicators

tlscsi:

changQsj:

CRO(rec)

cru<

Description
The record that is presently the current record occurrence
of rec
The current record
becomes
the new current oÍl run unit.
occurrence of rec remains unchanged.
If the user does not have
read access to rec, a command status error is returned and the
current of run unit is unchanged.
Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

A-6

(C)

ED
ED
ED

=
=
=
=

SCR
DMS
SCR
OMS

("rec")

("SCR,rec")

("rec")

("SCR,rec")
1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MDBS

MANUAL

DMS

SEB

Store Eield into Becord

SEB

Command

MANUAL

and Arguments

SFR,itm,rec,iblk
Currency

Indicators

USWj:

changeg:

CRO(rec)

none

Description
The value of the iblk host language variable is put into the itm
Eield of the current record of rec. A command status error is
the user does not have write access to itm andtothe
returned
A command status
area containing the record to be changed.
error
the value of ib1k's variable is outside of
is also returned
itm's feasibility range.

Examples

Command

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

=
=
=

ED
ED

Set

SMB

Command

SFR
DMS
SFR
DMSD

Member

("itm,rec,iblk")
("itm,rec",iblk)

("SFR,itm,rec,iblk")
("SFR,itm,rec",ib1k)

based

on Becord

and Arguments

SMR,rec,set-l
Currency

Indicators

tlá,oá:

CRO(rec)

Ch4ngeg:

CRO(rec)
CM(set-l) (
CO(set-l)<——first
owner
CRU
<——first owner

Description
Set the current member of
to be the same as the current
set-l
command
This
of
isvalidonly
occurrence
rec.
rec is a member
record type for set-l. The first owner of the new current member
of set—l becomes the new current owner of set—l and the current
of run unit. If the new current member of set—l becomes null,
the current of run unit becomes null and a command status of 255
is returned.
If a user does not have read access to both set-l
and rec, then a command status error is returned and no currency
indicators change.

(C)

1981

Micro

Data

Base Systems,

Inc.

A-7

MDBS

DMS

Examples

MANUAL

MDBS

Command

MANUAL

Usage

block/direct
block/ináirect
record/direct

...
...
...
record/indirect...

SQB

ED
ED
ED

=
=
=
=

("rec,set-l")

SMR
OMS
SMR
DMS

("SMR,rec,set-l")
("rec,set-1")
("SMR,rec,set-l")

Qwner based

Set

Command

DMS

on Becord

SQB

and Arguments

SOR,rec,set-l
Currency

Indicators

9sésí:

CRO(rec)

ChqRged:

CRO(rec)
CO(set-l) (
CM(set-l)<——-first member
CRU
<——£irst member

Description
Set the current owner of set—l to be the same as the current
occurrence of rec. This command isvalidonly
rec is an owner
record type for set-l. The first member of the new current owner
of set-l becomes tbe new current member of set-l and the current
of run unit. If the new current owner of set-i becomes null, the
current of run unit becomes null and a command status of 255 is
a user does not have read access
returned.
to both set—l and
If
command
a
status error is returned and no currency
rec, then
change.
indicators

Examples

Command

Usage

block/direct

block/indirect ...
.0.
record/direct
...
record/indirect...
SRC

Set

Command

ED
ED
ED

Record

=
=
=
=

("rec,set-l")
("rec,set-l")

SOR
DMS
SOR
DMS

based

("SOR,rec,set-i")
("SOR,rec,set-l")

Current of run unit

SRC

and Arguments

SRC

Currency

Indicators

9áM:

A-8

chang£sj:

cru

(C)

crq(

1981

cru

Micro

oata

Base Systems,

Inc.

MDBS

DMS

MDBS

MANUAL

DMS

Description
The record that is the current
of run unit becomes
of
record
occurrence
record
type.
current
its
Examples

Command

the new

Usage

block/direct
block/indirect
record/direct

...
...
...
record/indirect...

ED
ED

)

(

= SRC
= DMS
= SRC
= DMS

("SRC")
)

(

("SRC")

based

Elecord

Set

SRM
Command

MANUAL

Member

and Arguments

SRM,set-l
Indicators

Currency

WCSi:

CM(set-l)

CbaRged:

cro<

CM(set-l)

Description
The record that is the current member of
of its type.
current record occurrence
Examples

Command

lock/direct

becomes

the new

Usage
ED

block/indirect ...
...
record/direct
...
record/indirect...

=
=
=

ED
ED

SRM
DMS
SRM
DMS

Set

SEN
Command

set-l

("set-l")
("SRM,set-l")
("set-l")
("SRM,set-l")

Elecord

to Null

SEN

and Arguments

SRN,rec
Currency

Indicators

u=+

chgngesj:

none

CRO(recA

null

Description
The current

record occurrence for the rec record type becomes
read access to rec,
then the
null. If a user does not have
and a command status error
unchanqed
is
current record occurrence
is returned.

Examples

of Command
block/direct
block/indirect
record/direct
record/indirect

(C)

1981

Usage
ED

...
...
...
...
Micro

ED
ED
ED

=
=
=
=

Data

SRN
DMS
SRN
DMS

("rec")

("SRN,rec")

("rec")

("SRN,rec")

Base Systems,

Inc.

Rev.

83A

A-9

MDBS

DMS

MDBS

MANUAL

Bécord

Set

SRQ

Command

based

DMS

MANUAL

áBQ

on Qwner

and Arguments

SRO,set-l
Currency

Indicators

Uáé9:

CO(set-l)

chángQg:

CRO%——CO(set-l)

Description
The record that is the current owner of set—l
of its type.
current record occurrence
Examples

Command

...
...
...
record/indirect...

Rev.

83A

the new

Usage

block/direct
block/indirect
eecord/direct

A-lO

becomes

(C)

ED
ED
ED

= SRO
= DMS
= SRO
= DMS

("set-l")
("set-l")

("SRO,set-l")
("SRO,set-l")

1981

Micro

Data

Base Systems,

Inc.

MDBS

DMS

MANUAL

MDBS

Appendix

DML Command Formats

(C)

1981

Micro

Data

Base Systems,

Inc.

DMS

MANUAL

MDBS

DMS

Appendix

MANUAL

arguments).
AMM,set-l,set-2,set-3.
AMO,set-l,set-2,set-3.
AOM,set-l,set-2,set-3.
AOO,set-l,set-2,set-3.
AUI,iblk . . . . . . .
CCU,iblk . . . . . . .
CRA,rec,area,iblk.
. .
CRS,rec,iblk . . . . .
ALTEOS

(no

.
.
.
.
.
.
.
.
.
.
.
.
.

(no arguments)
.
DBCLSA,area.
. . . . .
DBCNV,ib1k
. . . . . .
DBENv,iblk
. . . . . .
DBINIT,host language variable
DBOpN,iblk
. . . . . . . . .
DBOPNA,area,iblk
. . . . . .
DBSAVE
(no arguments). . . .
DBSEL,host
language
variable
DBSTAT,ob1k.
. . . . . . . .
DBCLS

DEFINE,blk,list.

.
.
.
.
.
.

.
.
.
.
.
.
.

DNSSjP,host
language
DRC
(no arguments)

DRM,set-l.

.
.

DRO,set-1.

.
.

EXTEND,blk,list.
FDRK,rec,iblk.
FFM,set-l. . .
FFO,set-l. . .

.
.
.

.
.
.
.
.
.
.

(area

FNOI,itm,set-l,iblk.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

FNOSK,set-1,iblk . . . . .
(area is optional).
FNS,area

FOl,item,set-l,iblk.
FOSk,set-l,ib1k.
FPM,set-l. . .

.
.

FPMSK,set-l,ib1k
FPO,set-l. . . .

.
.

FPMI,itm,set-l,iblk.
FPOl,itm,set-l,iblk.
FPOSk,set-l,iblk
FRK,rec,ib1k .
GETC,oblk.

.
.

GETM,set-l,oblk.
GETO,set-l,oblk.
GFC,itm,oblk . .
GFM,itm,set-l,oblk
GFO,itm,set-l,oblk

(C)

.
.
.
.
.
.

1981

.
.
.
.
.
.
.
.

.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.

jump description,command

is optional).
FLM,set-l. . . . . . . . .
FLO,set-l. . . . . . . . .
FMI,item,set-l,ib1k.
. . .
FMSK,set-l,ib1k. . . . . .
FNM,set-l. . . . . . . . .
FNMI,itm,set-1,iblk.
. . .
FNMSK,set-l,iblk . . . . .
FNO,set-l. . . . . . . . .
FFS,area

.
.

MDBS

Micro

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

Data

Base Systems,

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

status array

Inc.

MANUAL

DMS

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

Rev.

.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.

89-90
. .82
. .83
83-84
84-85
67-68
68-69
54-55
55-56
. .69
. .70

70-70.1
70.1-70.2
. .90
71-72
72-73
73-74
. .90
. .74

.90.1
.90.2

63-64
. .64
. .65
90.2-91
. 12-13
. . .13
. . .14
. 14-15
. . .15
. 15-16
. 16-17
. 17-18
. . .18
. . .19
. 19-20
. 20-21
. 21-22
. 22-23
. 23-24
. . .24
. . .25
. . .26
. 26-27
. 27-28
28-28.1
.
.
.
.
.
.
.
.
.

85A

.28.1
.28.2
.28.3
.
.
.
.
.
.

.30
.30
.31
.31
.32
.32

B-l

MDBS

DMS

Appendix

MANUAL

GMC,set-1,oblk

GOC,set-1,oblk
GTC,oblk

.
.
.
.
.
.
.

.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

GTM,set-l,oblk
GTO,set-l,oblk
1MS,set-l. . .
IOS,set-l. . .
LGCPLX
(no arguments).
LGENDX
(no arguments).
LGFILE,iblk. . . . . .
LGFLSH
(no arguments).
LGMSG,iblk
. . .
MAU,iblk
. . . .
MCC,iblk
. . . .
MCF (no arguments)
MCP (no arguments)

MpL,iblk
MRTF,rec
MRTP,rec

MSF,set-l

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

(set-l is optional).

ONC)Sk,set-l,b1k.

OOI,itm,set-l,b1k.
OOSK,set-1,blk .
OPM,set-1,oblk .
OpMl,itm,set-l,blk
OPMSk,set-l,blk.
OpO,set-l,ob1k .
OPOI,itm,set-l,b1k
OpOSK,set-l,blk.
ORK,rec,b1k.

85A

.
.
.
.
.
.
.
.
.

.
.

.
.
.

.
.

.
.
.
.
.

pUTM,set_l,iblk.
pUTO,set—l,iblk.
RMS,set-l. . . .
ROS,set-l. . . .
.
.

.
.
.
.
.

.
.

pFC,itm,iblk
pFM,itm,set-l,iblk
pFO,itm,set-l,ib1k
PIFD,ib1k. . . .

Rev.

ONO,set-l,oblk .
ONOl,itm,set-l,blk

B-2

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

ONMSK,set-l,b1k.

RSO,set-l.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

OFM,set-1,oblk .
OFO,set-1,oblk .
OLM,set-l,ob1k .
OLO,set-Í,ob1k .
OMl,itm,set-1,blk.
OMSk,set-1,blk .
ONM,set-l,oblk .
ONMI,itm,set-l,b1k

RSM,set-1.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

(rec is optional)

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.

MSP,set—1.
. . .
NCI (no arguments)
ODRK,rec,blk
. .

PUTCfib1k.

.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

(C)

.
.
.
.
.

.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
O

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
e

.
0

.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
e

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
0

.
.
.
.
.
.

B
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
C
8
G
e

.
.
.
.

1981

MDBS
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
©

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
e
¢

.
.
.
.
.

Micro

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
0

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
·
C

.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
a

.
.
.
.
.
.
.
.
.
.
.
.
.
.
e

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

Data

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
,
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.

.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

DMS

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

MANUAL
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

Base Systems,

.75
.75
.76
.76
.77
57-58
. .58
. 105
. 106
. 102
. 103
. 103
95-96
. .96
96-97
. .97
. .91
. .98
. .98
. .99
. .99
. .77
.
.
.
.
.

.32.1
.32e2

.32.3
.32.4
.32.5
.32.6
.32.7
.32.8
.32.9

32.10
32.11
32.12
32.13
32o14
32.15

32A6

32.17
32.18
32.19
32.20
32.21
32.22
. .34
34-35
. .35
. 104
.
.
.
.
.

e36
Á36
A37

.59
.60
60-61
. .61

Inc.

MDBS

DMS

Append

MANUAL

SCD,iblk

.
.

.
.
.

.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.

SOU,set-l,iblk
SUC,iblk . . .
SUÉ1,set-l,iblk
SUN,iblk . . .
SUO,set-l,iblk
SUU, iblk
. . .

.
.
.
.
.
.

TCT,rec. . .
Tl4fI,set-l. .
TMT,rec,set-l.
TON,set-l. .
TOT,rec,set-l.

.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

\I,set-l.
(no arguments)

sC:
SCN

SCC,set-l.

iblk
SDC,ob1k

SCU,

SETPBF

.
.

,list. .

st4C,set-l.
SP1E,set-l.
S2·1!¿:

,set-l,set-2.
S14N,set-l.
SMO,set-l,set-2.
SK7U,set-l,iblk
SOC,set-l. . .
SOE,set-l. . .
SOi·l,set-l,set-2.
sON,set-l. . .

.
.
.

SOO,set-l,set-2.

(no arguments)

TCN

TRABT
TRBGK
TRCOFÍ

.
.
.

(no arguments)
(no arguments)
(no arguments)

TUN,iblk

(no arguments)
VARC2'D,host language
vARCs,host
language
UNDEF

x!·Il·l,set-l,set-2,set-3.
xb!O,set-l,set-2,set-3.
XOM,set_l,set-2,set"3.
XOO,set_l,set"2,set_3.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.

.
.
.
.
.

variable.
variable
.
.
.
.

.
.
.
e

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

ix
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
C

MDBS

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
C

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
0

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

DMS

. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . . . .
. . . ¢ . .
e
. . . . .

MANUAL

. . .40.1
40.1-40.2
. . .40.2
. . .40.2

. . .41
. 41-42
. . .92
. 42-43
. . .43
. 43-44
. . .44
. 44-45
. . .45
. . .46
. 46-47
. . .47
. 47-48
.4(3
. . .
. . . .49
. . 49-50
. . . .50
. . 50-51
. . . .51
. . . .52
. . . .78
. . . .78
. . .78
. .
. .
. .
. . . 104
. . . lOS
. . . 106
. . . .79
. 92-92.1
. .
. .
. . 85-86
. . . .86
87
. . . .
88
. . . .

.
.
.
.
.
.
.
.
.
.
.
.
.

.78.Í.l
.78.2
.78.2

.92.1
.92.1

(C)

1983

Micro

Data

Base Systems,

Inc.

Rev.

85A

B-3

MDBS

DMS

ALTEOS
AMM
AMO
AOM
AOO

AUI
CCU
CRA
CRS
DBCLS
DBCLSA
DBCNV
DBENV

DBINIT
DBOPN
DBOPNA
DBSAVE
DBSEL
DBSTAT

DEFINE
DMSSJP
DRC
DRM
DRO
EXTEND
FDRK
FFM
FFO
FFS
ELM
FLO

FMI
FMSK
enm
FNMI
FNMSK
FNO

FNOI
FNOSK
ENS

FOl
FOSK
F'PM

FPMI
FPMSK
FPO

FPOI
FPOSK
F'RK
GETC
GETM
GETO
GFC
GFbi
GFO

(C)

INDEX

COMMAND

MANUAL

(áL,Ter End Qf Get) . . . . .
(And of Éíeirbers with ñembers).
(dnd of Members with Qwners)
(And of Qwners with Members)
(And of Qwners with Qwners).

.
.
.
.
.

.
.
.
.
.
.

MDBS

.
.
.
.
.
.

(Qata Ease CLoSe).
. . . . . . . . . . . .
(l2ata Base CLo8e for Área)
. . . . . . . .
(Qata Ease format Couversion)
. . . . . .
(Qata áase =ironInent). . . . . . . . . .
(Qata Base control system
(Qata Ease QQEeN)
. . . . . . . . . . . . .
(Qata Ease CLlZeN Área). . . . . . . . . . .
(Qata Ease SAJLZ) . . . . . . . . . . . . .
(Qata Ease 2EL,ection). . . . . . . . . . .
(Qata Ease S=Tistics)
. . . . . . . . . .
(ñFFTNF data block).
. . . . . . . . . . .
(QEIS Set jum2)
. . . . . . . . . . . . . .
(Delete Record that is Current). . . . . .
(Qelete Record that is qember) . . . . . .
(Delete Record that is Qwner). . . . . . .
(?YTFNn data block).
. . . . . . . . . . .
(Eind Quplicate Eecorá based on calc Key).
(Eind Eirst Member).
. . . . . . . . . . .
(Eind Eirst Qwner) . . . . . . . . . . . .
(Eind Eirst Sequential record) . . . . . .
(Eind Last Member) . . . . . . . . . . . .
(Eind Last Qwner).
. . . . . . . . . . . .
(Eind Member based on data Ltem) . . . . .
(Eind áesiíber based on áort XéY). . . . . .
(EiM Kext pjenber) . . . . . . . . . . . .
(Eind Sext üember based on data íteni). . .
(Eind Next Meniber based on Sort Xey . . .
(Eind Xext Qwner).
. . . . . . . . . . . .
(Einá tlext Qwner based on data ítem)
. . .
(Eind Next Qwner based on Sort Kq/). . . .
(Eind Wext &equential record). . . . . . .
(Eind Qwner based on data Lteín). . . . . .
(Eind Qwner based on Sort iíey) . . . . . .
(Eind 2rior Member).
. . . . . . . . . . .
(Eind 2rior Member
based on data ítem)
. .
(Eind 2rior Élember
based on áort XéY . . .
(Eind 2rior Qwner) . . . . . . . . . . . .
(Eind 2rior Qwner based on data Ltein). . .
(Eind Erior Qwner based on áort Key) . . .
(Eind Record based on calc Key). . . . . .
(GET
data from Current of run unit). . . .
(GET
data from ¿¡ember) . . . . . . . . . .
(GET
data from Qwner). . . . . . . . . . .
(Get Eield from Gurrent of run unit)
. . .
(Get Eield from Member).
. . . . . . . . .
(Get Eield from Qwner) . . . . . . . . . .

1981

t4icro

Data

Base Systems,

Inc.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.

89-90
81,82
81,83

.
.
.
.
.
.
.

.
.
.
.
.
.

67-68
68-69
54-55
55-56
. .69
. .70

72-73

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.

.
.

.
.
.
.
.
.

.
.
.
.
.

.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.81,83-84
.81,84-85

70-70.1
70.1-70.2

68,69,71-72,103
9,69,73-74,104

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.

.
.
.
.
.
.

(AHocate jjser Lndicators) .
(Check Current of run unit against User indicator)
(Create Record in Area). . . . . . . . . . . . .
(Create Eecord and átore).
. . . . . . . . . . .

MANUAL

DMS

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

Rev.

72,90.1
. .90.2
.
.
.
.
.

63-64
. .64
. .65

.90.2

12-13

.13,18,40
.14,20,40
.
.

.
.

.
.
.

14-15
15,24

.15-16,24
.16-17,19

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.90
.74

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.

17-18
. .18
. .19
.19-20
20-21
21-22
22-23
23-24
. .24
. .25
. .26
26-27
27-28
28-29

.28.1
.28.2
13,28.3

85A

.
.
.
.
.
.

.30
.30
.31
.31
.32
.32

CI-l

MDBS

DMS

GMC
GOC
GTC
GTM
GTO

IMS
lOS
LGCPLX
LGENDX

LGFILE
LGFLSH
LGMSG
MAU
MCC
MCF
MCP
MPL
MRTF
MRTP
MSF
MSP

NCI
ODRK
OE?M

OFO
OLM
OLO
OMI
OMSK
ONM
ONPQI
ONMSK
ONO
ONOI
ONOSK
OOI
OOSK
OPM
OPMI
OPMSK
OPO
OPOI
OPOSK
ORK
PFC
PFM
PFO

PIFD
PUTC
PUTM
PUTO

ROS
RSM
RSO

CI-2

(Get Me%er Count)
. . . .
(get Qwner Count). . . . .
(Get Type of >rrent of run
(Get Type of Member) . . .
(Get Type of Qwner).
. . .
(Lnsert Member into áeU .
(Lnsert Qwner into Set). .
(LOG

Index

Command

MANUAL

start of

ComELe&

.
.
.
.
.
.

MDBS

.
.

.
.
.
.

unit).

transactions).

.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.

(LoG ENIZ compleX transactions)
. © .
(LoG UÁE specification)
. . . . . .
(LOG
buffer El,uSR). . . . . . .
(LOG
Me&saGe) . . . . . . . . .
(Multiuser Active Aser indicators.
.
(Multiuser Contention Count) . . . .
(9ultiuser Gurrent of run unit Eree). .
(Multiuser Gµrrent of run unit 2rotect).

file
file

(Multuser
(Multiuser
(Multiuser
(Multiuser
(Multiuser

j,eve1). .
Eriority
Record
Eree)
Type
Record Type
áet Eree) .

.
.

Erotect).
.

.
.
.
.

.
.
.
.
.
.

.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
,

.
.

.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.

.
e

.
.
.
.
.
.

.
.
.
.
.
.
.
.

.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

áet 2rotectC . . .
.
(]$[ull
Currency
Lndicators)
.
all
(Qbtain Quplicate Record based on calc Sey).
(Qbtain Eirst Member). . . . . . . . . . . .
(Qbtain Eirst Qwner) . . . . . . . . . . . .
(Qbtain Last Member) . . . . . . . . . . . .
(Qbtain Last Qwner). . . . . . . . . . . . .
(Qbtain Member based on data Ltem) . . . . .
(Qbtain Member based on áort Key). . . . . .
(Qbtain Next Member) . . . . . . . . . . . .
(Qbtain Next Member based on data Ltem). . .
(Qbtain Next [jember based on Sort Key) . . .
(Qbtain Next Qwner). . . . . . . . . . . . .
(Qbtain Next Qwner based on data Ltem) . . .
(Qbtain Next Qwner based on 8Qrt Xey)e . . .
(Qbtain Qwner based on data Ltem). .
. . .
(Qbtain Qwner based on Sort &ey) . .
. . .
(Qbtain Zrior KeMer). . . .
. .
. . .
(Qbtain Ejñor Me%er based on data Ltem) . .
(Qbtain Erior Member based on Sort Key). . .
(Qbtain EMor Qwner) . . . . . . . . . . . .
(Qbtain 2rior Qwner based on data Ltem). . .
(Qkitain Erior Qwner based on áort Key) . . .
(Qbtain Record based on calc Key). . . . . .
(2ut data into Eiéld of Current of run unit)
(2út data into EiUd of Member). . . . . . .
(2ut data into Eield of Qwner)
. . . . . .
(2age Lmage Eile Qeclaration)
. .
. .
(EñT data into Current of run unit). . . . .
(E9T data into Member) . . . .
. .
.
(EAT data into QwnerA
. .
.
.
.
O

(Zemove MeMier from Get)
(Remove Qwner from Set).
(Remve
,aet Members)
(Bemove
aet Qwners).

all
all

Rev.

85A

(C)

.
.
.
.

€

.
.
.
.

1981

.
.
.

.
.
.
.

Micro

.
.
.

.
.
.
.

Data

.
.
.
.
.

.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.

.
.
.
.

.75
,75
.76
. . .
.76
. . .
.77
. . .
. . . 57-58
. . . . .58
O
. . . 105
C
. . . 106
Q
. 101,102
101-102,103
.
.

.
,

.
.

.
.
.

.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.

l0l,102,103
.

.
.
.
.
.
.

MANUAL

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.32.1
.32©2

.32.3
.32.4
.32.5
.32.6
.32.7
.32.8
.32.9

32o10
32.11
32.12
32.13
32.14
32.15
32.16
32.17
32.18
32.19
32.20
32.21
32.22
. .34
34-35
. .35

o9,69,72,l01,l04

DMS

.
*

.
.
.
.
.

Base Systems,

35—36

Inc.

MDBS

DMS

SCI)
SCM
SCN
SCO
SCU
SDC
SETPBF
SMC
sme
SMM
smn
SFK)
SMU
SOC

soe
SOM
SON
SOC)

SOU

suc
SUM

sun
SUO
SUU
TCN
TCT
TMN
TMT
TON
TOT
TRABT
TRBGN
TRCOM
TUN
UNDEF
VARCMD
VARCS
XMM
XMO
XOM
XOO

(C)

Command

MANUAL

unit to Qata base key) . . . .
unit based on Menber). . . . .
unit to 19ull). . . . . . . . .
unit based on Qwner) . . . . .
unit based on Eser indicator).
(&ave Data base
for Current of run unit) . . .
(SEL 2age E,uEfer region) . . . . . . . . . . . . .
(Get Me1nber based on Qirrent of run unit). . . . .
(Set jjember to current of run unit (Exception)).
.
of
of
of
of
of

(Get
(Set
(Get
(Set

Current
Qirrent
Current
Current
(áet Current

run
run
run
run
run
key

Member based on MeInber) . . . . . . . . .
(aet Member to Null) . . . . . . . . . . . . .
(&et Member based on Qwner).
. . . . . . . . .
(Get Kember based on Rser indicator)
. . . . .
(&et Qwner based on Cjirrent of run unit)
. . .
(aet Qwner to current of run unit (Exception))
(Set Qwner based on WeMer). . . . . . . . . .
(Set Qwner to NU1). . . . . . . . . . . . . .
(det Qwner based on Qwner) . . . . . . . . . .
(Set Qwner based on Bser indicator). . . . . .
(Set fjser indicator to Current of run unit). .
(Set 9ser indicator to Member) . . . . . . . .
(&et gser indicator to NUI) . . . . . . . . .
(áet Rser indicator to Qwner). . . . . . . . .
(áet user indicator to Bser indicator) . . . .
(Test Current of run unit for 19ull). . . . . .
(Fest Current of run unit Tj,'pe).
. . . . . . .
(Fest Member for Mull) . . . . . . . . . . . .
(Test Member fype) . . . . . . . . . . . . . .
(Test Qwner for NUI). . . . . . . . . . . . .
(Test Qwner Type). . . . . . . . . . . . . . .

(Bet

(TEransaction WorT)

.
.

(TEXansaction

ReGiN)

(=ransaction

=mit).
Null) .

(Test jlser for
(TjNljEFine data

(=iable
(UEiable
(eXclude
(eXclude
(eXclude
(eXclude

for
for

blocks)

CoZLmanQ
Gommand

Members
MeInbers
Qwners
Qwners

1981

Micro

.
.
.
.
.

string).

Status).

from Members)
from Qwners).
from Members).
from Qwners) .

Data

.
.
.
.
.
.
.
.
.
.
.

Base Systems,

.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
e

.
.
.
.
.
.
.
.
.
.
.

Inc.

.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.

MANUAL

DMS

MDBS

Index

.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.

. . .40.1
40.1-40.2
. . .40.2
. . .40.2
.
.
.
.
.
.
.
.
.
.

.
.
.
.
.
.
.
.
.
.

. .41
41-42
89,92
42-43
40,43
43-44
40,44
44-45
. .45
39,46

.
.
.
.
.
.
.
.
.
.
.
.
.

.40,46-47
.47

.41,47-48
. .48
. .49
49—50

. .50
50-51
. .51
. .52
. .78
. .78

.78.1
.78.1
.78.2
.78.2

.l0,l0l,l04

.10,l01-l02,105
. . .10,l0l,106
.
.
.
.
.
.
.
.

Rev.

.79

.
.
.
.

.
.
.

81,86
82,87
82,88

92-92.1
. .92.1
. .92.1
.81,85-86

85A

CI-3

MDBS

DMS

Command

MANUAL

This page

CI-4

Rev.

85A

(C)

Index

FIDBS

DMS

MANUAL

intentionally left blank.

1981

plicro Data Base Systems,

Inc.

HDBS

DMS

GENERAL

MANUAL

INDEX

MDBS

DMS

MANUAL

8,70.2,77,93-95

active lock
application development

..........................................
l-2
72-73
..........................................
area file
assignment
commands
................................................. 39-52,70.2
.......................................
sets ..
)"4-58
9-10,101
back-up
.....................................................
.......:
........................................................
81-88
Boolean commands
70.2,73-74
...............................................
buffer flushing
12-13,25,28.3,32.1,32.22,33
...........................................
calc key
70.2
check suppression
.................................
69-70
...............................................
close data base
................................................
clustering
........................................................
classes
7-B
....................................................
description
notation
6-7
form
.....................................
6,8,90.2-92,94,l07-ll8
status.....................................................
string ................................
57-58
commands.....................................................
connect
75-76
counts of records ...............................................
53-56
creation commands ..............................................
.............................................. 3-5,8,39
current member
..............................................
4,8,39
current of run unit
........................................... 3-5,8,39
currency owner
..............................................
3-5,8,29,33,39-52,57,59,63,72,77,93,95
currency indicators
...........
39,4(1.1,41-42
databasekey
90-92,96
.........................................
data block definition
3,8
data block3
.......................................
Data lzanipulation
Language
......................................................
l-9
Gate format conversion
.......................................
70-70.1
Geadlock
prevention
.......................................
63-65
deletion commands
................................................81,85-83
difference operators
..............................................
59-63
disconnect commands ........................................
environment
controls ............................................
70-70.2
33,53
range
.........................................
feasibility
tinG commands
..............................................11-28.3,70.2
fixed retention ...........................................
102,104
flush of log file...................................................
buffers
flush of page buffers
....................................
9,69,73-74
29-32
.....................................
get elata commands
..............................................
host language
l-3
....................................................
................................................................ 81-85
intersection
...............................................................
operators
log file
......................................... lO,lOl-ló2
54-58
..................................................
sets
33-37
modify commands
....................................................
multiuser environment
................................................
93-99
multiuser locking
................... 2,8-9,69,70.1-72,89,91,95-97
.....................................
name

AUTO

0 0 0 0 0 0 0 0 e 0 0 0 0 0 0 0 0 e 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 e 0 0 0 0 0 0 0 0 0 0 0

BLF

corümand
command
command
command
command

TBS
ID14L

2
2

74AKUAL

commands

(C)

1981

Micro

Data

Base Systems,

Inc.

Rev.

85A

GI-l

MDBS

DMS

General

MANUAL

Index

9DBS

DMS

MANUAL

null
null
null

commands
dates
times
obtain commands
open data base
paqe buffer region
page linage

39,41,44,67,77
70.1
.........................................
70.1
...........................................,..D.......
.....,..........................................0...0.
29,32.1-32.22
71-73
........................................
2,74,89,91
.................................................
.....©...........*.............C..0.....
9—l0,69,72,iOl
file .............................*0....0..e
8¢7Ü02v93"97
passive lock ...¢....¢g©B©0¢0.00.09.0.0.00.e0Q*0g.0oQ©900
performance
tuning ..©...QQ......00.....00®0.0O®..90.S...00
70.2r89v9l
71"72
processing modes
.....©s©*o.......0o0..0®0e*.®**..e9*.e...*.....
89,91
program buffers
3,8
program record types

.......6........................................
2,93
.............................................
l0,101-103
.............................................................
...............................................QC®0....
................................................................
recovery
9-ló,lOl-l02
101-106
................................................
recovery commands
commands
29-32.22
............................................
retrieval
4,8
..........................................
run unit
9_l0,69,101~l02
.........................................................
search
..................................................
sequential
l2pl4"l5p23"24
©o....F0.g.....0©v2Qe0Qc00@©.eoe@e*g.
key

QRS
RCV
RDL

RTL

sort
... ll,l7-l8,2Q-23,25,32g7,32.l0,32.l3,32.l5,32®i9,32.2l,70e2
special commands
.&O0OOD09D.@.
....00e.0eDo.e€...eQ®.@0Q0
speed (see performance
tuning) ...ce...

statistics
$SYSSET

...................................e.................

89"92
74-75
81-88

89,91,95
throughput priority level
77_79
tyFe determination
.....................Q©6.©G....G..G©....0....
user-defined indicators
71
.0e.*..0e.....6.........e.. 5,8,40,67-68,81-88
user name ...0.6..0®0.00.¢©00.Q©G0.....
..e,o
.e.0...
71
........0.
...
...
password
user
0

utility

virtual

GT-2

.................0...............G...................
...............................................
..................................................

coínrítands
paging

Rev.

85A

(C)

1981

!4icro

Data

Base Systems,

67-79
2,74

Inc.

DOCUMENTATION
MDBS

COMMENT

FORM

Title:

Document

welcome and appreciate all comments and suggestions that can
Use this form to
help us to improve our manuals and products.

your

express

views

concerning

this

manual.

Please do not use this form to report system problems or
request materials,
etc. System problems should be reported
MDBS
by phone or telex, or in a separate
to
letter addressed
Requests
support division.
attention of the technical
published materials should be addressed to the attention of
marketing division.

to
to

the

for
the

Sender:
(name)

(position)

(company)

(telephone)

(address)

(city, state, zip)
COMMENTS:

Areas OF comment"are
general
presentation, format, organization,
completeness,
a comment
applies to a
etc.
clarity, accuracy,
please
number(s).
the
specific page or pages,
page
cite

Continue

additional

pages,

as needed.

Thank you

for your responqe.

Source Exif Data:

File Type                       : PDF
File Type Extension             : pdf
MIME Type                       : application/pdf
Linearized                      : No
Has XFA                         : No
XMP Toolkit                     : Adobe XMP Core 4.2.1-c041 52.342996, 2008/05/07-21:37:19
Format                          : application/pdf
Creator                         : 
Description                     : 
Title                           : 
Create Date                     : 2016:06:10 15:14:12-05:00
Creator Tool                    : ChronoScan
Modify Date                     : 2016:06:21 10:26:22-07:00
Metadata Date                   : 2016:06:21 10:26:22-07:00
Keywords                        : 
Producer                        : ChronoScan (http://www.chronoscan.org)
Document ID                     : uuid:d9ddcdce-33b9-404b-a252-8aad2510d1cc
Instance ID                     : uuid:01ed4fbd-5869-1e43-aa5c-85ff01ee0bf2
Page Layout                     : SinglePage
Page Mode                       : UseOutlines
Page Count                      : 193
PDF Version                     : 1.4
Author                          : 
Subject                         :

EXIF Metadata provided by EXIF.tools

MDBS_Application_Programming_Ref_Dec1985 MDBS Application Programming Ref Dec1985

MDBS_Application_Programming_Ref_Dec1985 MDBS_Application_Programming_Ref_Dec1985

Navigation menu

Versions of this User Manual:

Views

Navigation