Some of our java developers are trying to use the new and improved data-dependent pagination feature, which the manual tells me ought to be available at FL100, and they keep hitting the following error:
ATTEMPT TO USE A FUNCTION WHEN THE APPLICATION COMPATIBILITY SETTING IS SET FOR A PREVIOUS LEVEL. SQLCODE=-4743, SQLSTATE=56038, DRIVER=4.18.60
We have checked and rebound all our SQLJ packages with APPLCOMPAT(V12R1M100), but this doesn't seem to have helped.
The SQL they run is as follows:
select * from xxxxxdb1.g8830004.P2_MESSAGESTATUS offset 10 rows fetch first 10 ROWS ONLY
Any hints, please?
We are VERY puzzled.
Aurora Emanuela Dellanno[Organization Members] @ May 05, 2020 - 12:42 PM (Europe/London)