RE: Alternatives to build a LF on the fly

In fact I need the same record selections and, most importantly, the
same sequence. I think I'll try Paul's suggestion (use CRTDUPOBJ of the
LF instead of CRTLF)

Many thanks to all!!!


Valerio Vincenti
IT Business Analyst
County of Spotsylvania, I.S. Department
Spotsylvania, VA 22553
Phone (540) 582-7055 Ext. 233
Fax (540) 582-9841
e-mail: vvincenti@xxxxxxxxxxxxxxxxxx


>>> CWilt@xxxxxxxxxxxx 05/04/05 03:39PM >>>
The only problem I see with that is that you can't use ORDER BY on the
view.

Since Valerio was planning on creating a logical over a physical that
already just contained the records he is interested in, I assume that
means he needs them in some sort of alternate sequence.


> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Pete Helgren
> Sent: Wednesday, May 04, 2005 3:34 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: Alternatives to build a LF on the fly
> 
> 
> Valerio,
> 
> Elvis is on the right path here. This is what I would suggest 
> as well.  
> It is an SQL command you'd have to issue before processing 
> and then use 
> "drop view" after you completed processing to clean up.
> 
> Pete Helgren
> Timpanogos Technologies
> 
> Elvis Budimlic wrote:
> 
> >CREATE sql VIEW in QTEMP and go against it?
> >
> >-----Original Message-----
> > Subject: RE: Alternatives to build a LF on the fly
> >
> >Charles, I guess I didn't make myself clear. I must use the same
> >program.  Embedded SQL requires mods to the rpg code and 
> that's not an
> >option. 
> >