作者sask (sask)
看板Database
标题[SQL ] 关於Function
时间Fri Jul 2 18:08:20 2010
请问各位
我用的资了库是DB2 写了一个function如下:
CREATE FUNCTION "TOOLS"."TEST"()
RETURNS VARCHAR(512)
SPECIFIC test
LANGUAGE SQL READS SQL DATA
BEGIN
DECLARE out_str VARCHAR(512) DEFAULT '';
DECLARE num_x NUMERIC(9,6) DEFAULT 0;
DECLARE ori_x CURSOR FOR SELECT X FROM TW1.TMP_DB2SHP_PLACE_GEOMETRY WHERE
SEQ1= 1;
DECLARE l INTEGER DEFAULT 1;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET l = 0;
OPEN ori_x;
X_LOOP: LOOP
FETCH ori_x INTO num_x;
SET out_str = INSERT(out_str,LENGTH(out_str),0,num_x);
IF l = 0 THEN LEAVE X_LOOP; END IF;
SET out_str = INSERT(out_str,LENGTH(out_str),0,',');
END LOOP;
CLOSE ori_x;
RETURN out_str;
END
结果执行後产生如下错误讯息:
DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=<variable
declaration>;;<SQL statement>, DRIVER=3.50.152
请问是哪里出问题呢??
感谢各位~~
--
It's Impossible To Give A Hug Without Getting One Back.
By Garfield
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 220.130.36.2