SET (NEW_VAR.SALARY, NEW_VAR.COMM) = ( 10000 , NEW_VAR.SALARY); 
   SET (NEW_VAR.SALARY, NEW_VAR.COMM)
      = (SELECT AVG(SALARY), AVG(COMM)
           FROM EMPLOYEE E
           WHERE E.WORKDEPT = NEW_VAR.WORKDEPT); 

   SET (NEW_VAR.SALARY, NEW_VAR.COMM)
      = (SELECT AVG(SALARY), AVG(COMM)
           FROM EMPLOYEE E
           WHERE E.WORKDEPT = NEW_VAR.WORKDEPT); 

   
   SET NEW_VAR.SALARY
      = (SELECT AVG(SALARY)
           FROM EMPLOYEE E
           WHERE E.WORKDEPT = NEW_VAR.WORKDEPT); 
   SET NEW_VAR.COMM
      = (SELECT AVG(COMM)
           FROM EMPLOYEE E
           WHERE E.WORKDEPT = NEW_VAR.WORKDEPT); 

CREATE PROCEDURE VVM.XXX()
BEGIN
  DECLARE a     INTEGER;
  DECLARE b     INTEGER;
  DECLARE c     INTEGER;
  SET (a,b,c) = ( 1 , 2 , 3 );
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 "SET" was found following "LARE c     INTEGER; 
".  Expected tokens may include:  "<psm_while>".  LINE NUMBER=5.  
SQLSTATE=42601

SQL0104N  An unexpected token "SET" was found following "LARE c     INTEGER;
".  Expected tokens may include:  "<psm_while>                                  ".

Explanation: 

A syntax error in the SQL statement or the input command string 
for the SYSPROC.ADMIN_CMD procedure was detected at the specified 
token following the text "<text>".  The "<text>" field indicates 
the 20 characters of the SQL statement or the input command 
string for the SYSPROC.ADMIN_CMD procedure that preceded the 
token that is not valid.  

 As an aid, 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 

CREATE PROCEDURE VVM.XXX()
BEGIN
  DECLARE a     INTEGER;
  DECLARE b     INTEGER;
  DECLARE c     INTEGER;
  VALUES ( 1 , 2 , 3 ) INTO a,b,c;
END 
DB20000I  The SQL command completed successfully.