SQL RPG vs. Read/Chain RPG

[iSeriesCodePoet]

I don't mean to start a holy war, but lately I have REALLY liked programing in SQL verses the reads and chains of RPG lately. I don't do strickly SQL, but the main processing is SQL. Why? I can join and sort all of my data first before I start processing.

One of my programs I am joining 5 files together before processing, then it is simply fetch and print. With optimizing the statement per my faq317-3546 I get really fast speeds from this. Yes, you can't do SQL in free format, but I still like it.

I was thinking though. Does anyone here know the SQL API's? If we could code subprocedures around those API's people should then be able to use SQL functions in free format. Any thoughts or suggestions?

iSeriesCodePoet
iSeries Programmer/Lawson Software Administrator

http://www.koldark.net

See my progress to converting to linux.

http://linux.koldark.net

 

[ladeecroft]

after compiling your rpg program with embedded sql, try checking the spooled file for the compilation. instead of seeing your sql statements, you could see there the API's used by your SQL statements togeteher with its corresponding parameters. I've tried using these routines in my pgm instead of the SQL statements, and it worked.

 

[iSeriesCodePoet]

Cool... I never thought of that. I will try it. I would like to make it generic enough that I can include it into the iseries toolkit on sourchforge.

iSeriesCodePoet
iSeries Programmer/Lawson Software Administrator

http://www.koldark.net

See my progress to converting to linux.

http://linux.koldark.net