Ansicht
Dokumentation

SQL4018 - Host variables implemented as non-reusable ODP. ( OS/400 )

SQL4018 - Host variables implemented as non-reusable ODP. ( OS/400 )

CL_GUI_FRONTEND_SERVICES - Frontend Services   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.
SAP E-Book


Message : SQL4018
Host variables implemented as non-reusable ODP.

Message Long Text :

Cause . . . . . : The query optimizer has implemented the host variables with a non-reusable open data path (ODP).
Recovery . . . : This can be a good performing option in special circumstances, but generally a reusable ODP gives the best performance. Refer to the DB2 for i - Database Performance and Query Optimization topic collection in the Database category in the IBM i Information Center, http://www.ibm.com/systems/i/infocenter/, for a comparison of reusable and non-reusable ODPs.

Message File : QSQLMSG
Library Message File : QSYS2924


Fill RESBD Structure from EBP Component Structure   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.

Length: 3229 Date: 20240328 Time: 204700     sap01-206 ( 3 ms )