------------------------------ Commands Entered ------------------------------
CREATE PROCEDURE sp_ServiceConfig ( IN type VARCHAR( 4 ), IN host VARCHAR( 255 ), IN port int,
 				IN iid int, IN pid int, IN rimdata VARCHAR( 2000 ), IN timeout int, OUT version int )
    DYNAMIC RESULT SETS  0 
    LANGUAGE SQL
BEGIN
	SET version =  0 ;
END;
------------------------------------------------------------------------------
CREATE PROCEDURE sp_ServiceConfig ( IN type VARCHAR( 4 ), IN host VARCHAR( 255 ), IN port int,
IN iid int, IN pid int, IN rimdata VARCHAR( 2000 ), IN timeout int, OUT version int )
DYNAMIC RESULT SETS  0 
LANGUAGE SQL
BEGIN
SET version =  0 
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 "EGIN SET 
version = 0".  Expected tokens may include:  "<psm_semicolon>".  LINE 
NUMBER= 6 .  SQLSTATE= 42601 

END
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".  
Expected tokens may include:  "JOIN <joined_table>".  SQLSTATE= 42601 

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