sql

[Uma]

CREATE PROCEDURE DB2ADMIN.Proc1 (IN v_PWD CHAR(20),OUT v_encpt char(40))
RESULT SETS 1
LANGUAGE SQL
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
-- Declare cursor
DECLARE V_NUM INT DEFAULT 0;
DECLARE V_TMP_NUM INT DEFAULT 0;
DECLARE V_TMP_STR CHAR(3);
DECLARE V_TMP_PWD CHAR(12) default '';
DECLARE V_PWD_S CHAR(20);
SET V_PWD_S=v_PWD;
WHILE V_PWD_S<>'' DO

SET V_NUM=V_NUM+1;
SET V_TMP_NUM=ASCII(SUBSTR(v_PWD,V_NUM,1));

IF V_TMP_NUM < 10 THEN
SET V_TMP_STR=CHAR('00' || LTRIM(CHAR(V_TMP_NUM)));
ELSEIF V_TMP_NUM < 100 THEN
SET V_TMP_STR=CHAR('0' || LTRIM(CHAR(V_TMP_NUM)));
ELSE
SET V_TMP_STR=CHAR(LTRIM(CHAR(V_TMP_NUM)));
END IF;

IF V_TMP_PWD = '' THEN
SET V_TMP_PWD= char(V_TMP_STR);
ELSE
SET V_TMP_PWD= char(V_TMP_PWD) || char(V_TMP_STR);
END IF;

SET V_PWD_S=SUBSTR(v_PWD,V_NUM+1);
END WHILE;

SET v_encpt=V_TMP_PWD;
--SET V_TMP_VAR = SQLSTATE|| CAST(SQLCODE AS CHAR(5));
END P1
This simple SP takes a stirng , and returns ASCII value of the string .
(Eg : ABC o/p is 062063064)

SET V_TMP_PWD= char(V_TMP_PWD) || char(V_TMP_STR); This statement is failing??

any ideas ..

Thanks
Uma