赤裸裸的DB2 SQLCODE=-104错误


部署 DWPINST1.P_FUNC_SHIPMENT_LOAD_DATES(VARCHAR(100))


正在运行
DWPINST1.P_FUNC_SHIPMENT_LOAD_DATES - 已开始为调试而部署。
DROP SPECIFIC PROCEDURE DWPINST1.SQL110512204245200
DWPINST1.P_FUNC_SHIPMENT_LOAD_DATES - 已完成删除 存储过程。
创建 存储过程 返回 SQLCODE: -104, SQLSTATE: 42601。
DWPINST1.P_FUNC_SHIPMENT_LOAD_DATES: 107: An unexpected token "SELECT VR_SHIPMENTID FROM SHIPMENT" was found following "BILL_UK='01' THEN
  ".  Expected tokens may include:  "<psm_sql_stmt>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.7.89
An unexpected token "SELECT VR_SHIPMENTID FROM SHIPMENT" was found following "BILL_UK='01' THEN
  ".  Expected tokens may include:  "<psm_sql_stmt>".. SQLCODE=-104, SQLSTATE=42601, DRIVER=4.7.89
DWPINST1.P_FUNC_SHIPMENT_LOAD_DATES - 为调试而部署失败。
DWPINST1.P_FUNC_SHIPMENT_LOAD_DATES - 已成功完成回滚。




评论

此博客中的热门博文

Kettle设计中 判断的基准和多数据流时的主键唯一性

9月的诚品书单[待修订]

引用 vista下.lnk快捷方式打开方式修复