| Product: | DBConnectivity Products for IBM Db2 for i (HiT ODBC/400, HiT OLEDB/400, Ritmo/i, HiT JDBC/400) |
| Version: | All |
| ID: | 1226 |
| Summary: | Use a CL command to change a query job priority for IBM i |
To change the run priority for a querry, issue the CHGJOB command early in your SQL statement stream (before your SELECT/INSERT/UPDATE). This is achieved via QCMDECX API and SQL with the CL command: "CHGJOB RUNPTY(20)".
Use the following SQL statement to issue this CL command:
CALL qsys.qcmdexc('CHGJOB RUNPTY(20)', 0000000017.00000)