MDBS
-
MICROSOFT Compiled BASIC/FORTRANIntertaee
NotesSYS.MCBF MDBS
-
CP/MInterface
NotesCF'/M
with
MICROSOFT Compiled E3ASIC/FORTRAN=
znm dddddddd bbbbbbbb ssssssmmm mmm ddddddddd bbbbbbbbb ssssssss
mmmm mmmm dd dd bb bb ss ss
mm mmmm mm dd cid bb bb ss
mm mm mm dd dd bbbbbbbbb sssssssss
mm mm dd dd bbbbbbbbb sssssssss
mm mm dd dd bb bb ss
mm mm dd dd bb bb ss ss
mm mm ddddddddd bbbbbbbbb ssssssss
mm mm ddddddcid bbbbbbbb ssssss
Micro Data Base Systems,
Inc.
P. O. Box 248
Lafayette,
Indiana
47902 (317) 448-1616(317) 742-7388
August 1980
Copyright Notice
This
entire
manualis provided for
the use of" the eustomer andthe
eustomer"s employees. The
entire
contents
have been ce>pyrighted byMicro
Data Base Systems,Inc.,
andreproduction
'by any meansis
prohibited
except aspermitted
in
awritten
agreementwith
Micro Data Base Systems,Inc.
CP/M
is
aregistered
trademarkof
theDigital
ResearchCorporation.
© COPYRIGHT 1980, Micro Data Base Systems,
MDBS — MICROSOFT Compiled BASIC/FORTRAN
Interf"ace
NotesI.
INTRODUCTIONThe MDBS.DDL and MDBS.DMS User"s Manual was
written
in
a non—machine—dependent manner. The purpose
of
the manualis to diseuss the
specif"ics
of
running
the MDBS packages on CP/M systemswith
MICROSOFT's compiled 13ASIC-80 and FORTRAN-80 or
related
produets.
The
following
files
are on the two MDBSdiskettesC
(a)
MDBS.DDL1. DDL.COM
-
Anabsolute
version
or MDBS.DDLloading at
100 hex 2. INVNTRY
-
A sampledata description
fjile
3. RLC.COM — An
absolute relocator
4. RELOC.IHF — A
relocatable
reloeator
loading at
lOó hex.5. DDL.IHF — A
relocatable
version
of"the
MDBS.DDL system(b)
MDBS.DMS1. DMS.REL
-
Arelocatable
version of
the MDBS.DMS system2. SAMF'LE.BAS
-
Sample BASIC Program3. SAMPLE.FOR
-
Sample FORTRAN Program4. SAMPLDDL
-
DDLf"iie for
usewith
sample programsMDBS.DDL
is
yourpersonalized
DataDef"inition
LanguageAnalyzer/
Editor
and MDBS.DMS your Data Management System. DDL loadsat
1OOHand extends
to approximately
340OH.It
usesstandard
CP/MI/O entry
points.
If
you areusing
nonstandardI/O
entries
or
require
other
lDepending on
the size
OF thediskettes
used,the
files
onthe
twodiskettes
mayactually
beorganized difTerently.
© COPYRIGHT 1980,
MDBS
-
MICROSOFT Compiled BASIC/FORTRANInteMaee
Notespatching,
refer
to Section
IVror patching
proeeduremMDBS.DMS
is
supplied
in
arelocatable
format
eompatib!ewith the
object
files
produced bythe
MICROSOFT BASIC-80 and FORTRAN-80eompilers.
The program areafor the
MDBSoDMS systemis approximately
44QQí(hex)
bytes
long.Additionally,
memoryis required for the
variotis tables
andbuff"ers required
by the system. This memory spaeeis allocated
bythe
calling
program sothat
the user mayeasily
changethe
amountof
memoryavailable
to
the MDBS.DMS system. Sinceinereased
memoryavailable
to
MDBSoDMSwill
result
in greater
systemthroughput,
maximization of available
memoryis
encouraged.In Section
VI we show howto call
the OMSroutines
rrom MICROSOFTBASIC-80 and FORTRAN-80.
Finally,
in Section VII
weprovide
somegeneral"notes
for
the CF'/Muser or
the MDBS package.You can run your
version
or DDL byfkAlowing
the procedure givenin
Figure
1. At the end of" Step 2 you arein
the DDL program. Referto
Section
II.E
of' the MDBSuser"s
manualfor
the DDL commands. However,to
quickly
see someaction,
continue with
the procedurein Figure
1.Steps 3—5
result
in
thereading of
a sample data basedeseription
fTom the
rile
INVNTRY. Step E3results
in
thelisting
M the
sampledescription.
Step 8returns
control
to
theoperating
system.i The
size
or the MDBS.DMS systemwill
vary
depending on thefunctions
available
andthe operating system/host
languageselected.
© COPYRIGHT 1980, Micro Data Base Systems,
Mij13S
-
MICROSOFT Compiled BASIC/FORTRANInterface
NotesFigure
i
Sample DDL
execution
STE? F'ROCEDURE/RESULTS
t.
you DDL2. Computer MDBS.DDL VER X.X
(C) COPYRIGHT 1980,
Micro
Data Base Systems,Incorporated
Reg # XXXXX4
your name and address
36 you R
4g Computer FILENAME
5q you INVNTRY
6. you L
7. Computer
listing
or
sample datadescription
8. you BYE
9. Computer A>
(return
to Monitor)
E) COPYRIGHT 1380,
MDBS
-
MICROSOFT Compiled 13ASIC/FORTRANInterface
NotesII.
RELOCATING MDBS.DDLTo
relocate
and produce anexecutable
formor
MDBS.DDL and MDBS.DMS, we haveprovided
anexeeutabie relocator
and arelocatable
f"orm or the
reloeator.
RLCcCOM loadsat
OÍOOH. To useit
merelyenter
the sequence of"lines
shownin Figure
2at
yourtermina!.
Mter
peMorming
this
sequenceof
steps you may wantto
save theU!e.
If
areloeator
is
neededat
an addressother
than O1OOHrefer
to
Section
III.
.
© COPYRIGHT 1980,
MDBS
-
MICROSOFT Compiled BASIC/FORTRANInterf"aee
NotesFigure
2Producing
anExecutable
Form of" MBDS.DDLStep Proeedure Example
1. you RLC RLC
2. Computer INPUT
3. you DDL.IHF DDL.IHF
4. Computer LOAD ADDRESS
5. you yyyy (,ZZZZ) 2DOO
6. Computer
tttt
(return
to Monitor)
>Explanation:
This
sequence of"steps
produces anexecutable
fbrmof
MDBS.DDL .i.n,memory
starting
at
memorylocation
yyyyH + Z.ZZZH and ORGedat
yyyyH.The
",zzzz"
is optional.
Thehigh
memory address used by theroutine
is indicated
bythe
"tttt"
response from RLC. The usershould
insure
that
the relocator
andthe
programlocations
arenot in
conflict
with
oneanother.
Following
this
procedure, the user
may wantto
make patchesto
theexecutable
program (asoutlined
in Section
II.C.3
ot
the MDBSuser"s
B
manual and
in Sections
IV and V of"this
manual) and then save theresulting
executable
program.© COPYRIGHT
blDElS
-
MICROSOFT Compiled BASIC/FORTRANInteMace
NotesIII.
GENERATING A NEW RELOCATORTo produce a
reloeator
at
an addressother
than O1OOH f"o!low Mhesequence of"
steps
shownin Figure
3.Figure
3Produeing an
Executable Relocator
"SteE Procedure Example
i.
you RLC RLC2. Computer INPUT
3. you RELOC.IHF RELOC.IHF
4. Computer LOAD ADDRESS
5. you yyyy (,ZZZZ) 6000
6. Computer
tttt
(Return to Monitor)
>Explanation:
This
sequence of"steps
produces anexecutable
formof
RELOC.IHFin
memorystarting
at
memorylocation
yyyyH + ZZZZH and ORGedat
yyyyH(the
"ZzzzH"is optional).
Executing
RLC.COMresults
in
its
loading
and subsequent
execution at
O1OOFi and the user must becareful
not to
have a memory
conflict
between RLC.COM and the newly formed RLC whichwill
beplaced at
yyyyH + zzzzH.The user may then want
to
savethis
program.© COPYRIGHT 1980, Micro Data
MDBS
-
MICROSOFT Compiled BASIC/FORTRANInteMaee
NotesIVo MDBS.DDL PATCHING
MDBS.DDL
consists
M
a programregion
and work arearegion.
Theseare
eontiguous
andthe
work areaimmediately
hllows
the
program area. Thesize
of"the
work area can beincreased
or decreasedthrough
apatch to the
system.There are
several
addressesthat
the usershould
be aware of"in
MDBS.DDL.Figure
4 maps out theseareas.
Abrief
description
or eachitem fbllows.
All
address patches should be madewith
normal 8080eonventions,
i.m
the lower 8bits
of the
address precede thehigher
8bits.
(a)
Initial
Entry Point
Upon enbry
at
this
point,
all
programvariables
andregions
areeither
physically
orlogically
re—initialized.
Registers
arenot
savedbut
theentering
stack is preserved.
(b)
BDOS Jump(DeMult
0005 hex)This
is
the address OÍ" thedisk
management andperipheral
processing routines.
(C) CP/M Warm
Entry
Jump(Default
0000 hex)This
addressis
the warmentry point
to
CP/M.(d)
FCBLocation
(Default
005C hex)This points to
theFile
Control
Blockarea.
© COPYRIGHT
MDBS
-
MICROSOFT Compiled BASIC/FORTRANInteMaee
Notes(e)
BUFFLocation
(Derault
0080 hex)This points
to
a- 128byte butter
area.(f") Reserved Regions
This
areais reserved for internal
use by the MDBScDDLroutines.
It
should not
bealtered.
(g) Eeho Toggle
(DeMult
01 hex)This byte is
cheekedto
see if"the
user wantsto
have MDBS.DDLecho
input
to
theoutput
device.
ir
thebyte value is zero,
.
echoing
will
take place.
If"it
is
thevalue
one, no echoingwill
be perf7ormed.(h)
Size of" BASICInteger
(DeMult
02 hex)The
value
in
this
f"ield
gives the
number orbytes required
tQstore
a numeric elementin Microsof"t
BASIC.This
value should be2.
(i)
Size M
BASICSingle Precision
Variable
(Default
04 hex)This
f"ield
mustcontain
thesize
of
aMicrosoft
BASICsingle
.
precision
variable.
This value is
4.(i)
Last
Word of" Memory(Default
OBFFF hex)The address
stored
heregives
thelast available
wordof
memorythat
the
MDBS.DDL program may use. Notethat
MDBS.DDL usesall
memory
starting
f"romits
load address upto
thevalue
in
this
MDBS — MICROSOFT Compiled BASIC/FORTRAN
InteMace
Notesf"ieid.
Needlessto
say, the user should make surethat the last
word or memory
is physieally
beyond the end orthe
program.(k)
ScreenControl
Byte(Default
OB hex)This byte should
have one c}r thefollowing
values:
Screen Width Byte Value
less
thanor
equalto
64 11 (OB hex)characters
greater
than or equalto
80 15 (OF hex)characters
64
to
80characters
pergreatest
integer
less
line
(call
it
N) than or equalto:
N/5 -1
(I)
Re-entry Point
The
user
may re—enter MDBS.DDLwhile
preserving
all
programvariables
andregions
byissuing
a jumpto
this
address.© COPYRIGHT 1980,
Micro
Data Base Systems,?4DBS
-
MICROSOFT Compiled BASIC/FORTRANInterfbee
NotesFigure
4MDBS.DDL ADDRESSES
Address
Deseription
DefbnUt Value0100
(hex)
Initial
Entry Point
——0103
(hex)
BDOS Jump 0005 (hex)0106 (hex) CP/M Warm
Entry
0000 (hex)0108 (hex) FCB
Location
005C (hex)O1OA (hex) BUFF
Location
0080 (hex)O1OC-O126 Reserved
0127 (hex) Echo Toggle 01 (hex)
0128 (hex) BASIC
Integer
Size 02 (hex)0129 (hex) BASIC
Single Precision
Size 04 (hex) 012A (hex)Last
Word of" Memory BFFF (hex)012C (hex) Screen
Control
Byte 11 (hex)0139 (hex)
Re-Entry Point
——0
© COPYRIGHT 1980, Micro Data Base Systems,
Inc.
MDBS
-
MICROSOFT Compiled BASIC/FORTRANInterfaee
NotesV. INTERFACING MICROSOFT BASIC-80 AND FOF?TRAN-80
A. MDBS.DMS
Entry Points
The MDBSeDMS system has 4
host
languagecallable
entry points.
Theentry points are:
DMS — The
primary
entry point
for requesting
DMSprocessing.
All
DMS eommandsdescribed in
the MDE3SUser's
Manual(exeept
DEFINE and EXTEND) are performed bycalling this
entry point.
DMSDEF
-
Theentry
poinbfor the
DEFINE and EXTEND commands.SETF'BF
-
Anentry point
which must becalled
prior
to
thefirst
cal!
to
OMS or DMSDEFto allocate
memoryfor
use by the MDBS.DMS system.ALTEOS —
This entry is
used by FORTRAN programsto permit
the useor
three
branch(arithmetic)
IF's
for error
checking (Seebelow).
The same
version
or the DM3S.DMS system can be usedwith
both BASIC and FORTRAN. A parameterspecified
on thecall
to
SETPBFindicates
in
which language the
calling
program has beenwritten
(Oindicates
BASIC, 1 FORTRAN).
B. BASIC-80
Interface
To
call
the
MDBS.DMS system rrom BASIC-80 theTollowing
proeeduresinust be used.
First
the user mustdefine
theworking
memoryavailable
for
use by MDBS.DMS.This is
done by the SETFBFentry described in
Part
Dbelow. The
eal!ing
sequence usedis:
© COPYRIGHT 1980,
MDBS
-
MICROSOFT Compiled BASIC/FORTRANInterface
Notes10 DIM 139%(2048)
15 N% = 4096
20 1%
= O
25 CALL SETF'BF (B9%, N%, 1%)
Note
that
each elementof
theinteger array
B9% occupies twobytes;
thus,
the
call
to
SETPBFindicates
that
><2048, or 4096,bytes
areavailable
f"or use.To
define
a datablock,
acall
of' the f1>llowing f"ormis
used:30 N%
= 4
40 C$ = "DEFINE,OPENBLK"
50 CALL DMSDEF (E0%, C$, N%, 01$, 02$, 03$, 04$)
This
dMines
a datablock
named "OPENBLK"with
four
string
variables
(01$, 02$, 03$,04$).
EO%is
aninteger
variable
whichreturns
the error status (equivalent
to
EDin
the MDBSUser's
Manual)and N%
is
a count OÍ"the
number orvariables
passed.Finally,
aoat!
is
madeto
astandard
DMSroutine
(OPENin
this
ease) by a
call
M the hrm:
60 01$ = "SAMF'LEDB.DB"
70 02$ = "USER"
80 03$ = "PASSWORD"
90 04$ = "MOD" ·
lOó C$ = "OPEN,OPENBLK"
110 CALL DMS (E0%, C$)
d
MDBS
-
MICROSOFT Compiled BASIC/FORTRANInteMace
Notes01$
through
04$ arestring
variables
which comprisethe
parameters f"orthe
OPENcal!.
Theactual
function
to
be perfbrmedis stored in
string
variable
C$ andis
passedin
theeall
to
OMS alongwith
the
error
responsevariable,
EO%.C. FORTRAN-80
InteMace
To
call
the
MDBS.DMS system fTom FORTRAN-80the
following
procedures
must be used.First
the user mustdMine
theworking
memoryavailable
for
use by MDBS.DMS.This is
done bythe
SETPBFentry described in Part
D below. Thecalling
sequence usedis:
LOGICAL DMSBUF (4096)CALL SETPBF (DMSBUF, 4096,
I)
To
dMine
a datablock,
acall
OTthe fbllowing
fbrmis
used:K
REAL
01(3),
02(4),
03(3),
04DATA 01
/
4HSAMP,4HLED13,4H.DB/,
02/
4HUSER,3MH/,
*
02/
4HPASS,4HWORD,4H/,
04/
4HMOD/
CALL DMSDEF (IER, 'DEFINE,OPENBLK.', 4, 01, 02, 03, 04)
This
def"ines a datablock
named "OPENBLK"with
fk>urcharacter
variables
(01, 02, 03,04).
IERis
aninteger
variable
whichreturns
the error status (equivalent
to
EOin
the MDBSUser's
Manual) and the 4is
a count of"the
numbera: variables
passed.Finally,
acall
is
madeto
astandard
DMSroutine
(OPENin
this
ease) by a
eall
of
the rorm:© COPYRIGHT 1980,
MDBS
-
MICROSOFT Compiled BASIC/FORTRANInterface
NotesCALL DMS (IER, 'OPEN,OPENBLK.')
Note
that the
commandstring
('OF'EN,OPENBLK.',etc.)
must always beterminated
by aperiod in
FORTRANcalls.
This is
dueto the tact
that
FORTRAN,unlike
BASIC, does zjQt have afacility
to
passthe
length
M
aliteral
string.
Theperiod
provides
the
means f"orMDBS6DMS
to determine the length of the
string.
D. Use of" SETF'BFAs mentioned
earlier,
the
SETPBFentry point
passesto
the MDBS.DMSsystem a
eontiguous section of
memory.This
memory segmentis
usedto
store tables
andbufTers fbr
use bythe
MDBS.DMS system and MUST NOT BE ALTERED by theuser's
program. Since the MDBS.DMS system uses a- dynamic
buf"fer'ing
scheme,it
is
important
that
as much memory aspossible
beallocated
for
use bythe
MDBS system (we recommendthat at
least
4000bytes
beallocated).
Since the amountof
memoryavailable
to
the MDBS.DMS system canradically
afYeet
thethroughput ot the
system (more memoryimplies
moredisk buf"fers
whichimplies
fewerdisk
accesses),
it
is usually
well
worth yourwhile to
do acompilation
and a LINKto determine the
amount of" memory used by theobject
program.The
host
languagearray
can then be dimensionedto allocate
most of' thefree
memoryror
by MDBS.DMS. Note, however,that
FORTRAN—80allocates
rix
buÍí"ers dynamically
andsufTieient
memory must beleft
for this
purpose.The
third
parameterin
the SETF'BFcall
is
aflag indicating
whetherthe
calling
programis
written
in
FORTRANor
BASIC. Avalue
or Oindicates
BASIC; 1indieates
FORTRAN.© COPYRIGHT 1980,
MDBS — MICROSOFT Compiled 3ASIC/FORTRAN
Interface
NotesE. Use
of
ALTEOSThe
error
response (IERin
our FORTRAN examples, EDin
the
MDBSUser's
Manual) canin
may cases bethought of
asbeing
logically
divisible
into the rollowing
three
groups: 1. No problems (IER = O)2. End or Set Encountered,
or.key
Not Found (IER = 255)3.
Error
Encountered(anything else)
Usually
anerror
of
thethird
type indicates
a programming problem. Anerror
of the
secondtype
can be expected from a numberof
commands(FMSK, SOM
or
FNM) and donot indicate
a programmingerror,
but rather
the end
of
aset processing
loop. Sincein
FORÍRAN thethree
brancharithmetic
IFexists,
it
is convenient to
alter
the 255 response from the DMStor
usewith
such an IFstatement.
Theentry
ALTEOS has beendefined for
this
purpose.After
ALTEOS has beencalled,
the normal 255error
responseis returned
as —1.This
makes thetask
or examingthe
error
responsesimpler tor
the FORTRAN programmer. PleasereMr
to
the
sample program (SAMPLE.FOR) whichis included with
the MDBSsystem
disks ror
an example orthis
reature.
Subsequentcalls
to
ALTEQS
toggle
this
feature.
d
MDBS
-
MICROSOFT Compiled BASIC/FORTRANInterface
NotesVI.
LINKING THE HOST LANGUAGE PROGRAM AND MDBS.DMSThe MDBS.DMS system (on the DMS.REL
file)
may belinked with
yourcompiled source program by
using
the LINK—80linker.
All
that
is
neeessary
is
to
load the DMS and your program as shownin Figure
li3. Steps 1through
5 show howto
load the programs. Step 7 demonstratesthe method used
to
save thelinked
program as a comrile.
Figure
5Linking
the MDBS.DMS systemStep Procedure Example
1. you invoke
linker
L802. Computer
*
*
3. you load DMS DMS
4. Computer
*
*
5. you load program BIN
í3. Computer
*
*
7. you save COM
file
BIN/N8. Computer
*
*
9. you
exit
linker
Ie
© COPYRIGHT 1980, Micro Data Base Systems,
MDBS
-
MICROSOFT Compiled 3ASIC/FORTRANInterface
NotesVII.
GENERAL NOTES1.
Replicated
items (seeSection
II.D.5
or the User"s Manual) aregiven
andreturned
to
IdDBS.DMS from thehost
languageusing
arrays.
2.
Binary
andInteger
Item Types aresupplied
from (andto)
FORTRANthrough
INTEGERvariables.
CHARacter itemsin
MOBS arerepresented
in
FORTRAN byappropriate
useof
LOGICAL, INTEGER or REALarrays.
The MDBS system views thecharacter
data as asequence
of
bytes,
so therepresentation
selected in
the FORTRAN programis irrelevant
so long as asufficient
numberof bytes
havebeen
allocated.
LOGical Item Types correspondexactly
to
LOGICALvariables
in
FORTRAN. REAL Item Types aresupplied through Single
Precision
and DoublePrecision
variables.
In the DDLAnalyzer,
ablank item size for
a REALvariable
results
in
asingle
precision
default.
DoublePrecision
variables
result
when theappropriate
item size (8) is specified.
3.
Binary
andInteger
Item Types aresupplied
from (andto)
BASICthrough
INTEGERvariables.
CHARacter itemsin
MDBS correspondto
string
variables
in
BASIC. LOGiealvariables
may be accessed f"rom BASIC,but
their
useis undefined.
REAL Item Types aresupplied
through Single Precision
and DoublePrecision
variables.
In theDDL
Analyzer,
ablank
itemsize fbr
a REALvariable
results
in
asingle
precision
default.
Double?recision
variables
result
when theappropriate
itemsize (8) is specified.
© COPYRIGHT 1980,
MDBS
-
MICROSOFT Compiled BASIC/FORTRANInterface
Notes4.
In
BASIC, whenretrieving
character strings
K"om a data base,the
user
should
make surethat
thedestination
string
variable
has beenpreviously
initialized
to
alength suMieiently
large to hold
the incoming
string.
If
this
is
not done, the incomingstring
will
betruncated.
Further,
thestring
shouldnot
beinitialized
bysetting
it
equalto
a programliteral.
This
can cause theliteral
in
the programto
be modif"iedwith undesirable
results.
It
is
recommendedthat
thestring
variable
beinitialized
with the
SPACE$
function.
Alternatively,
the FIELD command may be usedto
insure that
adequate space has beenallocated
for
astring.
5. Note
that
twobyte integer
variables
run Trom -32767to
32767 andnot
from -32768to
32767.6. In the DDL Analyzer', a new data base ean be
initialized
on anydrive.
However, theinitialized
disk
will
haveto reside
ondrive
Aduring
data baseoperations.
7.
In
the
DDLAnalyzer,
when nodrive is specif"ied ror
arile,
thelast rerereneed drive is
thedefault.
8. DEFINE and EXTEND
calls
arelimited
to
4variables
percall.
Successive
calls
to
EXTEND should be usedto set
up long datablocks.
E
© CO?YRIGHT
MDBS — MICROSOFT Compiled BASIC/FORTRAN
Interf"aee
NotesAppendix: Using MDBS
to
implement anapplication
system.Figure
Aprovides
anoverview
or thefour
phasesinvolved.
Theexecutable
Xmmof
MDEIS.DDLis
usedto
define
adata
base.Application
programsthat
accessthe
data base musb be eompiled andlinked
to
arelocatable
form of" MDE1S.DN!S(supplied
on the DMS.RELfile).
© COPYRIGHT 198C),
MD13S
-
MICROSOFT Compiled BASIC/FORTRANInterface
NotesPhase A
Create a
U!e
that
will
hold
the data base.Phase B J
Exeeute the
executable
formof
MDBS.DDL
in
order to enter
DDLtext
that Formally specifies
the database's
llogical
structurm
t
invoke the
DDLanalyzer
bytyping:
DDLL
Did
the
DDLanalyzer
f"ind anerror?
yes no
J
Edit
the DDLtext
to
remove theerror.
l
l
t
Write
(W)the
DDLtext
onto afile
to
saveit.
Phase C L
Write
ahost
languageapplication
program
with
DMLcalls.
Phase Dt
Link
therelocatable
formof
MDBS.DMSto the
compiledapplication
program and executeit.
P
Debug
application
programir
needed.Figure
A. Using MDBSto
Implement anApplication
SystemMDBS
-
MICROSOFT Compiled 3ASIC/FORTRANInteMaee
NotesPhases A-D:
Details
Phase A:
Create a
ri1e that
will
hold
the data base.This
file
must havethe
same name asgiven
on the FILEline
in
the DDLdeseription.
This
iRile must be
created
ondrive
1 (andon any
other
drives
specified
with
the DRIVEeard(s)
in
the DDL).Phase B:
Execute
the executable
formof
MD13S.DDLthat
wassupplied (or
whichyou have
created in Figure 2).
Now you arewithin
the MDBS DDL system, so you can:(a)
Read aTile
éjC DDL sourcetext
(e.g.,the
files
INVNTRY and SAMPLDDLsupplied
on thediskettes
youreceived).
(b)
Generate afile
or
DDL sourcetext
for
your own data baseapplication
(text
entry aids
areprovided).
(c) Edit
af"ile
of" DDL sourcetext.
(d) Write
(i.e.,
save ondisk)
afile
Cit DDL sourcetext.
(e)
Submit aTile
of
DDL sourcetext
to
the DDLanalyzer
whichchecks your DDL
text
for correctness.
Diagnostics
are
issued
for
errors;
otherwise
the message DDL PROCESSING COMPLETEis
returned,
indicating
that
the data basedescribed
in
the DDLsource
text
is
now def"inedfor
thefile
created in
Phase A.This data
basefile
nowcontains
a data basedirectory
composed orall
schemainformation.
© COPYRIGHT 1980, Micro Data Base Systems,
MDBS
-
MICROSOFT Compiled BASIC/FORTRANInterface
NotesCommands
to
aecomplish thefbregoing kinds
oractivities
(along
with descriptions
of error
messagesreturned
K"orn the DDLanalyzer)
are described in
the MDBSUser's
Manual.Phase C:
Write
host
languageapplication
programs(containing
MOBS DMLcalls)
for
adata
basedefined in
PhaseB(e).
These programs are usedto
adddata
t'o the data base,extract
data fTom the data base, change data andtheir
relationships
within
the data base,and/or delete
data from thedata
base. (The SAMPLEf4le
on thediskettes
youreceived is
an example
application
programfor
a data base whose source DDLtext
exists
onthe
SAMF'LDDLfile.)
The methodfor
calling
DML eommandsfrom a
host
language depends upon thenature
or thehost
language. The necessarycalling
protocol
fbr
yourhost
languageis
illustrated
in the
MDBS systemspecif"ic
manual.The
nature
of" each MDBS DML commandthat
can beealled
f"rom yourhost
languageis described in
the MDBSUser's
Manual.Errors that
canresult
from theincorrect
DML usage aredescribed
for
each command.It
is
suggestedthat
you f7o!lowthrough
the codeof
SAMPLEin order to
become
oriented
to
DMLapplieatins
programmingwith
yourhost
language.
Phase D:
Link the compiled application
programwith
therelocatable
MDBS.DMSprovided in the
DMS.RELfile
(seeFigure 5).
Execute theresult.
© COPYRIGHT 1980, Miero