SQC
SQL长度超过32K,预编译失败,报错信息如下:
LINE MESSAGES FOR tbl_datamart_trans_log.sqc
------ --------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
33 SQL0314N The host variable "sSql" is incorrectly declared.
SQL0095N No bind file was created because of previous
errors.
SQL0092N No package was created because of previous
errors.
SQL0091W Precompilation or binding was ended with "3"
errors and "0" warnings.
发生错误是因为 DB2 字符串不应该大于 32672 字节。
SQL0314N错误信息说明:
DB2 V9.5 for Linux, UNIX, and Windows
SQL0314N
不正确地声明了主变量