September 2, 2011 | Volume 8 Issue 35

ISSUE HIGHLIGHTS

TOP STORY: Cool Things: SQL Functions and List APIs
FEATURED ARTICLE:  SpoolFlex Moves DRV Ahead in Race Between Spool File Distribution Providers
NEWS HIGHLIGHT: GoAnywhere Services 2.5 Adds AS2 Module with Unlimited Trading Partners
FORUM: CPYTOIMPF at V6R1
TRIAL SOFTWARE: Report Distribution: Free Trial Software – No Obligation
Manage Subscription | Contact Us

Sponsor - 2011 IBM Power Systems Technical University
 

Attend 2011 IBM Power Systems Technical University.

Performance redefined. Refresh your skills and take a deep dive into the latest product updates.

Enroll today!


Read More >>

Feature Article - Programming
 
Cool Things: SQL Functions and List APIs

Two functionalities that work perfectly together.

mike_faustWritten by Mike Faust

One of my favorite programming techniques is linking together functionality to make even-more-powerful functionality. An example of this is wrapping an SQL user-defined table function (UDTF) around a System i list API to retrieve a given list through an SQL interface. As an example, let's explore a service program that can be used for exactly that purpose.


Read More >>

Sponsor - The MC Press Bookstore
 
NEW BOOK: Subfiles in Free-Format RPG. The ability to master subfiles can define a programmer’s career. Over a decade in the making, author Kevin Vandever has completely reworked and updated his best-selling subfiles classic to make use of the latest free-format programming style. It is the ultimate guide to subfiles and one that every programmer working with IBM Power Systems will find indispensible. Click now for a FREE chapter and to learn more. >>
Read More >>

Feature Article - Application Software
 
SpoolFlex Moves DRV Ahead in Race Between Spool File Distribution Providers

SpoolFlex's ability to convert spool files into native Excel spreadsheet format with predictable results impresses even the most seasoned IT pros.

chris_smithWritten by Chris Smith

SpoolFlex from DRV Technologies is a tool for converting and distributing reports, or spool files, that makes children's play out of formatting report data into Excel. Unlike outputting to a comma-delimited file, when a report is converted directly into Excel's XLS format, report headers are in the right place, lines break where they are supposed to, and output retains the crisp formatting that was always intended.


Read More >>

Sponsor - The MC Press Bookstore
 
The Remote System Explorer (RSE) is the most widely used tool within Rational Developer for System i and WebSphere Development Studio Client (WDSC). Focused exclusively on the RSE within Rational Developer for System i and WDSC, this book covers topics such as getting started, installation, understanding the Workbench, managing your i5/OS objects and members, editing, compiling, debugging, and much, much more. Click now to receive a FREE chapter of this best-selling developer resource! >>
Read More >>

In the News

Read More >>
Support MC Press - Visit Our Sponsors

 

Forums Sponsor

POPULAR FORUMS
  1. Rpg sql insert into qtemp table (2021 views)
  2. What is better, free code or traditional code ? (1751 views)
  3. cant ping workstation from system i (1420 views)
  4. was 7 nd server not starting (1251 views)
  5. SQL Error 802 Type 6 - Numeric Handling for Joins? (572 views)
  6. ODF Release April 28, 2012 (496 views)

Forums

 

 

Search Sponsor

 

Search


Read More >>
   MC-STORE.COM