When executing "Complie SQL Procedure With Debug" in Toad for DB2 4.5, some procedures makes error and stop debugging.
======= error messages ======= DB2 Database Error ERROR [42601] [IBM][DB2/LINUXX8664] SQL0104N An unexpected token ";" was found following " END". Expected tokens may include: ":". LINE NUMBER=1057. SQLSTATE=42601
=========== OS INFO ============= KRPFKDEVR01:/DB2INST1>uname -a Linux KRPFKDEVR01 2.6.9-67.ELsmp #1 SMP Wed Nov 7 13:56:44 EST 2007 x86_64 x86_64 x86_64 GNU/Linux
=============DB2 INFO============= KRPFKDEVR01:/DB2INST1>db2level DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL08027" with level identifier "03080106". Informational tokens are "DB2 v8.1.3.128", "s061108", "MI00180", and FixPak "14".
解决办法
WORKAROUND: None.
STATUS: Waiting for fix in a future release of Toad for DB2.
