Assessments - , GPA:
(
)
)
Fabricante : HP
Arquivo Tamanho: 1.57 mb
Arquivo Nome :
Língua de Ensino: 
O documento está colocado, por favor, espere
 |
O documento está colocado, por favor, espere
por este dispositivo também tem outras instruções :
Facilidade de uso
CLOSE
CL
OSE
The
CLOSE
statement
is
used
to
close
an
op en
cursor.
Scope
Application
Programs
or
Pro
cedures
SQL
Syntax
8
9
2
3
2
3
SQLDA
<
=
SQL
DESCRIPTOR
4
5
A
r
e
aName
CLOSE
CursorName
USING
2
2
3
32
3
:
;
INDICATOR
,
.
.
.
: HostV
ariable
: Indic
ator
P
arameters
CursorName
designates
the
op en
cursor
to
b e
closed.
USING
denes
where
to
place
return
status
and
output
parameters
after
closing
a
dynamic
pro cedure
cursor.
HostV
ariable
iden
ties
a
host
v
ariable
for
holding
return
status
and
output
parameters
after
closing
a
dynamic
pro cedure
cursor.
These
m
ust
b e
sp ecied
in
the
same
order
as
in
the
asso
ciated
EXECUTE
PR
OCEDURE
statement.
Indic
ator
names
the
indicator
v
ariable,
an
output
host
v
ariable
whose
v
alue
dep ends
on
whether
the
host
v
ariable
con
tains
a
n
ull
v
alue.
The
following
in
teger
v
alues
are
v
alid:
0
meaning
the
output
parameter's
v
alue
is
not
n
ull
01
meaning
the
output
parameter's
v
alue
is
n
ull
>0
meaning
the
output
parameter's
v
alue
is
truncated
(for
CHAR,
V
AR
CHAR,
BINAR
Y,
and
V
ARBINAR
Y
columns)
DESCRIPTOR
denes
where
to
place
return
status
and
output
parameters
after
closing
a
pro cedure
cursor.
Sp ecify
the
same
lo
cation
(SQLD
A,
area
name,
or
host
v
ariable)
as
y
ou
sp ecied
in
the
DESCRIBE
OUTPUT
statement.
SQLDA
sp ecies
that
a
data
structure
of
sqlda
t
yp e
named
SQLD
A
is
to
b e
used
to
pass
information
ab out
the
prepared
statement
b et
w
een
the
application
and
ALLBASE/SQL.
A
r
e
aName
sp ecies
the
user
dened
name
of
a
data
structure
of
sqlda
t
yp e
that
is
to
b e
used
to
pass
information
ab out
the
prepared
statement.
SQL
Statements
10-37
... Este manual também é adequado para os modelos :
Software - MPE/iX 6.5 Operating System (1.57 mb)