Topic
3 replies Latest Post - ‏2012-05-08T14:21:35Z by SystemAdmin
SystemAdmin
SystemAdmin
1143 Posts
ACCEPTED ANSWER

Pinned topic SENSITIVE cursor to INSENSITIVE help

‏2012-05-07T19:02:37Z |
Hello,

I have a Store Procedure I run through a scheduled task. From time to time I get this error:

ERROR IX000 IBMCLI DriverIDS/UNIX64 SQL0243N SENSITIVE cursor "informix.adm_rec" cannot be defined for the specified SELECT statement. SQLSTATE=IX000

I am running v9.7 through an x64 ODBC driver. I did some looking and it seems I need to switch my cursor from SENSITIVE to INSENSITIVE. Where do I do this? In the store procedure or the ODBC configuration?

Thanks.
Updated on 2012-05-08T14:21:35Z at 2012-05-08T14:21:35Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1143 Posts
    ACCEPTED ANSWER

    Re: SENSITIVE cursor to INSENSITIVE help

    ‏2012-05-07T20:18:09Z  in response to SystemAdmin
    Hi,

    You may need to switch your cursor in your stored procedure by setting the statement attribute of SQL_ATTR_CURSOR_SENSITIVITY from SQL_SENSITIVE or SQL_INSENSITIVE.

    HTH, Yunming
  • SystemAdmin
    SystemAdmin
    1143 Posts
    ACCEPTED ANSWER

    Re: SENSITIVE cursor to INSENSITIVE help

    ‏2012-05-08T13:04:28Z  in response to SystemAdmin
    I think that would solve the issue also. I have never modified any settings like this. Where do I put the value? Van show show me an example?
    • SystemAdmin
      SystemAdmin
      1143 Posts
      ACCEPTED ANSWER

      Re: SENSITIVE cursor to INSENSITIVE help

      ‏2012-05-08T14:21:35Z  in response to SystemAdmin
      In you original post you said "I am running v9.7 through an x64 ODBC driver.", what do you mean by that? Are you running an ODBC application to connect to your Informix server? The error SQL0243 seems to be returned by the ODBC driver, so you may need to modify the ODBC appliation you are running.