Db2 12 FL100 V12R1M100 - pagination gets SQLCODE -4743

Aurora Emanuela Dellanno

Db2 12 FL100 V12R1M100 - pagination gets SQLCODE -4743

hi guys,

 

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.

 

Thanks.

 

Aurora

Edited By:
Aurora Emanuela Dellanno[Organization Members] @ May 05, 2020 - 12:42 PM (Europe/London)

David Simpson

Db2 12 FL100 V12R1M100 - pagination gets SQLCODE -4743 [EXTERNAL]
(in response to Aurora Emanuela Dellanno)
Does the manual say that?

SQL new features are not available until V12R1M500+

Sent from Outlook Mobile https://aka.ms/blhgte
________________________________
From: Aurora Emanuela Dellanno <[login to unmask email]>
Sent: Tuesday, May 5, 2020 6:41:56 AM
To: [login to unmask email] <[login to unmask email]>
Subject: [DB2-L] - Db2 12 FL100 V12R1M100 - pagination gets SQLCODE -4743 [EXTERNAL]


hi guys,



Some of our java developers are trying tu 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.



Thanks.



Aurora

-----End Original Message-----
________________________________
Please note: This message originated outside your organization. Please use caution when opening links or attachments.

Daniel Luksetich

Db2 12 FL100 V12R1M100 - pagination gets SQLCODE -4743
(in response to Aurora Emanuela Dellanno)
V12R1M500 is what you want.



+--------------------------------------+-----------------------------------------------------------+

| Daniel L Luksetich | IBM Certified Advanced Database Administrator – |

| IBM GOLD Consultant | Db2 10.1 for Linux UNIX and Windows |

| IDUG Content Committee Past-Chairman | IBM Certified Database Adminstrator – Db2 12 for z/OS |

| IDUG DB2-L Administrator | IBM Certified System Administrator – Db2 11 for z/OS |

| URL: https://db2expert.com https://db2expert.com | IBM Certified Application Developer – Db2 11 for z/OS |

+--------------------------------------+-----------------------------------------------------------+





From: Aurora Emanuela Dellanno <[login to unmask email]>
Sent: Tuesday, May 5, 2020 6:42 AM
To: [login to unmask email]
Subject: [DB2-L] - Db2 12 FL100 V12R1M100 - pagination gets SQLCODE -4743



hi guys,



Some of our java developers are trying tu 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.



Thanks.



Aurora



-----End Original Message-----

Attachments

  • image001.png (9.6k)
  • image002.png (14k)
  • image003.png (10.4k)
  • image004.png (11.7k)
  • image005.png (13.7k)
  • image006.png (13.1k)
  • image007.png (14.2k)
  • image008.png (7.5k)

Aurora Emanuela Dellanno

RE: Db2 12 FL100 V12R1M100 - pagination gets SQLCODE -4743
(in response to Aurora Emanuela Dellanno)

David and Dan,

 

no doubt you are right - I misinterpreted the manual, which places pagination in the "Application enablement in the Db2 12 initial release" list, which to me was FL100.

 

I had thought about it, but the initial release thing sidetracked me, frankly. Meh.

 

Thanks.

 

Aurora

Edited By:
Aurora Emanuela Dellanno[Organization Members] @ May 05, 2020 - 01:55 PM (Europe/London)