Re: New application using remote databases from RPG program

Thanks, Rob. I don't know why I didn't think of this. I was making it too
complicated.

My boss is /not/ opposed to traditional file I/O - she's rather
old-fashioned like me, and we definitely don't want to SPENDMONEY(*LOTS) on
more IBM software.

I believe that this is the route we will be taking:
Use embedded SQL to build a cursor over the remote file, then loop through
the cursor to fetch and use "legacy" WRITE's to load the data into the local
file where the data will be aggregated.

This will not be nearly as complex as I thought...

- sjl


Rob wrote:
Is your boss opposed to using "traditional" I/O from within your programs?
And mixing traditional i/o for local with sql for remote. If you were
plan on using DDM you were planning on some traditional I/O anyway. If
you can mix then one alternative is to (in RPGLE):
...
dow fetchRoutine(); // sql fetch from remote system
write localfile;
enddo;