SQL iQuery™
Examples and Demo Scripts
The list below contains several SQL and iQuery example scripts and UDF/UDTF source members. They may be accessed in the QDEMOSRC file in the IQUERY library.
To run the samples 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.
To compile the samples that are UDF/UDTF functions, use
RUNSQLSTM SRCMBR(mmmmm) SRCFILE(IQUERY/QSQLSRC)
Note that you "compile" the SQL code only, not the C-code as that is inline code that will automatically get compiled by the RUNSQLSTM command. Just be sure you store the example C code in the IQUERY library or change the INCLUDE statement within the SQL UDF/UDTF source code to point at whatever library you are using.
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 |
| AFPFORM01 | 2023-11-14 09.31.00 | 1564 | Example of using iQuery AFP Driver to build a form |
| EDITCODES | 2023-11-14 09.31.00 | 2371 | RPG and DDS Edit Codes Table |
| EDITCODEVW | 2023-11-14 09.31.00 | 2177 | RPG and DDS Edit Codes Table |
| EDTCDE | 2023-11-14 09.31.00 | 2204 | RPG and DDS Edit Codes Table - Listing |
| IBMBLOG | 2023-11-14 09.31.00 | 3531 | IBM Db2 for i Blog article query |
| MBRLIST | 2023-11-14 09.31.00 | 2646 | Example shows the use of our MBRLIST UDTF |
| MSGW | 2023-11-14 09.31.00 | 3061 | Detect & report jobs in Message Wait (MSGW) status |