Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.