Re: subfile

["David Morris" <David.Morris@xxxxxxxxxxxxx>]

Yildiray,

The biggest problem is that JSP pages operate in a stateless
environment. You can maintain object state in a session and deal with
timeouts, etc. but it is difficult to duplicate the support you get with
green screen applications. If you are using JSP to directly access data,
you really can't duplicate this type of support. Because of this it is
generally better to avoid large scrollable displays. If you get
creative, you can almost always figure out ways to limit the results
returned to a user. For example, you might add controls that show a - z,
dollar ranges, etc. as selectable links that auto-submit. The goal is to
break big requests down into more little requests.

If you can't get away from paged data you can use a scrollable result
set fetch n records but then you have to deal with timeouts. Another
alternative is to set up a composite key indexes so you can do
selections like select * from file where compositekey >= 'Customer name 
         Customer address...' fetch first 10 records only. This avoids
timeout issues but adds overhead in maintaining composite key indexes.

David Morris

>>> yildirayo@xxxxxxxxxxxxxxxxxxx 1/19/2004 12:10:20 PM >>>
Hi,

We are trying to convert green screens to JSP pages. Does anyone know
how to
duplicate subfile functionality(roll screen) in JSP pages. Is there any
easy
way or a wizard in Websphere?

Thanks,
Yildiray Ozen