Very Computer

by **Irina Kotlov** » Sun, 31 Dec 1899 09:00:00

This is a multi-part message in MIME format.

------=_NextPart_000_0254_01BDD7F6.17449860
Content-Type: text/plain;
charset="windows-1251"
Content-Transfer-Encoding: quoted-printable

Hello!

Absolutely stupid question.
If DB is started without transaction log, then will the statements BEGIN =
WORK - COMMIT WORK have any effect on DB? I expect that NO.

Thank you in advance,
Irina

Irina Kotlova
RESEARCH & TRADE RUSSIA

phone: +7 095 959-43-13 (additional 24)

------=_NextPart_000_0254_01BDD7F6.17449860
Content-Type: text/html;
charset="windows-1251"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>

<META content=3D"text/html; charset=3Dwindows-1251" =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.71.1712.3"' name=3DGENERATOR>
</HEAD>
<BODY bgColor=3D#d1f1f8>
<DIV><FONT color=3D#000000>Hello!</FONT></DIV>
<DIV><FONT color=3D#000000></FONT> </DIV>
<DIV><FONT color=3D#000000>Absolutely stupid question.</FONT></DIV>
<DIV><FONT color=3D#000000></FONT>If DB is started without transaction =
log, then=20
will the statements BEGIN WORK - COMMIT WORK have any effect on DB? I =
expect=20
that NO. </DIV>
<DIV> </DIV>
<DIV>Thank you in advance,</DIV>
<DIV>Irina</DIV>
<DIV><FONT color=3D#000000><BR>Irina Kotlova<BR>RESEARCH & TRADE=20

<A=20

+7 095=20
959-43-13 (additional 24)<BR></FONT> </DIV></BODY></HTML>

------=_NextPart_000_0254_01BDD7F6.17449860--

by **Scott Kolay** » Sun, 31 Dec 1899 09:00:00

The engine will return a sql error -256 "transaction not available" to the
calling program.

Scott Kolaya

>Hello!

>Absolutely stupid question.
>If DB is started without transaction log, then will the statements BEGIN =
>WORK - COMMIT WORK have any effect on DB? I expect that NO.

>Thank you in advance,
>Irina

>Irina Kotlova
>RESEARCH & TRADE RUSSIA

>phone: +7 095 959-43-13 (additional 24)

by **Robert Stuar** » Sun, 31 Dec 1899 09:00:00

The DB will be OK, but your program won't!

If you don't trap the situation, a 4gl will just fall over,
sql scripts will stop at this point.

Cheers

Robert Stuart

> This is a multi-part message in MIME format.

> ------=_NextPart_000_0254_01BDD7F6.17449860
> Content-Type: text/plain;
> charset="windows-1251"
> Content-Transfer-Encoding: quoted-printable

> Hello!

> Absolutely stupid question.
> If DB is started without transaction log, then will the statements BEGIN =
> WORK - COMMIT WORK have any effect on DB? I expect that NO.

> Thank you in advance,
> Irina

> Irina Kotlova
> RESEARCH & TRADE RUSSIA

> phone: +7 095 959-43-13 (additional 24)