RE: Even more embedded SQL.... -- RPG400-L


Thanks Tom
Everything that's been mentioned in this thread, I have filed away so that
I can do some analysis and (hopefully) arrive at the "best" answer.
And Yes - updating is a part of this project, and I know if a work
file/are/queue/whatever I realize that a double update (real data + work
data) will be needed.



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx


                                                                       
             qsrvbas@netscape.                                         
             net                                                       
             Sent by:                                                   To
             rpg400-l-bounces@         rpg400-l@xxxxxxxxxxxx           
             midrange.com                                               cc
                                                                       
                                                                   Subject
             08/03/2006 04:03          RE: Even more embedded SQL....  
             PM                                                        
                                                                       
                                                                       
             Please respond to                                         
              RPG programming                                          
              on the AS400 /                                           
                  iSeries                                              
             <rpg400-l@midrang                                         
                  e.com>                                               
                                                                       
                                                                       




Alan:

I'm not clear on the full requirements. Although you've stated a 15,000 row
size, it isn't clear whether these rows represent the total size of the
table(s) or that there are 15,000 rows expected _after_ a WHERE clause is
applied.

Charles Wilt mentioned a separation, and I think that's an excellent idea
to consider.

Break it into at least two and possibly three parts. The first part
populates a work area with 15,000 rows. It can be a user space, a memory
allocation or even a temporary work file. You don't have enough rows to be
concerned with only 15,000. The second part sorts those rows (and needs no
WHERE clause). Any sort will be fast enough with such a small table. The
third part performs any positioning and retrieval.

The first part would be executed once. The other two would be executed as
needed.

An additional issue would involve any updating. If users do updates, then
the updates must be applied to the work rows as well as the live rows.

Tom Liotta

rpg400-l-request@xxxxxxxxxxxx wrote:

  7. Re: Even more embedded SQL.... (Alan Shore)
Johnny - thanks for your reply, but I am betting that you do a load all
sub-file, and NOT a page at a time sub-file, which is what I need for
15,000 or more records.

I'm pretty sure that what I need to load page at a time is
FIND NEXT
FIND CURRENT
FIND RELATIVE
for things as Page up, Page Down etc.
but I'm not too sure how to do a position to within the sub-file using SQL


--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertech.com


__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at
http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp
--
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.