Db2 12 z/OS - default sql level for the precompiler

Aurora Emanuela Dellanno

Db2 12 z/OS - default sql level for the precompiler

Hi guys,

 

does anyone see any mileage or caveats in having different levels specified as default, between APPLCOMPAT and default sql level for the precompiler?

 

I mean, at the moment, for FL100, we have specified APPLCOMPAT(V11R1), but default sql level for the precompiler V12R1M100 - only now we are activating FL500 and it suddenly came to us that it makes no sense to have the second default more advanced than the first.

 

What am I missing here?

 

TIA.

 

oh, happy Friday y'all. Stay the f*** at home, stay safe and healthy.

 

Aurora

Daniel Luksetich

Db2 12 z/OS - default sql level for the precompiler
(in response to Aurora Emanuela Dellanno)
Functionally equivalent except if you fallback to v11. Therefore, it is recommended to favor V11R1 over V12R1M100.

Dan



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

| 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: Friday, May 8, 2020 3:43 AM
To: [login to unmask email]
Subject: [DB2-L] - Db2 12 z/OS - default sql level for the precompiler



Hi guys,



does anyone see any mileage or caveats in having different levels specified as default, between APPLCOMPAT and default sql level for the precompiler?



I mean, at the moment, for FL100, we have specified APPLCOMPAT(V11R1), but default sql level for the precompiler V12R1M100 - only now we are activating FL500 and it suddenly came to us that it makes no sense to have the second default more advanced than the first.



What am I missing here?



TIA.



oh, happy Friday y'all. Stay the f*** at home, stay safe and healthy.



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 z/OS - default sql level for the precompiler
(in response to Aurora Emanuela Dellanno)

Thanks Dan, good to see I can still string two synapsis along after 12 weeks in isolation :O