MC Systems Insight
MC Power Technology Manager
MC RPG Developer
MC Power Developer
MC TNT Tips 'n Techniques
MC AIX Expert
MC Linux Expert
MC Mobile on Power
This Week @ the MC Press Bookstore

September 5, 2008 | Vol 5 Issue 35


In This Issue:

Feature Article - TechTip
TechTip: Exploit DB2 Web Query's Defined and Computed Fields

What do you do when you need to create a field that's a calculated value based on real data?

tyler_even.jpgBy Tyler Even

If you've used the DB2 Web Query for IBM i development tools, you may have noticed the ability to create two types of virtual fields: defined fields and computed fields. Often, when building a report, you need to create a field that is not in the original database but is instead a calculated value based on real data. For example, "gross profit" may not actually exist in your data, but it can be calculated from revenue and cost values. Each virtual field type has its own distinct advantages and purpose in report development. This TechTip uses a real-world example to illustrate when you should use which field type.


Feature Article - Analysis
IBM Releases Lotus Symphony V1.1 as Users Begin Considering the Linux Desktop

Development teams continue to enhance Symphony as IBM bundles it with Lotus Notes and Sametime in a move to edge Microsoft off the desktop.

chris_smith.jpgBy Chris Smith

IBM Lotus released V1.1 of Symphony last week, a release that runs significantly faster than the earlier V1.0 and features mail-merge functions using .nsf files.


Users had been waiting for some time for the ability to do a direct mail merge between a document and their Notes Contacts address book or other Notes database file without going through a time-consuming file conversion. This will further enhance the value of Symphony for Notes users, many of whom still switch back and forth between Notes and Microsoft Office (including this reporter). Others simply forego the Notes Contacts (Personal Name and Address Book in 7.X) altogether in favor of Microsoft Outlook.


Feature Article - Programming
CL for Files (CLF) Solves Age-Old Problem of Poor CL Database Support

Bruce Vining's new PowerCL: CLF product allows IBM i professionals to work directly with database, display, and printer files from CL programs.

chris_smithWritten by Chris Smith

As everyone knows, CL is the control language for the System i and is known by every developer and operator of the platform. IBM has provided a very complete set of commands within CL to work with the many different types of objects on the system. What the company has not provided, and what users and developers have been requesting for many years, is a set of commands that fully support working with database, printer, and display files. All that has now changed.


Support MC Press - Visit Our Sponsors


Forums Sponsor


 Popular Forums




Search Sponsor

 Popular Searches