10/27/2011
I hope you didn't misinterpret the title of this article. It's not about something you can use instead of using a trigger but about a type of trigger. Instead Of triggers provide a mechanism of having trigger code run instead of (as opposed to before or after) an event (e.g., insert, update, delete). And that's what this article is all about—how to define and use Instead Of triggers.
But first of all, you have to understand a problem in which you can use an Instead Of trigger to provide an
10/27/2011
Jon Paris and Paul Tuohy have just returned from two conferences in Europe. In this podcast, they give you their impressions of the state of IBM i development in Europe.
08/01/2011
Most developers find satisfaction with a new-to-them tool at the point they can mimic the same tasks they accomplished with their old development software. But that doesn't do anything for their productivity. Remote System Explorer offers so much more: from simple techniques in the editor to additional views you can use. Paul Tuohy presents tricks and tips that will help you explore RSE features and turn you into a more productive developer.
03/24/2011
PHP has been very hot in our community over the past few years. A lot of great open-source tools are available for the PHP environment. In this podcast, Jon Paris and Paul Tuohy have a chat about PHP, MySQL, and some of the open-source tools.
Here are links to some of the tools discussed in the podcast:
Project Pier
PMWiki
Adminer
Listen to the podcast.
01/01/2011
Database externalization offers some potent benefits, including ease of maintenance and performance gains. This article offers a production-level example of externalizing a database and introduces a downloadable code generator that does much of the externalization work for you.
12/01/2010
Proper documentation is—nowadays—a too often overlooked programming requirement in RPG. Don't overlook it any longer. Paul Tuohy's RPGLEDOC command scans code comments and automatically generates documentation web pages for presentation in a database.
11/01/2010
One of the biggest challenges facing any experienced programmer when he or she examines RPG is coming to grips with the way the language is so tightly integrated with the database. In this second and final part of a series, learn about RPG database operation codes, record locking, file errors, and level checks.
08/26/2010
In this RPG & DB2 Summit podcast, IBM software development experts Jon Paris and Paul Tuohy chat about what's new in web development on IBM i. This is a sequel to the August 12 podcast, but it's still worth listening to, even if you haven't heard the first one.
Listen to the podcast.
08/12/2010
In this RPG & DB2 Summit podcast, Jon Paris and Paul Tuohy shoot the breeze about what's new in the world of web programming on IBM i.
Here are some of the points that Jon and Paul discuss:
Rational Open Access for RPG
More folks coding for the web than ever before
Jon and Paul's Plan for World Domination
SitePoint.com
Changes to Zend's PHP
Click here to listen.
07/01/2010
One of the biggest challenges facing any experienced programmer when he or she examines RPG is coming to grips with the way the language is so tightly integrated with the database. In this first part of a two-part series, learn about RPG database terminology, how RPG handles "files," and the record-level access model.
03/25/2010
About a year ago, I published a podcast that featured a debate between Jon Paris and Paul Tuohy regarding PHP and CGIDEV2. Since that time, Paul (the CGIDEV2 guy) has added PHP to his repetoire.
In this podcast, Jon and Paul revisit the topic, and Paul tells us what he has learned about PHP on i.
02/11/2010
After you get started with ILE, you quickly discover that you have hundreds or thousands of subprocedures that have been written. How do you document them so that other developers can find and use what has already been written?
This is another excellent podcast from the team at the RPG & DB2 Summit conference. This time around, Jon Paris interviews Paul Tuohy about writing documentation in an ILE environment.
This podcast discusses a free tool from Paul Tuohy. The tool, called RPGLEDOC,
01/28/2010
Last year, I published several special RPG & DB2 Summit podcasts in which experts from the RPG & DB2 Summit conference discussed some of the hot issues that today's IBM i programmers face. Because these podcasts were very popular, we've decided to do it again!
This podcast features Paul Tuohy interviewing Susan Gantner about using MySQL on i. Since we have our familiar integrated DB2 database, why would we ever want to use MySQL on i? To the IBM i faithful, is MySQL a blessing, or is it
03/12/2009
Almost every RPG programmer who learns SQL asks the same question: Do I keep using RPG's native I/O operations, such as READ, CHAIN, and WRITE? Or should I replace them all with SQL? Which method will be the standard in the future? Which method performs the best?
In this RPG & DB2 Summit podcast, Paul Tuohy interviews Susan Gantner about these very topics. Although there's no definitive answer to these questions, Susan gives you her opinion--and gives you food for thought.
In the podcast,
02/26/2009
As you may know, I take part in many IBM i conferences each year. At these conferences, I try to discover the topics that developers are interested in and talking about. RPG & DB2 Summit is one of the conferences that I never like to miss. I've asked the folks that organize the conference to put together a series of podcasts to discuss these hot topics and provide food for thought for IBM i developers.
Personally, I like podcasts for stuff like this, because I can download them and listen
10/01/2008
By developing and maintaining service programs properly, you can ensure that procedures are readily available for programs within the ILE.
09/01/2008
When modernizing applications, update your databases, too. By redefining DDS databases as DDL, you'll improve application databases' performance, integrity, and functionality and establish your System i applications on a standard database platform.
08/01/2008
With a tiered design, client programs do not require knowledge of the database’s location or format. You can alter the core service program used to maintain the database without affecting any of the clients that use subprocedures in the service program.
04/01/2008
Using CGIDEV2 subprocedures, you can easily use RPG to program a web-ready order entry application that is more modern and visually appealing than its green-screen counterparts.
10/01/2007
In a previous article, you learned how to change design patterns for ILE RPG programs. Now, it's time to put that knowledge to the test. Will the design hold up?