Unfortunetly, you are speaking greek to me. EGL Generates java code. It also
uses t400.jar if that sheds any light on whats going on behind the scenes. I
believe its all java based.
With Egl, you can basically load a datatable with 1 line of code:
Get countrytable;
This would run an sql which you can include if you wish:
Get countrytable with
#sql{
select
countryname, countrycode
from QS36F.country file
order by countryname
};
You can load a table record by record, but this is the fastest method.
So, since I am loading the country table all at once (get countrytable),
paging would not be an option. I can work in paging, but would really love
to be able to SFLRCDNBR a load-all-at-once datatable.
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Aaron Bartell
Sent: Thursday, December 13, 2007 5:37 PM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] JSF/EGL datatable positioning question
I meant to say SQL paging which would be required for most dataTable's in a
frequently used application. What you are describing simply loads the
entire result set into memory and scrolls through the Java Collection. You
will outgrow this fast so I would recommend getting it working with SQL
paging sooner than later. My processes outgrew it when there were around
half a million records (note this was on a souped up Wintel Dell rackmount
server).
I could show you how I do it with Apache MyFaces and Hibernate, but I don't
know if that would really help you. What is EGL using for data access under
the covers? Does it have some sort of ORM solution (I believe IBM's first
JSF incantations used Web Data Objects or WDO).
If what I am saying doesn't make sense then I can try to put together a
sampling using what I have.
HTH,
Aaron Bartell
http://mowyourlawn.com
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of tim
Sent: Thursday, December 13, 2007 4:17 PM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] JSF/EGL datatable positioning question
Paging out of box. Yes, You can specify height of table and it will add
scroll bar controls as needed. You can also set up how many records to be
displayed per page and it will control the page forward/back functionality.
I guess what I am doing in RPG talk would be loading the entire subfile at
once. And im wondering if there is a SFLRCDNBR equivalent in JSF/EGL.
Im new to doing EGL so not sure all the terms.
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Aaron Bartell
Sent: Thursday, December 13, 2007 4:45 PM
To: 'Web Enabling the AS400 / iSeries'
Subject: Re: [WEB400] JSF/EGL datatable positioning question
The way I do this with JSF is have the backing bean be session scoped and
then store the rrn of the SQL result set to start at each time the listing
is redisplayed. Even if they navigate off the page and back again they will
be returned to the exact page they were looking at.
Does EGL come with paging out of the box?
HTH,
Aaron Bartell
http://mowyourlawn.com
midrange.com
