RE: Arrays

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

I would rewrite the data to an XML document, then use a Web Service to
transmit the data to Microsoft SQL Server on a Wintel box.  I would then
query the data from MSSQL using a Type 4 JDBC driver.  I'd write the
results to a temporary file, then run the program, which would just load
the temporary file and read the data!

Yeah!!!!

I WIN!!!!

Joe

P.S. I'd probably use SQL, but if it was a small dataset and relatively
static, I might consider arrays and QSORT.


> From: rob@xxxxxxxxx
> 
> Ok, I understand what you say about performance tuning.  RPG has those
> issues too, like figuring out record blocking, primary vs SETLL/READ,
etc.
> 
> Some application questions though.
> 1)  If a user said "On this inquiry screen I would like to position my
> cursor on any column and sort by that column (and you have seven
columns)
> would you:
> a - Create 7 logicals and use RPG native I/O
> b - Front end the code with OPNQRYF (but since I don't use that I
forget
> if you have to redefine the key on the f-spec to match the sort order)
> c - Use SQL
> d - Tell the user it can't be done.
> e - Offload the data to another platform and have them manipulate it
> there.
> f - Put it on your to-do list, but always at the bottom priority to
never
> get done.