SAMPLES

Support email

www.MidrangeNews.com

Contact Us

SQL iQuery Logo

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.

MemberLast ModifiedViewsText
COSVER2019-01-01 14.00.49333inline C code for OSVER UDF (DO NOT COMPILE)
COSVRM2019-01-01 14.00.49309inline C code for OSVRM UDF (DO NOT COMPILE)
CRTVCMDD2019-01-01 14.00.49128inline C code for RTVMBRD UDF (DO NOT COMPILE)
CRTVMBRD2019-01-01 14.00.49248inline C code for RTVMBRD UDF (DO NOT COMPILE)
CRTVNETA2019-01-01 14.00.49126inline C code for RTVNETA UDF (DO NOT COMPILE)
CSYSINFO2019-01-01 14.00.49255inline C code for SYSINFO UDF (DO NOT COMPILE)
EDITCODES2019-01-01 14.00.49291RPG and DDS Edit Codes Table
EDITCODEVW2019-01-01 14.00.49259RPG and DDS Edit Codes Table
EDTCDE2019-01-01 14.00.49283RPG and DDS Edit Codes Table - Listing
IBMBLOG2019-01-01 14.00.49984IBM Db2 for i Blog article query
MBRLIST2019-01-01 14.00.49571Example shows the use of our MBRLIST UDTF
MSGW2019-01-01 14.00.491006Detect & report jobs in Message Wait (MSGW) status
OSVER2019-01-01 14.00.49252SQL UDF Source for OSVER (COMPILE THIS)
OSVRM2019-01-01 14.00.49249SQL UDF Source for OSVRM (COMPILE THIS)
RTVCMDD2019-01-01 14.11.45100SQL UDF Source for RTVCMDD (COMPILE THIS)
RTVMBRD2019-01-01 14.00.49300SQL UDF Source for RTVMBRD (COMPILE THIS)
RTVNETA2019-01-01 14.00.49129SQL UDF Source for RTVNETA (COMPILE THIS)
SYSINFO2019-01-01 14.00.49394SQL UDF Source for SYSINFO (COMPILE THIS)

Copyright © 2015 Cozzi Productions, Inc. All Rights Reserved.