HP Business BASIC/XL Reference Manual - HP 3000 MPE/iX Computer Systems - Edition 1 (32715-90001)

4- 30
and handle the error. The values returned by TurboIMAGE
to this array are detailed in the description of the
status parameter of the equivalent TurboIMAGE library
procedure.
Examples
The following examples show the use of the DBGET statement.
100 DBGET Db$ INTO S$,DATASET=Ds$,STATUS=S(*)
110 DBGET Db$ INTO S$,DATASET=Ds$,MODE=1,STATUS=S(*)
120 DBGET Db$ INTO S$,DATASET=Ds$,MODE=2,STATUS=S(*)
130 DBGET Db$ INTO S$,DATASET=Ds$,MODE=3,ITEMS=I$,STATUS=S(*)
140 DBGET Db$ INTO S$,DATASET=Ds$,MODE=4,ITEMS=I$,KEY=K$,STATUS=S(*)
150 DBGET Db$ INTO S$,DATASET=Ds$,MODE=7,STATUS=S(*),ITEMS=I$,KEY=N
160 DBGET Db$ INTO S$,DATASET Ds$,MODE 8,KEY N,STATUS S(*)
170 DBGET Db$ INTO S$,DATASET Ds$,STATUS S(*)
180 DBGET Db$ INTO S$,DATASET Ds$,STATUS S(*),ITEMS I$
190 DBGET Db$ INTO S$,DATASET Ds$,ITEMS I$,STATUS S(*)
200 DBGET Db$ INTO S$,DATASET Ds$,ITEMS I$,KEY N,STATUS S(*)
210 DBGET Db$ INTO S$,DATASET Ds$,KEY K$,STATUS S(*)
220 DBGET Db$ USING 400; DATASET Ds$
230 DBGET Db$ USING Pack1; DATASET Ds$,STATUS=S(*)
240 DBGET Db$ USING Pack1 INTO S$,DATASET=Ds$
400 IN DATASET Ds$ USE A,B, SKIP 10,D$
410 Pack1: PACKFMT A,B, SKIP 10,D$
The following statements:
100 DBUPDATE Dbase$ USING 200 INTO D$; DATASET = "parts"
200 PACKFMT A,Price,Company$
are equivalent to:
100 DBGET Dbase$ INTO D$;DATASET="parts"
110 UNPACK USING 200;D$
200 PACKFMT A,Price,Company$
DBINFO
The DBINFO statement provides information about the database specified.
The information returned is restricted by the user class number when the
database is opened. Any data items, data sets, or paths of the database
that are inaccessible to that user are considered to be nonexistent.
Syntax
{DATASET [=] dataset }
DBINFO dbname $, {ITEMS [=] item }
, MODE [=] mode , RETURN [=] str_var [, STATUS [=] status_array (*)]
Parameters
dbname $ A string variable whose value is a TurboIMAGE database
name. dbname must be the variable that was passed to a
successful DBOPEN.
dataset A string expression with a maximum length of 16
characters. Its value is the name of a data set. The
name must be left-justified and if shorter than 16
characters must be terminated by a semicolon or blank.
This parameter can also be an integer or short integer
corresponding to the desired dataset number.
item A string or numeric expression that evaluates to the
name of a data item or evaluates to a numeric value
referencing a data item, respectively. Whether the
DATASET or ITEMS option is selected is dependent on the
mode selected as described in the DBINFO library
procedure in the TurboIMAGE/XL Database Management
System .