Declare Temporary table cause must be followed a Begin and End, otherwise will raise a compile error.
[IBM][CLI Driver][DB2/6000] SQL0104N 在 "" 之后发现意外的标记 "<variable declaration>"。期望的标记可能包括："<SQL statement>"。 LINE NUMBER=86. SQLSTATE=42601
DECLARE GLOBAL TEMPORARY TABLE SESSION.t ( procr_code char(8) ) WITH REPLACE NOT LOGGED IN GLBL_TEMP_01; BEGIN -- code here END;More about temporary tables please refer to DB2 online document(v8). Here's also an article from IBM DeveloperWorks.
- 文章信息
- 版权声明: 本文可以任意转载，转载时请务必以超链接形式标明文章原始出处和作者信息。
- 原文出处: http://www.aiview.com/
- 写于: 2007-03-01 [Edit]
- 作者: Alex (email &msn)
- 标签 Tags: DB2 Administration (13)
