Re: Scroll Cursor Problems

If you are running Informix 5.0 and below 5.0 then check the DBSPACE available in the root dbspace(onstat -d). Informix opens a temporary table when you open a scroll cursor, it gets created in rootdbspace for Informix 5 and it creates temporary tables if you have a tempdb space defined for Informix 6.0 and above. I have a feeling that you don't have enough dbspace to create the temporary table? In article 1@mhadg.production.compuserve.com, Scully <74521.3635@CompuServe.COM> writes: >My program is an ESQL C program written for HP-UX and I have a >scroll cursor that is causing me problems. > >If I do a fetch current I get an error -259 in the sqlca.sqlcode >which is supposed to mean cursor not open. But if I do a fetch >next it works for part of the table. At some point near the end >of the table I get another -259 error. What gives? > >This error only occurs when I am selecting the whole table >whether by omitting the where clause that is true for all rows in >the table. I can do queries on every imaginable set other than >the entire thing and the query routines work fine. > >If I delete the rows causing the -259 error the queries work but >the problem reappears with every new row that is added. > >I looked for string overwrites b/c I thought I was hammering the >sqlca struct but I haven't found any evidence of that. > >Any ideas? Thanks for Reading This Message. Rob Schulz