Stimmen - 0, Durchschnittliche Bewertung: 0
(
)
)
|
Dieses Gerät hat auch andere Anweisungen:
Anleitung Zusammenfassung
Comparison
Predicate
Description
Character
strings
are
compared
according
to
the
HP
eigh
t-bit
ASCI I
collating
sequence
for
ASCI I
data,
or
the
collation
rules
for
the
native
language
of
the
DBEn
vironmen
t
for
NLS
data.
Column
data
w
ould
either
b e
ASCI I
data
or
NLS
data
dep ending
on
ho
w
the
column
w
as
declared
up on
its
creation.
Constants
are
ASCI I
data
or
NLS
data
dep ending
on
whether
y
ou
are
using
NLS
or
not.
If
a
case
insensitive
ASCI I
expression
is
compared
to
a
case
insensitive
NLS
expression,
the
t
w
o
expressions
are
compared
using
the
NLS
collation
rules.
The
case
insensitive
NLS
comparison
is
done
b
y
using
the
NLSCANMO
VE
and
NLSCOLLA
TE
in
trinsics.
The
same
ASCI I
c
haracters
in
upp er
and
low
er
case
are
equiv
alen
t.
Accen
t
c
haracters
(extended
c
haracter)
in
upp er
and
low
er
case
are
also
equiv
alen
t.
Ho
w
ev
er,
an
accen
t
c
haracter
may
not
b e
the
same
as
its
ASCI I
equiv
alen
t,
dep ending
on
the
sp ecic
language
collation
table.
Extended
upp er
and
low
er
case
c
haracters
are
not
equiv
alen
t
to
the
ASCI I
expression.
They
are
compared
to
the
NLS
collation
table.
If
a
case
sensitive
c
haracter
column
is
compared
to
a
c
haracter
column
that
is
not
case
sensitive,
b oth
columns
are
treated
as
case
sensitive.
If
a
string
constan
t
is
compared
to
a
column
that
is
not
case
sensitive,
then
the
string
constan
t
is
treated
as
not
case
sensitive.
Refer
to
the
\Data
T
yp es"
c
hapter
for
t
yp e
con
v
ersion
that
ALLBASE/SQL
p erforms
when
y
ou
compare
v
alues
of
dieren
t
t
yp es.
F
or
purp oses
of
the
Comparison
Predicate,
a
NULL
v
alue
on
either
or
b oth
sides
of
the
predicate
causes
it
to
ev
aluate
to
unkno
wn.
Th
us,
t
w
o
NULL
v
alues
on
either
side
of
an
equals
predicate
will
not
result
in
a
TR
UE
result
but
rather
in
unkno
wn.
A
NULL
v
alue
in
an
expression
causes
comparison
op erators
to
ev
aluate
to
unkno
wn.
Refer
to
the
\Searc
h
Condition"
section
at
the
b eginning
of
this
c
hapter
for
more
information
on
ev
aluation
of
op erators.
A
sub query
m
ust
return
a
single
v
alue
(one
column
of
one
row).
If
the
sub query
returns
more
than
one
v
alue,
an
error
is
given.
If
the
sub query
returns
no
rows,
the
predicate
ev
aluates
to
unkno
wn.
Example
The
part
n
um
b ers
of
parts
that
require
few
er
than
20
da
ys
for
deliv
ery
are
retrieved.
SELECT
PartNumber
FROM
PurchDB.SupplyPrice
WHERE
DeliveryDays
<
20
9-6
Search
Conditions
...Dieses Handbuch ist für folgende Modelle:
Software - MPE/iX 6.5 Operating System (1.57 mb)