Using Open Query Commands (Magic xpa 3.x)
In IBM i, the Open Query Function command, OPNQRYF (Ctrl+H), lets you send complex query conditions to the AS/400 database. The database engine processes the query and sends the records related to the query results to the client through the network. This means that the data is sent to the client only after the Sort operation has been performed. The OPNQRYF command lets you use complex queries or queries on specific fields that do not have a related key. If a virtual key is defined for a table, the key is implemented using the OPNQRYF command. When the DBMS Sort option is specified for the AS/400 DBMS entry, the sort feature is implemented using the OPNQRYF command.
In Magic xpa, the OPNQRYF command is expressed by either a:
-
Built-In Open Query – Provides limited Open Query commands but increases the performance speed because all record matching processes are done on the server.
-
Direct Open Query – Provides full access to all Open Query commands but requires more time because the record matching process is done on the client.
Note: By selecting the Server Sort option in the Database Properties dialog box, you are instructing Magic xpa to perform the Sort operation for the task by using the virtual indexes defined in Magic xpa to open a Query file. If the Server Sort property is selected, Magic xpa will not perform its own sort but will issue an OPNQRTYF statement.
Magic xpa with an ISAM Client
Magic xpa with an SQL Client
