The CL Corner: A More Flexible Interface to the RUNSQL CL Command PDF Print E-mail
Programming - CL
Written by Bruce Vining   
Friday, 27 February 2015 00:00

In this article, we'll building the SQL request dynamically.

bruce viningWritten by Bruce Vining

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.

Add a comment
Last Updated on Thursday, 26 February 2015 10:49
Modernization on the IBM i: Getting Started PDF Print E-mail
Programming - General
Written by Brian May   
Monday, 23 February 2015 00:00

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

brian mayWritten 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.

Add a comment

Last Updated on Friday, 20 February 2015 16:11
User Rating: / 1
What Change Control Is PDF Print E-mail
Programming - Change Management
Written by David Shirey   
Wednesday, 18 February 2015 00:00

Change control: is it a tool or is it an attitude? Maybe it's a little of both.

david shireyWritten by David Shirey

Last month, we talked about some of the myths that seem to surround change management. Now let's take a few moments and talk about what a change control system should be.

Add a comment
Last Updated on Wednesday, 18 February 2015 00:00
The API Corner: Regaining Control in Your Program PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 18 February 2015 00:00

It's easily done using the Register Call Stack Termination User Exit Procedure (CEERTX).

bruce viningWritten by Bruce Vining

Mark B. recently sent me a note asking if there was a way to perform some cleanup functions in his program when someone issues an ENDJOB command while his program is running. The answer, as you might expect, is "yes" and involves an API that actually covers more areas than just the ENDJOB command.

Add a comment
Last Updated on Wednesday, 18 February 2015 00:00
Which Language Do All the Most Popular Websites Use? JavaScript! Find Out Why PDF Print E-mail
Programming - Web Languages
Written by Robert Swanson   
Wednesday, 11 February 2015 00:00

Two decades of evolution make it a great time to supplement your RPG skills with JavaScript, the standard language of the browser. Let's take a trip down memory lane and take a practical look at one of the world's most popular programming languages.

robert swansonWritten by Robert Swanson

JavaScript will hit a big milestone later this year as it turns the ripe old age of 20. Originally introduced as "LiveScript" by a company called Netscape in mid-1995, the JavaScript language has undergone quite a metamorphosisincluding a name changesince those early pioneering days of the Internet. JavaScript is in fact largely responsible for the amazing breadth of functionality many users take for granted in web pages and web-based apps today.

Add a comment
Last Updated on Wednesday, 11 February 2015 10:20
User Rating: / 3
Practical SQL: DB2 at Home, Part 2, First Look PDF Print E-mail
Programming - SQL
Written by Joe Pluta   
Wednesday, 04 February 2015 00:00

Actually, this first look is actually a look into the future!

joe plutaWritten by Joe Pluta

In the previous article, I showed you how to create a fully functional, working DB2 environment on your PC for no cost. It's a little unusual for many of us: DB2 10.1 running on a Linux appliance inside of Oracle VirtualBox! Our familiarity with PCs may not extend much past Windows, but I've created an environment that seems about as foreign to the IBM midrange as it can get. Yet this odd little environment running in a little Linux bubble on my desktop has one really powerful capability: it can show me the future!

Add a comment
Last Updated on Friday, 06 February 2015 08:57
RPG Academy: BIF Up Your Code! Start Moving MOVE and MOVEL out of Your Code PDF Print E-mail
Programming - RPG
Written by Rafael Victoria-Pereira   
Wednesday, 04 February 2015 00:00

The MOVE and MOVEL op codes are workhorses in fixed-format RPG, but they don't exist in free-format. Use the EVAL op code and a few BIFs to remove MOVE and MOVEL!

rafael victoria preiraWritten by Rafael Victória-Pereira

There are many uses for the MOVE and MOVEL operation codes: initializing (or even declaring) variables, moving values from one variable to another (which sometimes implies a conversion between data typescharacter to numeric or vice versa, for example), truncating a numeric value, copying part of a string to a different string variable, and so on. Providing you with the tools to totally remove MOVE from your code is a considerable task, and I'll try to address it in this and the following TechTips, thus paving the way to a migration to free-format (that too will be the subject of a few TechTips later in this series).

Add a comment
Last Updated on Thursday, 05 February 2015 15:08
User Rating: / 2
The CL Corner: Enhancing WRKQRY Reports the Easy Way PDF Print E-mail
Programming - CL
Written by Bruce Vining   
Friday, 30 January 2015 00:00

Let's look more uses of the RUNSQL CL command.

bruce viningWritten by Bruce Vining

I recently received a note asking if there was a way to add the day of week to query reports generated by the IBM Query for i (5770-QU1) product. That is, take a current report containing dates as shown below:

Add a comment
Last Updated on Friday, 30 January 2015 00:00
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 215



See What i Can Do With Modern RPG Development

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! 


Watch the Webinar Now!



MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

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!

Offer good through December 31, 2013.