SQL iQuery™
Examples and Demo Scripts
The list below contains several SQL and iQuery example scripts. They may be accessed in the QDEMOSRC file in the IQUERY library.
To run them, use the RUNiQRY command as follows:
RUNiQRY SRCMBR(mmmmm) SRCFILE(IQUERY/QSQLSRC)
Where mmmmm is the name of the sample source member from the list below.
Click the Sample name to view the SQL iQuery source in that member.
Powered by COZTOOLS find out more
Click on a name in the list to view its contents.
Source Viewer © 2004 Robert Cozzi, Jr. All rights reserved.
| Member | Last Modified | Views | Text |
| COSVER | 2017-09-18 15.43.07 | 11 | inline C code for OSVER UDF (DO NOT COMPILE) |
| COSVRM | 2017-09-18 15.43.07 | 10 | inline C code for OSVRM UDF (DO NOT COMPILE) |
| CRTVMBRD | 2017-09-18 15.43.07 | 12 | inline C code for RTVMBRD UDF (DO NOT COMPILE) |
| CSYSINFO | 2017-09-18 15.43.07 | 11 | inline C code for SYSINFO UDF (DO NOT COMPILE) |
| EDITCODES | 2017-09-18 15.43.07 | 17 | RPG and DDS Edit Codes Table |
| EDITCODEVW | 2017-09-18 15.43.07 | 12 | RPG and DDS Edit Codes Table |
| EDTCDE | 2017-09-18 15.43.07 | 12 | RPG and DDS Edit Codes Table - Listing |
| IBMBLOG | 2017-09-18 15.43.07 | 554 | IBM Db2 for i Blog article query |
| MBRLIST | 2017-09-18 15.43.07 | 70 | Example shows the use of our MBRLIST UDTF |
| MSGW | 2017-09-18 15.43.07 | 378 | Detect & report jobs in Message Wait (MSGW) status |
| OSVER | 2017-09-18 15.43.07 | 15 | SQL UDF Source for OSVER (COMPILE THIS) |
| OSVRM | 2017-09-18 15.43.07 | 13 | SQL UDF Source for OSVRM (COMPILE THIS) |
| RTVMBRD | 2017-09-18 15.43.07 | 19 | SQL UDF Source for RTVMBRD (COMPILE THIS) |
| SYSINFO | 2017-09-18 15.43.07 | 25 | SQL UDF Source for SYSINFO (COMPILE THIS) |