Zitat Zitat von dschroeder Beitrag anzeigen
Aber OPNQRYF verwendet die klassische SQL Engine ...
Anscheinend nicht mehr ab V7R2, wenn ich dieses Dokument richtig verstehen:

"Improved SQL Query Engine (SQE) capabilities. The progression of expanding the interfaces supported by SQE continues with IBM i 7.2. By default, SQE will be used to implement Native DB queries, including those made via traditional interfaces Open Query File (OPNQRYF) and Query/400. Just by moving to IBM i 7.2, these Native DB queries will be easier to observe and manage through the extensive database tooling found in the IBM i Navigator OnDemand Performance Center . Heavy Native DB queries could reap a performance benefit from an implementation through a far more advanced query engine."

Im IBM i Memorandum für Benutzer Version 7.2 steht natürlich auch etwas darüber drin.