Topic
  • 1 reply
  • Latest Post - ‏2012-09-05T22:13:17Z by SystemAdmin
KGMC_Orkan_Sobotawan
1 Post

Pinned topic IBM Data Studio Won't Create Stored Proc, DBACCESS does, Why?

‏2012-09-04T20:44:23Z |
Just installed IBM Data Studio and it's been a big help. Have noticed that IBM Data Studio won't run code that dbaccess will.

I'm using the most current version of IBM Data Studio with the JDBC driver that comes with it for Informix 9.4. This is on a XP machine.

Here is an example of a stored proc that won't run on IBM Data Studio but will run on dbaccess. I know dbaccess probably doesn't depend on odbc like IBM Data Studio does, but I would like to use IBM Data Studio if possible.

create procedure up_del_rotcal(
start_dt DATE , end_dt DATE ) RETURNS INTEGER

DEFINE numrecs int
LET numrecs = 0
DELETE
FROM caa61340
WHERE caa61340001 IN
(select caa61140001
from caa61140
WHERE caa61140005 BETWEEN start_dt AND end_dt
AND moduser='soft'
)
DELETE
FROM caa61240
WHERE caa61240002 IN
(select caa61140001
from caa61140
WHERE caa61140005 BETWEEN start_dt AND end_dt
AND moduser='soft'
)
DELETE
from caa61140
WHERE caa61140005 BETWEEN start_dt AND end_dt
AND moduser='soft'
let numrecs = DBINFO('sqlca.sqlerrd2')
return numrecs
end procedure

Failed queries => 8
Total execution time => 0 ms
Updated on 2012-09-05T22:13:17Z at 2012-09-05T22:13:17Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1632 Posts

    Re: IBM Data Studio Won't Create Stored Proc, DBACCESS does, Why?

    ‏2012-09-05T22:13:17Z  
    Can you share the table DDLs for us to reproduce the problem? If you don't feel like posting on the forum, please be free to contact the IBM service team.

    Thanks,
    Emily