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

June 16, 2010 | Volume 9 Issue 12


TOP STORY: Create, Format, and Export SQL Dates and Times Using DB2
FEATURED ARTICLE: The API Corner: Running CL Commands from RPG
NEWS HIGHLIGHT: LANSA Composer V3 Transforms Data Entry into Data Automation
FORUM: Open-Source EGL
ON-DEMAND WEBCAST: Coffee with Carol - Configuring IBM i (iSeries) Access servers to use SSL
Manage Subscription | Contact Us

Sponsor - T.L. Ashford & Associates
T.L. Ashford is “The Labeling Answer”® for the System i.

Ashford's Barcode400 has been the dependable choice for the industry since 1983. With Barcode400's newly enhanced Graphic Designer no “green screen” interaction is needed for label design. New features include: AFP/HP-compatible printing, easy-to-use graphics import tool, test print to desktop printer, simple font download tool, updated drivers and format listing reports. Even compliance labeling is made easy with design templates. Call 800-541-4893 to order your Fully-Functional, FREE Trial Software or visit us at T.L. Ashford & Associates.

Also, be sure to download the new white paper: Bar Code / RFID Label Printing, Don't get caught in the integration trap.


Feature Article - Programming
Create, Format, and Export SQL Dates and Times Using DB2

After reading this article, you'll never worry about date formats again.

tom_snyderWritten by Tom Snyder

My recent articles on exporting data have generated a number of questions on formatting dates with SQL. So let's explore SQL dates by looking at how to create date fields in physical files, insert dates into physical files, and export the dates in different formats.


Feature Article - Programming
The API Corner: Running CL Commands from RPG

Use the QCMDEXC, system, and QCAPCMD APIs to run CL commands from within your RPG application.

bruce_viningWritten by Bruce Vining

In last month's column, "Do I Really Need to Call a CL Program to Perform This Function?," the QCMDEXC, system, and QCAPCMD APIs were introduced. All three of these APIs are available to enable the running of CL commands from an application program. Today, we'll look at what is required to implement these APIs within your application program as well as some of the considerations that exist with each of the APIs.


In the News

Support MC Press - Visit Our Sponsors


Forums Sponsor





Search Sponsor