× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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
<



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.