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.
Updating one file from another in SQL has been messy in the past, but this technique makes it a lot easier.
Written 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.
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!
There's more to string operations than splitting and stitching. Curious? Keep reading.
Written 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.
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!