MAGAZINES

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.


Read More >>

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!


Read More >>

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.


Read 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

Read More >>

In the News


Read More >>

Support MC Press - Visit Our Sponsors


Popular Forums

POPULAR FORUMS

Forums

 Search Sponsor

 

Popular Searches

POPULAR SEARCHES

Search


Read More >>
   MC-STORE.COM