This simple service program makes dBASE file access simple.

Written 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.

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.