DAL: Using $maxrows and SELECT Statement


I have PATHWORKS (LanWORKS BL/4) running on our MicroVAX 3400. The DAL server
is version 1.2. If I go into IDAL, and set $maxrows to 0, a select statement
returns nothing. My understanding is that the $maxrows is supposed to enable
an an return unlimited amount of data.

We assume that you also issued the "printall;" statement after the "select"
statement. Otherwise, you will not see anything printed.

The System Variables $maxrows is initially set to null. Null is not 0 (zero).
To set $maxrows to the initial value of null, you should set it to $null.

When $maxrows is set to a non-null value, the SELECT and FETCH statements stop
fetching data from the database when they reach the number of rows specified by
$maxrows. Setting $maxrows to 24, for example, yields a 24 rows of database
results without waiting for an entire query to complete. Setting it to 0 will
result in zero rows.


Published Date: Feb 18, 2012