cursor question

[John Mcnall <jmcnall@TGTSOLUTIONS.COM>]

Hello group,
 I have 2 cursor questions for anyone or everyone.
 When I ran a report I got an error = "1808 Cannot find inactive database
cursor. Program too large."
 So I decided to find out when a cursor is used and how many you can have.

In the SQR users guide for version 4 on page 175-176 It says

The cursor pool consists of 30 cursors, and its size cannot be changed.
When a SQL statement is re-executed, its cursor can be immediately
reused if it is still in the cursor pool. When your SQR program executes
more than 30 different SQL statement, cursors in the pool are reassigned.

But in the SQR language reference manual for version 4 it says on pages
345-346:

Entry           Default         Maximum Entry   Description
CURSORS         6               25              --      (SQLBase) Maximum number of
concurrent open database cursors.

In addition to increasing the sizes you may also lower them to decrease the
amount of memory used.


This seams contradictory to me, so how many cursors can you have and is that
number fixed or can you change it?

Question 2

While researching I came across this: (page 175-176)

The listing will also include the number of "compiles," which will vary
according to the database and the complexity of the query. With Oracle,
for example, a simple query is compiled only once. With SYBASE, a SQL
statement is compiled before it is first executed and recompiled for the
purpose of validation during the SQR compile phase. Therefore, you may
see two compiles for a SQL statement. Later when the SQL is re-executed,
if its cursor is found in the cursor pool, it can proceed without
recompiling.

However, My understanding is that an SQR is compiled and then executed. So
can someone please interpret this for me because it sounds like it's saying
it is compiled before execution and then recompiled?

Thank you in advance for your help and comments.

J. McNall
TGT Solutions Inc.