请高手指点一下存储过程的问题？十万火急！

[alanjordan]

我这样建立INFORMIX存储过程怎么老是报错： 201: A syntax error has occurred.请高手指点。
怎么这么奇怪阿，我单独执行SELECT 那段都可以阿，请指导！

CREATE PROCEDURE GBS_TONGYI(START CHAR(8),END1 CHAR(8))

SELECT B.ST_SHORT,SUM(A.U_PREMIUM) AS U_PREMIUM,(SUM(A.U_PREMIUM)/1000000)*100
AS U_DCL
FROM CD_RTA2 A,STATION B
WHERE A.BNCH_ADM='01'
AND A.RQ_START BETWEEN START AND END1
AND A.STATION=B.ST_STATION
GROUP BY B.ST_SHORT
ORDER BY B.ST_SHORT
INTO TEMP CF6;

SELECT * FROM CF6 ORDER BY ST_SHORT;
DROP TABLE CF6;
END PROCEDURE;

[alanjordan]

请高手指导啊！

[alanjordan]

难道就没有哪位高手会INFORMIX吗，真郁闷！

[pcboy_monkey]

试一下在第一个SQL中将所有的列给一个别名，因为在临时表中要有一个字段名来标识一个字段来存储

[JamesJava]

up

[superfly2811]

error: undefined symbol: EXECUTE
error: Syntax error before or at: PROCEDURE
请教各位大虾，该错误怎么处理？ 急ing!

[cloudflashes]

SELECT * FROM CF6 ORDER BY ST_SHORT; －－这一句没有说明把数据取到哪里去

由于存储过程有错，没有建立成功，自然也就不能execute了。

[humdark]

碰到差不多的问题，关注中。。。

[friendwu]

CREATE PROCEDURE GBS_TONGYI(START CHAR(8),END1 CHAR(8))

后面要增加;
缺少了一个符号

[wenlq]

我试了 是SELECT * FROM CF6 ORDER BY ST_SHORT; 这句 报 659 错

-659 INTO TEMP table required for SELECT statement.

A SELECT statement did not specify where to put the returned values.
SELECT statements within a procedure require either an INTO TEMP clause
or an INTO clause that references the appropriate procedural
variables.

Example of error:

CREATE PROCEDURE testproc()
...
SELECT col1, col2 FROM tab; -- error
END PROCEDURE

Correction:

CREATE PROCEDURE testproc()
...
SELECT col1, col2 INTO var1, var2 FROM tab;
SELECT col1, col2 FROM tab INTO TEMP another_table;
END PROCEDURE

[lionstar]

存储过程中不能出现DDL语句（DROP TABLE CF6）