Solution : https://service.sap.com/sap/support/notes/527777 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the requirement for 'preparing' an EXEC SQL statement (Native SQL) before each execution in liveCache or the SAP DB. The enhancement of the statement cache optimizes the PREPARE times for SQL statements. The enhanced statement cache is incorporated in DBSL libraries for various SAP versions: 46D at patch level 1168, 610 at patch level 600, and 620 at patch level 153. To implement this optimization, users must apply respective patches available on the SAP Service Marketplace, following the guidance outlined in SAP Note 19466.
Key words :
- 46d patch level 1168- 610 patch level 600- 620 patch level 153the patch, sap db dbsl libraries, terms sap db, sap service marketplace, existing statement cache, exec sql statement, statement cache, sql statement, native sql, 'prepared'
Related Notes :
| 534476 | Exception during disconnect from SAPDB |
| 391944 | Statement cache for COM routines |
| 19466 | Downloading SAP kernel patches |