I have a Store Procedure I run through a scheduled task. From time to time I get this error:
ERROR IX000 IBMCLI Driver
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?