The Ultimate Resource for IBM i For Power Systems including AS/400, iSeries, and System i

The first part of this article series showed how DSPOBJD can easily provide statistics to manage a general recompilation project. But it only touched the surface of all the things you get with the DSPxxx commands.

jean-paul_lamontre Written by Jean-Paul Lamontre

Let's start with a review of the information we gathered in Part I by just using DSPOBJD.

Objects by Type and Year

This data is concerned with counting objects by type and by year of source update (for those that have a source, of course).

If we had used ODCCEN plus ODCDAT (i.e., the object creation date) instead of ODSRCC plus ODSRCD, we'd have gotten a report on recompilation instead of a report on source update.

By bringing practical tools and advanced techniques to how you test, the costs and risks associated with testing can be reduced dramatically.

Written by Databorough Services

The following article is an extract from the white paper "A Visual Guide to Cost-Effective Testing on the iSeries," available for download free from the MC White Paper Center.

Managers and developers working with legacy RPG and COBOL applications face serious testing challenges. Few, if any, of these applications have a complete set of specifications of how the applications should perform, and even fewer have a complete library of test cases. Results from over 12,000 software projects show that detecting and removing defects is the single most costly task in software development.

Not a good idea!

tom_huntington Written by Tom Huntington

Several months ago, I was visiting customers and reviewing their computer operations. A question that comes up more than I can believe is, "What do we do with all of the reports that are sitting on output queues?" This question always amazes me. There are companies with reports that have been sitting on output queues for five years or more!

One of the hard parts of any server-based architecture is knowing when your server has been canceled; this article shows you how to address that.

joe_pluta Written by Joe Pluta

I saw an email message in the midrange.com mailing lists the other day about the old standby for termination, the scope message. Scope messages are cool; using the QMHSNDSM API, you can identify a program to call when the job or call stack entry ends, and I'll address that another time. But I really like the CEERTX API. CEERTX is the ILE version of the concept and allows you to identify a procedure to be called if your call stack entry is terminated.

Prompted SQL DDL Creation

Not familiar with SQL CREATE TABLE syntax? No problem! There's a really easy way to create SQL DDL (Data Definition Language) statements.

sam_lennon Written by Sam Lennon

IBM i developers are becoming more comfortable exploiting the power of SQL to retrieve and manipulate data. We regularly use the workhorse SELECT, UPDATE, and DELETE statements and can bang them out quickly with minimal syntax errors. Defining tables, indexes, constraints, and the like occurs less frequently, and consequently we are much less accomplished in the syntax.

INDUSTRY NEWS >>

Safestone Technologies Announces Compliance Center for Linux

Announcement marks a major step in company's strategy to automate log and compliance reporting for IBM Power Systems and other virtualized environments.
Read more >>

ASNA Announces First Two Cities in Spring Wings Education Tour

Users will get hands-on Wings training using PCs and an actual RPG application.
Read more >>

Coglin Mill RODIN Now Available Worldwide with IBM i Solution Edition

The new IBM i Solution Edition is designed to make it easier and less expensive for customers to acquire and deploy the data warehouse management software on Power System i.
Read more >>

QMessage Monitor Now Offers Option-Level Security

New features in V7 can both limit and audit internal user access.