IBM Frozen Dessert Maker VERSION 9 Manual De Usuario
v
Work
with
query
results.
v
View
a
graphical
representation
of
the
access
plan
for
explained
SQL
statements.
v
Run
commands
in
sequence.
v
Create
and
save
a
script.
You
can
optionally
store
a
saved
script
in
the
Task
Center,
where
you
can
schedule
the
script
to
run
at
a
specific
time.
On
the
Commands
page,
you
can
execute
an
SQL
statement
or
DB2
CLP
command.
You
do
not
need
to
precede
the
command
by
"DB2".
Run
and
create
a
visual
access
plan,
by
clicking
the
Execute
and
Access
plan
icon
(from
the
left
of
the
toolbar)
Run
a
command
or
statement,
by
clicking
the
Execute
icon
(at
the
left
of
the
toolbar).
On
the
Query
Results
page,
you
can
see
the
results
of
the
queries.
You
can
also
save
the
results
or
edit
the
contents
of
the
table.
On
the
Access
Plan
page,
you
can
see
the
access
plan
for
any
explainable
statement
that
you
specified
on
the
Interactive
page
or
the
Script
page
when
you
click
on
the
Access
plan
or
Execute
and
Access
plan
icon.
DB2
generates
the
access
plan
when
it
compiles
the
SQL
statement.
You
can
use
this
information
to
tune
your
queries
for
better
performance.
If
you
specify
more
than
one
statement
on
the
Script
page,
an
access
plan
is
not
created
unless
you
highlight
a
single
statement.
You
can
get
help
writing
SQL
with
the
SQL
Assist
tool
available
from
the
Selected
menu
of
the
Command
Editor
menu.
Figure
6.
Command
Editor
window
Chapter
7.
DB2
administration
and
development
tools
47