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-2021 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
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.