
D
A
T
A-SETS=
MODE
=
1
MODE
=
>> 4
RETURN
5
DATA-SETS
=
INVENTORY,SALES
DATA-SETS
=
>> 4
RETURN
5
PROC-FILE
=
>> 4
RETURN
5
OUTPUT
=
TERM
OUTPUT
=
>> 4
RETURN
5
Example
2
This
example
illustrates
ho
w
QUER
Y
uses
the
data
set
list,
clears
it,
and
en
ters
data
set
names
automatically
.
The
DEFINE
command
sho
ws
that
the
data
set
list
curren
tly
con
tains
the
SALES
data
set.
When
using
the
FIND
command
to
searc
h
en
tries
with
STOCK#=6650D22S,
the
SALES
data
set
is
automatically
used
since
it
is
in
the
data
set
list.
The
D
A
T
A
SET=
command,
follow
ed
b
y
no
data
set
names,
clears
the
data
set
list.
When
FIND
STOCK=6650D22S
is
used
again,
QUER
Y
prompts
for
the
data
set
to
b e
used.
The
DEFINE
command
sho
ws
that
the
data
set
INVENTOR
Y
w
as
automatically
added
to
the
data
set
list.
When
FIND
STOCK#=7391Z22F
is
en
tered,
the
INVENTOR
Y
data
set
is
used.
Ho
w
ev
er,
in
the
next
FIND
command,
the
data
set
SALES
is
sp ecied.
In
this
case,
the
data
set
list
is
not
used.
> DEFINE
DATA-BASE
=
ORDERS.PUB.SYS
DATA
BASE
=
>> 4
RETURN
5
PASSWORD
=
**********
PASSWORD
=
>> 4
RETURN
5
MODE
=
1
MODE
=
>> 4
RETURN
5
DATA-SETS
=
SALES
DATA-SETS
=
>> 4
RETURN
5
PROC-FILE
=
MANPROC.IMAGE.DATAMGT
PROC-FILE
=
>> 4
RETURN
5
OUTPUT
=
TERM
OUTPUT
=
>> 4
RETURN
5
> FIND
STOCK#=6650D22S
2
ENTRIES
QUALIFIED
> DATA-SETS=
> FIND
STOCK#=6650D22S
STOCK#
IS
A
MEMBER
OF
THESE
SETS:
PRODUCT,SALES,INVENTORY
WHICH
SET
DO
YOU
WISH
TO
USE?
>> INVENTORY
5
ENTRIES
QUALIFIED
> DEFINE
DATA-BASE
=
ORDERS.PUB.SYS
DATA-BASE
=
>> 4
RETURN
5
PASSWORD
=
**********
PASSWORD
=
>> 4
RETURN
5
MODE
=
1
MODE
=
>> 4
RETURN
5
DATA-SETS
=
INVENTORY
DATA-SETS
=
>> 4
RETURN
5
PROC-FILE
=
MANPROC.IMAGE.DATAMGT
PROC-FILE
=
>> 4
RETURN
5
OUTPUT
=
TERM
OUTPUT
=
>> 4
RETURN
5
> FIND
STOCK#=7391Z22F
2
ENTRIES
QUALIFIED
> FIND
SALES.STOCK#=
7391Z22F
8
ENTRIES
QUALIFIED
>
3-20
QUERY/V
COMMANDS
Summary of Contents for QUERY
Page 10: ......
Page 17: ...Figure 1 1 ORDERS Data Base Structure Figure 1 2 Sample Entry Values INTRODUCING QUERY V 1 7 ...
Page 20: ...Figure 1 3 IMAGE QUERY Environments 1 10 INTRODUCING QUERY V ...
Page 36: ......
Page 165: ...REPORT G1 GROUP TITLE 11 END QUERY V COMMANDS 3 129 ...
Page 199: ...XEQ TF TOTAL DUE 9 SPACE B2 SKIP A TF R0 70 E2 S PURCH DATE END QUERY V COMMANDS 3 163 ...
Page 200: ......
Page 244: ......
Page 278: ......
Page 279: ...G ASCII CHARACTER SET This appendix is not available in this edition ASCII CHARACTER SET G 1 ...
Page 280: ......