|
SEQUEL can be used for
virtually ALL data access functions
on the System i, including:
· Executive Dashboards
· Graphical Query & Reporting
· Drill-Down Data Analysis
· Multi-Platform Database Support
· E-Mail Report and File Distribution
· Secure Web Access
SEQUEL is the ONE solution for all
your data access needs.
www.ASC-iSeries.com
|
|
|
RPGsp - The Best of Both Worlds
The most comprehensive iSeries Web Development Environment for both building new Web apps and converting green-screens.
That's right! Use RPGsp to instantly convert any existing RPG/CL programs to a great-looking CGI application.
Or point RPGsp to your database files and instantly build new Inquiries, Drill-downs, File Maintenances, and other types of new Web applications.
Click here to download RPGsp.
Click to see videos of RPGsp in action!
Call 1-877-224-7768 or visit www.RPGsp.com
|
|
|
Using Parameter Markers with SQL Functions
by Michael Sansoterra
SQL is a superb data access tool in terms of ease of use and versatility. Data extraction routines that used to take hours to write in RPG or COBOL often takes minutes to write in SQL. The one draw back to dynamic SQL (as compared to data access routines written in a high level language), is that the DB2 query optimizer often takes precious time to figure out how to best execute an SQL request. To take the edge off this performance hit, dynamic SQL statements can be made "reusable" by using parameter markers so that the query optimizer can reuse the previous execution's access plan, and thus boost performance. READ MORE >
|
|
|
|
The System i Pocket RPG & RPGIV Guide
New from Brian Kelly
A comprehensive textbook of up-to-date information, plus RPG & RPG IV examples for the new and experienced AS/400 and System i application developer.
Finally, there is a pocket guide for System i RPG & RPG IV programming--but you better have big pockets! Yes, it is tutorial in nature, and it is packed with reference material so you do not have to switch to a new book once you learn the language.
Buy this book for $69.95 from the IT Jungle online store.
|
|
|
|
Admin Alert: The Pitfalls of Duplicating Data to a Test Library
by Joe Hertvik
i5, iSeries, and AS/400 administrators frequently need to set up test libraries containing files that were duplicated from a live environment. While creating test environment data is not difficult, there are some pitfalls and shortcuts to the process that you should be aware of. This week, I will look at the method behind duplicating files and how you can easily maneuver files from one library to another. READ MORE >
|
|
Reader Feedback and Insights
We value your feedback and insights. Feel free to send a letter to the editor. Letters may be printed, unless otherwise specified, and edited for clarity or length. READ MORE >
|
Senior Technical Editor: Ted Holt
Technical Editors: Howard Arner, Joe Hertvik, Shannon O'Donnell, Kevin Vandever
Contributing Technical Editors: Joel Cochran, Wayne O. Evans, Raymond Everhart,
Bruce Guetzkow, Brian Kelly, Marc Logemann, David Morris
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
|
October 21, 2006: Volume 8, Number 40
October 14, 2006: Volume 8, Number 39
October 7, 2006: Volume 8, Number 38
September 30, 2006: Volume 8, Number 37
September 23, 2006: Volume 8, Number 36
September 16, 2006: Volume 8, Number 35
|
|
