Topic
  • 1 reply
  • Latest Post - ‏2013-11-25T05:58:43Z by David_Zhu
PPJ5_Goran_Pribicevic
1 Post

Pinned topic IBM Data Studio 4.1 - Informix - won't create stored procedure

‏2013-11-20T10:21:49Z |

I am trying to create stored procedure using Data Project Explorer but it won't work in 4.1. I am currently using 3.2 version because of this problem.

Procedure:

CREATE PROCEDURE PROCEDURE1 ( OUT VARCOUNT INTEGER)

                -- #######################################################################

                -- # Returns count of tables created by informix

                -- #######################################################################

                SELECT COUNT (*) INTO VARCOUNT FROM INFORMIX.SYSTABLES WHERE OWNER = 'informix';             

END PROCEDURE;

 

Error:

The routine could not be created due to a parsing error. Common causes for parsing errors include specifying an invalid routine name or selecting a template that contains errors. Correct any parsing errors in template before creating the routine

I am using DRDA connection to IDS 11.7 with db2jcc4.jar drivers on both versions 3.2 and 4.1. Older version is working without problems but 4.1 version won't create this simple procedure.

  • David_Zhu
    David_Zhu
    15 Posts

    Re: IBM Data Studio 4.1 - Informix - won't create stored procedure

    ‏2013-11-25T05:58:43Z  

    Hi,Goran,

    Thanks for post this problem, This is a known issue for DS4.1 and we already fix it. You can keep DS3.2 before the fix avaiable for public. Sorry for the trouble of this problem.

     

    Thanks.