new to db2 - need help to get started

[JP]

I just installed db2 V8.1 and I am trying to create a simple compound
statement in the command center script area and every time I would get
the following error. what am i doing wrong? (note: my statement
termination character is set to ";")

i.e. of compound statement:

begin atomic
declare v_test SMALLINT;
set v_test = 1;
end
error result:
SQL0104N An unexpected token "END-OF-STATEMENT" was found
following "end". Expected tokens may include: "JOIN
<joined_table> ".

Explanation:

A syntax error in the SQL statement was detected at the specified
token following the text "<text>". The "<text>" field indicates
the 20 characters of the SQL statement that preceded the token
that is not valid.

As an aid to the programmer, a partial list of valid tokens is
provided in the SQLERRM field of the SQLCA as "<token-list>".
This list assumes the statement is correct to that point.

The statement cannot be processed.

User Response:

Examine and correct the statement in the area of the specified
token.

sqlcode : -104

sqlstate : 42601

[Database Guy]

jp*****@amalgamatedlife.com (JP) wrote in message news:<4d**************************@posting.google. com>...

I just installed db2 V8.1 and I am trying to create a simple compound
statement in the command center script area and every time I would get
the following error. what am i doing wrong? (note: my statement
termination character is set to ";")

i.e. of compound statement:

begin atomic
declare v_test SMALLINT;
set v_test = 1;
end
error result:
SQL0104N An unexpected token "END-OF-STATEMENT" was found
following "end". Expected tokens may include: "JOIN
<joined_table> ".

With compound SQL the statement is the whole compound block, so you
need to set your termination character to something other than
semi-colon (the only allowed delimiter within the block), e.g. @
symbol. Example:

Type following to get CLP with @ delimiter:

db2 -td@

Then enter:

begin atomic
declare v_test SMALLINT;
set v_test = 1;
end@
DG