Re: ODBC error 'Function Sequence Error' in SQR

[Jean-Luc Peyret <Jean-Luc_Peyret@PEOPLESOFT.COM>]

Hi.

This is from a an earlier exchange I had with someone else on this subject
(who was creating temp tables).  Check what could be triggering a COMMIT of
some kind.

JLuc


>>>>
Hi,

I've seen this error before, in an Application Engine.  Error code S1010.

Cause:  when you COMMIT you close all opened cursors.

In other words:

1.  you select
2.  you COMMIT => implicit close of your cursors
3.  you fetch - no more open cursor => your error.

Now, I think a DDL command (Data Definition Language - like Create Table,
View, etc...)  issues an implicit COMMIT on most databases, hence your
error because SQR typically keeps lots of cursors open.

Solutions:

In SQR, I believe you are advised to do most of that CREATE xxx stuff in
the begin-setup section of the program.

There maybe a switch to set your server to a different state where it
doesn't close cursors.

You might avoid this if you don't have any begin-select processing loops
open when you create your temp table.  Meaning that you process all your
current begin-selects (including loops which are calling from a higher
level, if any).

JLuc