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

April 20, 2012 | Volume 9 Issue 16


TOP STORY: Cool Things: Read dBASE Files Easily!
FEATURED ARTICLE: QuickLook: RJS Software's RPG2SQL Integrator V1.53
NEWS HIGHLIGHT: Software Up, Hardware Down as IBM Reports First Quarter 2012 Earnings
ON-DEMAND WEBCAST: Beyond FTP, Securing and Automating File Transfers
EVENT: LANSA 2012 International User Conference
Manage Subscription | Contact Us

Sponsor - T.L. Ashford & Associates
Barcode400 Labeling Software makes it easy for IBM i users to design and print labels in minutes.

T.L. Ashford has over 28 years of experience in software development and backs that commitment with a highly qualified technical support team.

You can count on T.L. Ashford for your bar code, compliance and RFID labeling needs. Call 800-541-4893 to see what Barcode400 Software can do for you or use the Live Chat feature at


Feature Article - TechTip
Cool Things: Read dBASE Files Easily!

This simple service program makes dBASE file access simple.

mike_faustWritten by Mike Faust

dBASE has been around since the late 1970s/early 1980s. It was the first widely used relational database for PCs. I recently had a need to import data into the System i from the U.S. Census Bureau's Tiger database, which stores address data for all of the United States, including state, county, and city. The Tiger database is made up of multiple dBASE format files, so I needed to create a means by which I could read the data directly from the System i. In this tip, we'll take a look at a simple service program that gives you the ability to do sequential data reads from a dBASE file.


Sponsor - The MC Press Bookstore
Upgrade Your RPG Skills Today! Traditional fixed-format style RPG IV programmers everywhere are embracing the increased productivity, better readability, and easier program maintenance that comes with the free-format style of programming in RPG IV. Jim Martin’s Free-Format RPG IV will provide you with concise and thorough information on this powerful new way of coding RPG IV. Now available in print and eBook formats. >>

Feature Article - Application Software
QuickLook: RJS Software's RPG2SQL Integrator V1.53

Read and write to SQL databases and Microsoft Excel spreadsheets from RPG.

Written by RJS Software

RPG2SQL Integrator closes the gap between applications running on different platforms by allowing all your databases and spreadsheets to talk to each other in real time. Forget about complicated file transfers, database replications, and manual re-keying. The software allows your IBM i RPG, CL, and COBOL programs to read, write to, and update databases such as Microsoft SQL Server, Oracle, MySQL, and more. The software also allows users to read, write, and modify simple or complex Microsoft Excel spreadsheets by automating Microsoft Excel directly from RPG.


Sponsor - The MC Press Bookstore
Over 45 eBook Titles to Choose From! Instantly download eBooks on RPG, PHP, SQL, and a wide variety of other IBM Power Systems and information technology topics. Our eBooks are fully searchable, printable, and can be resized for easy readability. And, you can cut-and-paste code directly from the book into your applications. Plus, PDF editions are discounted an ADDITIONAL 15% off of the lowest hard copy price! Click now to see them all. >>

In the News

Support MC Press - Visit Our Sponsors


Forums Sponsor





Search Sponsor