Using DDL to define your files provides a wealth of new features, but just which features should you embrace? Some of that depends on the tools you use, and this article explains a couple of pitfalls.
Written by Joe Pluta
The ongoing SQL vs. native I/O debate really consists of two different debates: how to define your data and how to access it. Access is either via native I/O or SQL, but that's not the topic today. Today, I'm focused on the data definition debate, either the older Data Definition Specifications (DDS) or the more modern SQL-based Data Definition Language (DDL). I firmly believe this dispute has been decided in favor of DDL, but DDL is not perfect. Some potential pitfalls exist, and this article will address one of the more onerous problems.
SQL CASE expressions are powerful. Understand their syntax and where they can be used.
Written by Sam Lennon
Did you know that the SQL CASE construct can be used in SQL SELECT and UPDATE statements and in WHERE, GROUP BY, and ORDER BY clauses? This tip explains SQL CASE through examples that you can run and experiment with. It also gives an overview of SQL CASE syntax, though it does not attempt to rewrite the IBM DB2 for i SQL Reference manual.
Don’t settle for screen-scraping your way to the web… Give your RPG programs a true Web 2.0 interface!
Complete RPG toolkit for communicating between the IBM i and the front-end
Full-featured web portal for managing IBM i users, menus, applications and security
Complete documentation, training videos and numerous RPG program demos
Just released, Valence Version 3.0 also includes mobile device support, the Valence Nitro integrated source editor and numerous other features.
The MC Webcast, MC White Paper, MC Software, MC Case Study, MC Security, and MC Disaster Recovery Centers bring you the widest selection of white papers, software, webcasts and more for you to choose from and at MC Press we’re all about choice. We’re even giving one lucky person the opportunity to choose their own prize in our “It’s All About Choice” contest for a $250 Best Buy gift card. Visit the MC Resource Centers today and select as many of the FREE offerings you would like to receive. While there, enter the contest and you may just win a $250 Best Buy gift card!
Have Trial Software you would like to list? Click here or call (208) 726-6822 for information.