Hi I am new in DB2, and I have some problems when I try run stored
procedures, and others statements. I made one stored procedure very
simple, but this show different messages.

I have followed the indications that have said me in answer to topics,
but without positive results

This is the stored procedure

CREATE PROCEDURE TESTS (  )
--    DYNAMIC RESULT SETS 1
LANGUAGE SQL MODIFIES SQL DATA

P: BEGIN ATOMIC
  FOR V1 AS
     SELECT   B.CLIENTID AS IDCLIENTID,
     B.MAPPEDCLIENTID AS MAPPED
     FROM     EIS.CLI_MAPING B
     WHERE
    B.STATUSID = 3 AND
    B.CLIENTID != B.MAPPEDCLIENTID
  DO
     DELETE FROM EIS.CLI_BANK
     WHERE  CLIENTID = IDCLIENTID;
  END FOR;
END P

This is the message

DELETE FROM EIS.CLI_BANK
WHERE  CLIENTID = IDCLIENTID
DB21034E  The command was processed as an SQL statement because it was
not a
valid Command Line Processor command.  During SQL processing it
returned:
SQL0104N  An unexpected token "END-OF-STATEMENT" was found following
"LIENTID
= IDCLIENTID".  Expected tokens may include:  "<psm_semicolon>".  LINE
NUMBER=15.  SQLSTATE=42601

END FOR
DB21034E  The command was processed as an SQL statement because it was
not a
valid Command Line Processor command.  During SQL processing it
returned:
SQL0104N  An unexpected token "END-OF-STATEMENT" was found following
"END
FOR".  Expected tokens may include:  "JOIN <joined_table>".
SQLSTATE=42601

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.

Thanks for its amiability.

Greetings

Iván