In the January 2015 CL Corner, Enhancing WRKQRY Reports the Easy Way, we saw how to create an SQL view for use by WRKQRY using the Run SQL (RUNSQL) CL command. I received quite a few notes asking, among other things, for an example of how to build the RUNSQL SQL parameter using variables rather than the static approach taken in the previous article. So today we'll look at what's required to build the SQL parameter using variables/parameters. For demonstration purposes, we'll continue to use the PROJECTS file that was introduced in the previous article.

Soon after a new version of software is made available to existing customers, it doesn't take long for discussions to arise between the technical and business leadership within a company on when to upgrade. The development teams drool over the productivity and performance benefits offered by the new version while the IT executives fixate on the costs and risks associated with upgrading to the latest software version.

The only true mistake you can make with regard to application modernization is doing nothing.

Written by Brian May

Modernization. Everyone is talking about it. Everyone wants it. But we cannot always agree on exactly what it is. It can mean a few different things, depending on your needs and environment. This of course leads to confusion for those who need it most.

In every industry, business-critical processes depend on application performance. Interruption of real-time processing, customer service delays, and missed SLAs and deadlines are all plausible outcomes with all-too-real consequences. Fortunately, IBM i and third-party vendors offer significant power to prevent such disaster.

SQL on IBM i includes expressions and functions for working with date and time values. Externally, date values are character strings containing numbers for the year, month, and day and (in some formats) date separators. When a literal date is entered, the value is coded as a string. The format of the string depends on the values specified for the DATFMT and DATSEP parameters. For example, if *ISO format is specified, the following string represents May 1, 2011:

MC PRESS STORE >>

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:

Working with free-format RPG in IBM i TR7

Breaking free from “The Cycle” of traditional RPG development

Going beyond the 10 character limit in display and database files

And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes!

This whitepaper explains many of the compelling reasons for automating your accounts payable processes, the components of an end-to-end A/P automation solution, and common challenges organizations face.

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!