Re: How to mimic a subfile with java? - an easy option...

 We use OPTIMIZE FOR in sql. In my application I display, say, 5 records at
a time so I use OPTIMIZE FOR 5 ROWS. I had a file with 1,500,000 records.
The response time is the same as that of a tiny file.  Now we have to
implement Previous and Next buttons. The following link shows this type of
coding implemented with servlet.
 http://www.crazybikes.com/servlet/MRCSRVDEMO.I00220s

Bruce

----- Original Message -----
From: "Jim Mason" <JEMason@compuserve.com>
To: <java400-l@midrange.com>
Sent: Wednesday, October 03, 2001 4:34 AM
Subject: How to mimic a subfile with java? - an easy option...


> Hi Robert.
>
> If you are using either WebSphere Studio or VisualAge for Java, IBM
> includes a Select data access bean that provides all the capability of a
> subfile and you can build it visually without writing any Java code !
>
> You just add the Select bean to a desktop in VisualAge and connect it to a
> JTable for a client / server app visually with a connection!
>
> For a web app, use WebSphere Studio.  There is more work here for sure in
> the current version (3.5.3).  Create an sql statement with the sql wizard.
> Create a database jsp with the database wizard.  Here you can specify a
> page size just like subfiles have for scrolling with forward and back
> buttons.  It generates a jsp that you can easily modify or extend in Page
> Designer for a custom look and feel etc....
>
> Jim Mason
>
> Jim Mason
>
> Message text written by INTERNET:java400-l@midrange.com
> >
> I am attempting to write a java application that would display a customer
> list loaded from a db2 file.  When the uses selects a customer it will
then
> bring them to a customer detail screen.
>
> My question is, what is the best way to load this list.  The method I used
> was just a dow not eof loop that appended items to a JList.  This worked
> fine for my testing, with minimum records, but when you start to get into
> thousands and even hundreds of thousands of records it takes quite a long
> time to load.
>
> I don't expect to be able to get subfile load speeds(can I?) but there
must
> be methods to allow the speeding up of this process.  Has anybody ever
done
> anything like this?
>
> Any help would be greatly appreciated
>
> Robert Upshall
> Professional Software of Amarillo
> (806) 358-8928
> rupshall@psasoft.com
> <
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>