July 5, 2017
July 5, 2017 | Volume 16 Issue 12
• LEAD ARTICLE: Practical SQL: Complex Filters Using Common Table Expressions
• FEATURED ARTICLE: RPG Academy: Debug Done Right - Starting a Debug Session
• FEATURED ARTICLE: Book Review: Programming in ILE RPG, Fifth Edition
• NEWS HIGHLIGHT: IBM and HelpSystems Collaborate to Enhance IBM i Offerings
• ON-DEMAND WEBCAST: IBM i Resources Retiring?
• FEATURED VIDEO: Design an Invoice in 10 Minutes
• EVENT: How to Solve the Cybersecurity Skills Gap
Practical SQL: Complex Filters Using Common Table Expressions
SQL allows you to do many things, but encapsulating logic isn't one of them…unless you understand the magic of Common Table Expressions (CTEs).
By Joe Pluta
Recently, I've been doing a lot of data analysis. A lot of data analysis. I'm reviewing legacy data on a system that's been in production for over 20 years, and I’m trying to do forensic analysis on it. One of my projects is implementing some enhanced logic, but before it can be put into service, the stakeholders have to approve the changes, and the only way that happens is if I can provide detailed before and after numbers for the auditors. That means finding a way to apply ad hoc complex filters quickly and effectively in order to separate high- and low-impact effects.
Barcode400 Labeling Software for the IBM i
All Data and Software Resides on the IBM i: Everything is centralized and secure.
Graphical Designer: Design labels in minutes.
Integrate and Print with Existing Apps: Call from RPG, COBOL, CLP and JAVA programs.
Compliance Labels Provided: Extensive library of predesigned label templates.
Supply Chain Solution: Easily integrated into any IBM i ERP or WMS solution.
Learn about new Features here, or watch a quick video on 4.0 features here. Download a 30-day trial here!
TL Ashford - Since 1983
The MC Press Bookstore has massively reduced the cost of all its books for the month of July.
No matter your interest, no matter your budget, no matter your skill level, there is something for you in the BIG Summer Sale.
Check out these low prices!
- 54 books at just $5
- 19 books at $10
- 10 books at $15
- 9 books at $25
- 8 books at $35
Inventory will move fast, so browse the store and fulfill your summer reading list today!
Introducing the complete guide to building business Web applications! Now programmers of all levels can learn to build Web apps that do real business work. Written by business developers for business developers, Developing Business Applications for the Web bridges the gap between website and business application programming. You'll master the fundamentals of Web development tools and gain all the necessary skills to build Web browser front-end applications that let users interact with business data.
RPG Academy: Debug Done Right - Starting a Debug Session
Now that you know the debug views at your disposal and learned how to encrypt your debug views, it’s time to start a good and proper debug session with the ILE Debugger.
By Rafael Victória-Pereira
Once you create your objects with the appropriate debug view, you’re ready to debug them. You probably guessed that the process is initiated with strdbg. Let’s start with a debug session of a simple program built to test some of the date-handling functions from the “BIF Up Your Code” subseries, named TST_DTEOPS, which you can download here.
It’s not just software that gets upgraded and enhanced!
Welcome to the first edition of MC Press Magazine. As you can see, we’ve been busy making changes to ensure that your reading experience is convenient, productive, and pleasurable.
Find Out Why You Should Keep Data on IBM i
It’s simple. IBM i is the most reliable, securable, and powerful platform to house your critical business data.
IBM i was built for business and has added features and functionality over the years to keep up with modern business needs. You can trust it to run your business, access your data in real-time, and keep your data secure. Plus, IBM i can scale to your business and handle all of your critical data.
Can your other platforms do that?
We didn’t think so.
Watch this 30-minute webinar to learn why you should keep your data on IBM i, including:
- IBM i is reliable
- IBM i offers fast and secure real-time data access
- IBM i helps your business prepare for tomorrow
Plus, we demonstrate how Sequel Data Access helps you modernize IBM i data access and meet your business needs.
Book Review: Programming in ILE RPG, Fifth Edition
This book really hits the mark and is a must-read for all RPG developers.
Written by Bruce Guetzkow
The fifth edition of Programming in ILE RPG by Bryan Meyers and Jim Buck provides an excellent progression of subject matter for the next generation of RPG developers. There is a strong emphasis on free-format coding with plenty of references to fixed-format code. This perspective on RPG will make it easy for students to learn RPG and aid experienced developers in making a transition to more modern coding techniques.
LATEST COMMENTS
MC Press Online