RE: PF with lotsa LFs

The logicals are really just there for ordering, there's no select/omit
specs.

As far as the compiled embedded SQL running on all machines regardless of
whether or not the development lic.pgm. is installed, well I just learned
something.  Even if I wanted to go that route we don't have the developemnt
environment!!!  I think I'll cruise over to David Morris's sourceforge site
and see what I can see there.  Have to be careful though, I might exceed my
quota and learn two things in one day!

I have to admit a bias regarding SQL.  I think it's great for ad-hoc queries
but for a regular inquiry I think it takes too long to build the index every
time you want to inquire.   JMO.  I'll just have to try the LF method and
take a look at the iSeries toolkit for the SQL method and see what happens.

Tom

 |  -----Original Message-----
 |  From: jpcarr@tredegar.com [mailto:jpcarr@tredegar.com]
 |
 |  I've seen some crazy things in shops concerning LF's
 |
 |  LF1   key -  FLDA , FLDB, FLDC
 |  LF2  key  -  FLDA,  FLDB
.
 .
  .
 |
 |  Are many of your's  using select/omit  criteria?
 |  Relook at your DB
 |  design criteria.
 |
 |  You said you didn't use SQL because "SQL is not an option
 |  because it's not
 |  available on all 400s."
 |  If you have a compiled embedded SQL program,   using
 |  dynamic selects,   it
 |  doesn't Matter if SQL exists on the other 400's if you are
 |  only concerned
 |  if your programs would run.   Compiled SQL embedded
 |  programs will work
 |  whether or not the "400"  has the SQL licpgm or not.
 |
 |  Are you selling your source for different machines?
 |
 |  Again ,    USE SQL  and I bet you could cut down on about
 |  20 LF's ( IMO )
 |  John Carr
 |
 |  _______________________________________________
 |  This is the RPG programming on the AS400 / iSeries
 |