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

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.


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.


In the News

Support MC Press - Visit Our Sponsors


Forums Sponsor





Search Sponsor