Randy wrote:

> DB2 UDB 8.1.1 / Windows XP
> CLP says DB2/NT 8.2.3
> My terminator is ; that's what it says at the bottom of the Command Editor
> windows.

Try a different statement terminator first. The thing is that the single
SQL statements inside a dynamic compound statement must always be
terminated with a ';'. So you should a different terminator for the
dynamic compound statement (DCS) itself. Otherwise, DB2 will assume at the
first ';' that the DCS is finished now, and when it parses the stuff from
the BEGIN ATOMIC ... to the INT, it finds a syntax error as at least the
closing END keyword is missing.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Works for me now. Thank you !

"Knut Stolze" <stolze@de.ibm.com> wrote in message
news:dsultq$dn4$2@lc03.rz.uni-jena.de...
> Randy wrote:
>
>> DB2 UDB 8.1.1 / Windows XP
>> CLP says DB2/NT 8.2.3
>> My terminator is ; that's what it says at the bottom of the Command
>> Editor
>> windows.
>
> Try a different statement terminator first. The thing is that the single
> SQL statements inside a dynamic compound statement must always be
> terminated with a ';'. So you should a different terminator for the
> dynamic compound statement (DCS) itself. Otherwise, DB2 will assume at
> the
> first ';' that the DCS is finished now, and when it parses the stuff from
> the BEGIN ATOMIC ... to the INT, it finds a syntax error as at least the
> closing END keyword is missing.
>
> --
> Knut Stolze
> DB2 Information Integration Development
> IBM Germany