I tested the following statement in UDB7.1 successfully, but failed at UDB8.0 at same OS(win2k).

String str_max ="declare global temporary table ttt2 like log_load_delivery_tbyd_tbl on commit preserve rows not logged with replace in tempok1";
Statement stmt_max = con.createStatement();
ResultSet rs_max = stmt_max.executeQuery(str_max);

The exception message is "[IBM][JDBC driver]CLI0637E query cannot be found"

Under UDB8's command prompt, the same SQL statement works well, but it failes when I invoke it from my java code.

Anyone could help me with this problem? Why the same statement works well in my old UDB7.1 but failed at udb8?

Thanks

Try using execute() or executeUpdate() instead of executeQuery(). This isn't a query, after all.

Great answer. That resolves my problem. Thanks a bunch.