Native SQL PL performance improvements

mallik4u · New User Joined: 17 Sep 2008 Posts: 75 Location: bangalore

Hi,

I am not finding detail descriptions about Native SQL PL performace improvements in Db2V10. I am looking for the following 2 points.

–Section load avoidance with SET statements with function
–Pathlength reduction in IF statement

Any referrence to documents or explanation about above 2 points are greatly appretiated.

Thanks,
Mallik

Akatsukami · Posted: Mon Oct 14, 2013 8:54 pm

Please look at the DB2 10 for z/OS SQL Reference, topics Statements and SQL Control Statements for SQL Routines.