Votes - 0, Average rating: 0
(
)
)
|
Other manuals for this model:
manual abstract
isql=>
LOAD;
File
format
(i[nternal]
or
e[xternal])>
INTERNAL;
Input
file
name>
IntFile;
Table
name>
PurchDB.Vendors;
Number
of
rows
read
is
15
Number
of
rows
processed
is
15
COMMIT
WORK
to
save
to
DBEnvironment.
isql=>
Setting
the
A
UTOCOMMIT
Option
Mo
died
or
newly
loaded
data
is
written
to
the
log
buer.
When
a
COMMIT
W
ORK
is
pro cessed,
the
data
is
mov
ed
from
the
log
buer
to
the
log
le
and
the
c
hanges
to
the
DBEn
vironmen
t
are
made
p ermanen
t.
When
nonarc
hiv
e
mo
de
(the
default)
is
set,
the
nonarc
hiv
e
log
le
space
is
reclaimed.
As
in
the
case
of
the
INPUT
command,
ISQL
pro cesses
the
COMMIT
W
ORK
statement
based
on
the
A
UTOCOMMIT
option
v
alue
of
the
SET
command.
If
A
UTOCOMMIT
is
ON,
ISQL
will
con
tinue
to
accept
rows
for
input
un
til
the
load
buer
is
lled,
ev
en
if
the
n
um
b er
of
rows
sp ecied
in
the
A
UTOSA
VE
option
has
b een
exceeded.
Once
the
load
buer
is
full,
a
c
hec
k
is
made
to
see
if
the
n
um
b er
of
rows
sp ecied
in
the
A
UTOSA
VE
option
has
b een
reac
hed
or
exceeded.
If
this
is
the
case
ISQL
pro cesses
a
COMMIT
W
ORK
statement.
If
A
UTOCOMMIT
is
OFF
(the
default
setting),
the
rows
are
committed
only
when
y
ou
en
ter
the
COMMIT
W
ORK
statement.
When
using
nonarc
hiv
e
mo
de,
use
the
A
UTOCOMMIT
command
with
the
option
v
alue
set
to
ON
to
ensure
that
the
nonarc
hiv
e
log
le
(a
circular
le)
is
not
o
v
erwritten
b efore
y
ou
pro cess
the
COMMIT
W
ORK
statement.
Using
Modules
A
mo
dule
is
a
set
of
one
or
more
prepro cessed
statements
that
are
stored
in
the
DBEn
vironmen
t.
Eac
h
stored
statement
is
kno
wn
as
a
section .
ALLBASE/SQL
application
programs
usually
access
mo
dules
that
are
stored
b
y
the
prepro cessor.
Y
ou
can
also
create
mo
dules
in
teractiv
ely
with
the
PREP
ARE
statement
in
ISQL.
Installing
a
Module
An
installable
mo
dule,
whic
h
is
created
b
y
the
ALLBASE/SQL
prepro cessor
b efore
source
co de
is
compiled,
con
tains
information
that
ALLBASE/SQL
uses
to
execute
the
application
program's
SQL
statements
at
run
time.
The
program
can
only
access
the
DBEn
vironmen
t
in
whic
h
its
corresp onding
mo
dule
is
stored.
Sometimes
y
ou
need
to
transfer
a
user-written
application
from
one
DBEn
vironmen
t
to
another.
F
or
instance,
an
application
created
on
a
dev
elopmen
t
mac
hine
may
need
to
b e
transferred
to
a
pro duction
system.
Y
ou
w
ould
need
to
unload
the
data
from
one
DBEn
vironmen
t
and
then
load
it
in
to
the
new
one.
Additionally
,
to
use
an
application
program
in
a
DBEn
vironmen
t
dieren
t
from
that
in
whic
h
it
w
as
dev
elop ed,
y
ou
m
ust
mov
e
the
executable
application
program
le
and
the
le
con
taining
the
installable
mo
dule
to
the
mac
hine
con
taining
the
target
DBEn
vironmen
t.
Using
ISQL
for
Database
T
asks
3-15
...Other models in this manual:
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)