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

July 1, 2015 | Volume 14 Issue 13


TOP STORY: Practical SQL: Partitions and MERGEs
FEATURED ARTICLE: RPG Academy: BIF Up Your Code! More Excel-like Functions with %XLATE
NEWS HIGHLIGHT:  OpenLegacy Announces New eSuite Integration Platform and Secured Web Gateway
MC PRESS BOOKSTORE: Top Selling Titles
EVENT: A Successful Approach to Automated Monitoring in a Complex World

Sponsor - The MC Press Bookstore

Don't miss out! This is the hands-on guide to IBM's strategic language for IBM i. Database Design and SQL for DB2 delivers everything you need to know about database design and SQL. Author Jim Cooper gives you all the tips and techniques you need in one convenient place, whether you’re a beginner or an advanced developer. Includes real-life examples to help you hone your skills. The bonus companion website explains embedded SQL and explores client-side technologies.


Feature Article - Programming
Practical SQL: Partitions and MERGEs

Updating one file from another in SQL has been messy in the past, but this technique makes it a lot easier.

joe plutaWritten by Joe Pluta

One of the big advantages of SQL is the fact that you can add columns to a table without worrying about the underlying access; columns that aren't used are simply ignored in the SQL client programs. However, once you have added that column, the next trick is to populate the column correctly.


Sponsor - The MC Press Bookstore

An old dog can learn new tricks! Flexible Input, Dazzling Output with IBM i is full of clever ways to get data into your IBM i system, as well as new techniques to export and present this data in a modern, business-friendly manner. No more boring spreadsheets or ugly printouts! Your DB2 data will look great in program-generated spreadsheets and browser-based, interactive charts. Whether you’re an old dog or not, you’ll get the most out of your ILE RPG programs with the open source, free tools in this smart new release! Order your copy today!


Feature Article - Programming
RPG Academy: BIF Up Your Code! More Excel-like Functions with %XLATE

There's more to string operations than splitting and stitching. Curious? Keep reading.

rafael victoria preiraWritten by Rafael Victória-Pereira

Something as trivial as changing the case (from lowercase to UPPERCASE, for instance) of a string can be a challenge in RPG, because unlike SQL (and MS Excel), RPG doesn't have a change case function. So let's build one, using yet another BIF: %XLATE.


Sponsor - The MC Press Bookstore

Have you heard? RPG is now fully free-format! This latest edition from RPG expert Jim Martin is your one-stop resource for free-format information. It’s a must-read for all RPG programmers, featuring completely updated code. See the new H, F, D and P specs in action in this easy-to-use reference guide. You’ll learn rules and syntax but also grasp how this modern style of coding can improve your overall productivity--from initial development through maintenance. Get your copy today!


Most Popular MC Press Titles

Best-Selling MC Press Titles

  1. Free-Format RPG IV
  2. DB2 10.1 Fundamentals (Exam 610)
  3. Identity Management
  4. The Chief Data Officer Handbook for Data Governance
  5. Programming in RPG IV
  6. Mastering IBM i
  7. The Modern RPG IV Language
  8. Advanced Java EE Development for Rational Application Developer 7.5
  9. DB2 11: The Ultimate Database for Cloud, Analytics and Mobile
  10. RPG TnT


In the News

Vendors:  Have a press release to share?  Send it to MC Press.

The Latest from IBM

Support MC Press - Visit Our Sponsors

Forums Sponsor



Search Sponsor