I have a stored procedure called from the web (Lotus Notes via ADO).
I am doing pagination via web.
I got it to work but I would like to know when I reach the EOF so I can
disable the Next button.
I am trying to do a record count and I believe that is where my issue is.
This is the error message I get in Lotus Notes when the stored procedure is
Error message: IBMDA400 Command: SQL0440: Routine TEST_MB in *N not found
with specified parameters.
Cause . . . . . : A function or procedure with the specified name and
compatible arguments was not found. This could be due to an authorization
failure. Recovery . . . : Specify the correct number and type of
parameters on the CALL statement, CREATE OR REPLACE statement, or function
invocation. Try the request again.
EXEC SQL SELECT COUNT(*)
//TotalRows = TotalRows2;
EXEC SQL Declare RSCURSOR cursor for
SELECT CDEPT, CDESC, ROW_NUMBER() OVER(ORDER BY CDESC, CDEPT) as ROWNUMBER
ORDER BY CDESC, CDEPT
OFFSET (:StartingRow - 1) * :NbrOfRows ROWS
FETCH NEXT :NbrOfRows ROWS ONLY;
// Begin & End of File
IF StartingRow = 1;
BOF = '1';
EOF = '0';
BOF = '0';
EOF = '0';
This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact