Stimmen - 0, Durchschnittliche Bewertung: 0
(
)
)
|
Dieses Gerät hat auch andere Anweisungen:
Anleitung Zusammenfassung
INPUT
The
INPUT
command
inserts
rows
in
to
an
existing
table.
Scope
ISQL
only
.
ISQL
Syntax
2
3
2
3
2
32
3
Owner .
T
ableName
2
3
UT
, ColumnName
.
.
.
INP
( ColumnName
)
Owner .
ViewName
2
32
3
2
3
2
3
ROLLBACK
WORK
, V
alue
.
.
.
.
.
.
ND
( V
alue
)
E
COMMIT
WORK
P
arameters
[ Owner
.] T
ableName
iden
ties
a
table
in
the
DBEn
vironmen
t
y
ou
are
using.
[ Owner
.] ViewName
iden
ties
a
view
based
on
a
single
table.
Refer
to
the
discussion
of
the
CREA
TE
VIEW
statement
in
the
ALLBASE/SQL
R
efer
enc
e
Manual
,
for
restrictions
gov
erning
insert
op erations
on
a
view.
The
new
rows
are
inserted
in
to
the
table
on
whic
h
the
view
is
based.
ColumnName
iden
ties
the
column(s)
for
whic
h
y
ou
will
sp ecify
v
alues.
Columns
not
sp ecied
are
assigned
n
ull
v
alues
(if
allo
w
ed).
Y
ou
m
ust
pro
vide
data
for
an
y
column
that
do es
not
allo
w
n
ull
v
alues.
V
alue
is
data
to
b e
inserted
in
to
a
column.
Within
eac
h
set
of
paren
theses,
y
ou
sp ecify
one
row
of
data;
put
a
space,
a
carriage
return,
or
a
comma
b et
w
een
sets
of
paren
theses.
A
v
alue
m
ust
b e
sp ecied
for
eac
h
ColumnName
sp ecied,
in
the
order
in
whic
h
y
ou
named
the
columns.
Provide
data
in
the
order
in
whic
h
the
columns
w
ere
named
in
the
table
or
view
denition.
Character
data
that
con
tains
a
single
quote
m
ust
double
the
single
quote.
V
alues
for
a
row
can
span
lines,
but
do
not
split
v
alues
across
lines.
Enclose
c
haracter
v
alues
in
single
quotation
marks.
T
o
sp ecify
a
n
ull
v
alue,
en
ter
NULL.
ROLLBACK
WORK
bac
ks
out
rows
en
tered
since
the
last
COMMIT
W
ORK.
COMMIT
WORK
p erforms
a
COMMIT
W
ORK.
Ro
ws
en
tered
up
to
this
p oint
p ermanen
tly
up date
the
DBEn
vironmen
t.
A
COMMIT
W
ORK
is
also
pro cessed
if
the
SET
command's
A
UTOCOMMIT
is
on
ev
ery
time
the
n
um
b er
of
rows
sp ecied
in
the
A
UTOSA
VE
option
of
the
SET
command
has
b een
en
tered.
4-22
ISQL
Commands
...Dieses Handbuch ist für folgende Modelle:
Software - MPE/iX 6.5 Operating System (492.72 kb)
Software - MPE/iX 7.0 Operating System (492.72 kb)
Software - MPE/iX 7.5 Operating System (492.72 kb)