Hi, I can use IBM toolbox jdbc driver to connect to AS400(V5R2) and the general query(like select * from table) is ok. But it failed if I create a stored procedure . Below is the error message and the create procedure script..
 
-- create procedure --
create procedure test1
language sql
begin
end;
 
-- error message --
Error: java.sql.SQLException: [SQL0199] 不預期關鍵字END。 有效記號為( IF GET SET CALL CASE DROP GOTO LOCK OPEN WITH ALTER CLOSE。, SQL State: 42601, Error Code: -199
 
 


========================================

                   Andrew Wang   ...   

========================================

___________________________________________________ 最新版 Yahoo!奇摩即時通訊 7.0,免費網路電話任你打! http://messenger.yahoo.com.tw/