MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

August 5, 2009 | Vol 8 Issue 15


In This Issue:

Sponsor - T.L. Ashford & Associates

T.L. Ashford is “The Labeling Answer”® for the System i.

Ashford's Barcode400 has been the dependable choice for the industry since 1983. With Barcode400's newly enhanced Graphic Designer no “green screen” interaction is needed for label design. New features include: AFP/HP-compatible printing, easy-to-use graphics import tool, test print to desktop printer, simple font download tool, updated drivers and format listing reports. Even compliance labeling is made easy with design templates. Call 800-541-4893 to order your Fully-Functional, FREE Trial Software or visit us at T.L. Ashford & Associates.


Feature Article - Programming
Practical SQL: Dynamic Selection Criteria

It's one thing to create a great SQL query; it's another thing entirely to let your users do it dynamically.

joe_plutaWritten by Joe Pluta

SQL is not a difficult syntax; it was designed to be relatively easy to use even for non-programmers, and it lives up to that goal. Selecting and sorting data is pretty straightforward: the WHERE clause and the ORDER BY do the heavy lifting. The harder part comes when the user wants to select a specific part number or a date range or a list of states or a combination of those or none at all. In this article, I'll show you the brute force method and then something a little more elegant and better-performing to boot!


Feature Article - Programming
Optimize Your SQL Statements with Visual Explain

Learn how to use this GUI tool to improve your SQL statements.

kevin_forsytheWritten by Kevin Forsythe

Writing SQL statements that function correctly and deliver the desired results is only half the battle. We also need to manage the performance of those SQL statements. This might involve things such as how we write the statements, what indexes are in use, and what SQL engine is processing the statement. The Visual Explain tool within System i Navigator helps us manage all that and more.


Most Popular MC Press Books

Top 10 Best-Selling Titles for July 2009

  1. Functions in Free-Format RPG IV
  2. The Programmer's Guide to iSeries Navaigator
  3. The IBM i Programmer's Guide to PHP
  4. Free-Format RPG IV
  5. SQL for eServer i5 and iSeries
  6. The Modern RPG IV Language,Fourth Edition
  7. Complete CL, Fifth Edition
  8. The Remote System Explorer
  9. IBM System i APIs at Work, Second Edition
  10. SQL Built-In Functions and Stored Procedures


In the News


Support MC Press - Visit Our Sponsors

Popular Forums



 Search Sponsor


Popular Searches