Re: Arrays

Your application performance would suffer greatly due to

1)  MS SQL versus DB2
2)  Having the data on two database platforms
3)  Having to transmit the data from one system to another
4)  Modification NIGHTMARES!  You are running on two platforms, 3-4 languages

You lose ;-)


On Tue, 29 Mar 2005 14:47:12 -0600, Joe Pluta
<joepluta@xxxxxxxxxxxxxxxxx> wrote:
> 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.
> 
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
> 


-- 
"Enter any 11-digit prime number to continue..."