In this final article, we will compare and contrast the scripting solutions available with CGIDEV2, PHP, and Java. Here are a few questions to keep in mind when considering which scripting language to use:

• How well does it integrate with HTML/CSS/Javascript?
• How well does it integrate with database?
• How well does it integrate with host language calls?
• How easy is it to learn?
• What educational resources are available?
• Is it well supported?
• What frameworks are available? (Frameworks allow for very rapid development of interfaces.)
• Is scalability an issue? (How many people will be using your application.)

CGIDEV2

CGIDEV2 is a

One of the tedious chores that many developers face is keeping many different data sources synchronized. It is common for mid- to large-sized companies to have multiple software packages with requirements to keep synchronized copies of the item master, customer master, employee master, and other master files.

Other common synchronization tasks involve keeping aggregate tables of detailed data or even synchronizing DB2 data with a relational or non-relational remote data source, including remote databases, Web services, flat files, etc. Fortunately, to help with all of this, IBM has updated DB2 for i 7.1 to include support for the SQL MERGE

We found a number of user profiles on our i/OS box that have password expiration intervals of *NOMAX, meaning that their passwords will never expire. We’re changing their expiration interval to *SYSVAL, so that each user profile takes its password expiration interval from the global system value. How long after I make this change will the users be required to change their passwords? I’m on i/OS V5R4M5.

–Joe

Before I get to the solution, it’s worth reviewing how the password expiration interval is calculated for an IBM iSeries, System i, or Power i user on an i/OS V5R4Mx partition.