sqliquery.com
Cozzi Software Ordering
http://www.sqliquery.com/purchase.html
To place an order, type in the following Information, then press "Start Online Order":. If you have already created an account with us on our Customer Registration Page. Your information will be automatically filled in when you proceed to the next page. To start an online order or check pricing for our software, type in your email address and IBM i Serial Number, then click Start Online Order. Email Address (or customer number, if known):. IBM i Serial numbers ( up to two per license at time of purchase.
sqliquery.com
COZTOOLS Contact and Support
http://www.sqliquery.com/license.html
Cozzi Productions - Product License Keys. Easy Steps to License Key Retrieval. Type in your information:. IBM i system serial number (use DSPSYSVAL QSRLNBR to retrieve this information). We need your IBM i system serial number to generate your trial license key. Select the License option (Perm or Temp). The license key will be emailed to you. Your IBM i serial number:. Permanent License Key (paid software licenses only). 14-day Trial License Key Extension.
sqliquery.com
COZTOOLS Command List
http://www.sqliquery.com/commands.html
SQL iQuery Commands and HELP TEXT. You can use iQuery to run SQL statements or scripts from the web, as well as the IBM i CL programs or Command Line. Below is a list of the SQL iQuery CL commands. To view the Helptext for the iQuery command, just click on the command name. No Member List Available. No members are detected for requested source file and library, or you are not authorized to the requested object.
sqliquery.com
SQL iQuery for IBM i - Examples
http://www.sqliquery.com/qryfQuickStart.html
Trade; Quick Start. A few examples of using SQL iQuery's command line tool and mobile/web component are illustrated here. More examples are available here. To learn about the SQL iQuery Scripting Tool, click one of the links below. The Report Codes Reference is here. To generate some cool-looking HTML output, use RUNiQRY and specify OUTPUT(*HTML). RUNIQRY SQL('SELECT CUSNUM,LSTNAM,CITY,STATE,ZIPCOD,BALDUE,CDTDUE FROM QIWS/QCUSTCDT') OUTPUT(*HTML). OUTPUT(*HTML) When Viewed with a Browser:. RUNIQRY SQL('S...
sqliquery.com
SQL iQuery for IBM i Command Helptext
http://www.sqliquery.com/qryfMacros.html
Normally, to run an SQL statement, you specify it on the SQL parameter of the RUNIQRY command as follows:. RUNIQRY SQL('SELECT * FROM QIWS/QCUSTCDT'). You can also save the SQL statement in a source member and recall it later, using the following syntax:. A great feature in SQL iQuery allows users to store SQL statements in source member and more easily recall them. We call this our "SQL Macro" feature or simply,. Then following RUNIQRY command could be used to run that SQL statement as follows:. When RU...
sqliquery.com
SQL iQuery Support
http://www.sqliquery.com/support.html
To display your Invoice for an existing or previous Order:. To email us directly:. Type the required information, then press Save. Trial License Key request. Type your comment or request here: (required). Check out SQL iQuery for yourself. Download our free trial today.
sqliquery.com
SQL iQuery for DB2 for i - Beta Information
http://www.sqliquery.com/qryfJSON.html
For IBM i -. SQL iQuery Supports Direct JSON Output. JSON or JavaScript Object Notation is a lightweight data-interchange format that is substantially similar to the old Microsoft SyLK format used for Excel. It is also similar in syntax to HTML's Cascading Style Sheets (CSS) and has some of the capabilities of XML but without all those special exploits in XML. To generate JSON for QCUSTCDT, I used the following SQL iQuery command and specified the industry-standard SQL SELECT statement:. Here is the JSON...
sqliquery.com
SQL iQuery for DB2 for i - Beta Information
http://www.sqliquery.com/qryfExcel.html
For IBM i - Excel Support Page. SQL iQuery Supports 2 Excel Output Choices. Exporting IBM i db2 database files to Excel has been around for more than two decades. Today the most popular format to use is CSV (Comma Separated Values) for importing to Excel, followed by the ODBC driver available to Excel Users for importing data directly from the IBM i system. SQL iQuery supports exporting to Excel in two different formats:. To use industry standard SQL and output CSV, use our RUNIQRY command as follows:.
sqliquery.com
SQL iQuery for IBM i Command Helptext
http://www.sqliquery.com/qryfUDF.html
Trade; UDF's and Procedures. The SQL iQuery product includes the following functions and (stored) procedures. Visit the SQL iQuery Product Information Page. An example of the MBRLIST UDF is. Featured at this link. Click on the name to view the information for the UDF or procedure. Bob Cozzi's Source Viewer - COZWEB/QUDFHELP(COZUDF). Add one or more libraries to the User portion of the library list. CALL QUSRSYS.ADDLIBLE( 'COZTOOLS COZQRYF QGPL QTEMP');. CALL QUSRSYS.RMVLIBLE( 'QGPL QTEMP');. Sets the Job...
