![reading sql table in rpg](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT4L03pi1i_Mb2FfZx06UhHPUmLXadO0Hox5uzQMrwlZT47L4lMiWtDcjnKCchZMJXIplPVO477bdGW7PEsswv8yhU-lPlMuNc9oB9ieOVCMEQUrTLQOeSCbRZenrYJDd-GNEGHKyWh4ty/s200/rpg.png)
This idea for this post comes from a Comment posted on Creating a SQL table on the fly. Anonymous posed the question "Now how do you use that table in your RPG program?".
The post I describe how it is possible to use the SQL CREATE TABLE to build a SQL table extracting data from another file. I have mainly used this in processes that extract data and then send the extracted data to the requester via email. But there is no reason why I cannot read the table created in a RPG program.