RE: Saving the System i: Fight Rather Than Switch

   Until somebody shows me something better for random record retrieval, yes.
   I also seem to recall a statement by the esteemed Jim Sloan saying that in
   many cases, FMTDTA can be faster and more powerful than ONPQRYF.
    
   It all boils down to using the right tool for the job. I can drive a nail
   with a tire iron, but I'd rather use a hammer. I guess it's my advanced
   age
   -- 

   Paul Nelson
   Arbor Solutions, Inc.
   708-670-6978  Cell
   pnelson@xxxxxxxxxx
   -----midrange-l-bounces@xxxxxxxxxxxx wrote: -----

     To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
     From: "Turnidge, Dave" <DTurnidge@xxxxxxxxxxxxxxxxxxxx>
     Sent by: midrange-l-bounces@xxxxxxxxxxxx
     Date: 12/15/2006 02:55PM
     Subject: RE: Saving the System i: Fight Rather Than Switch

     "always"  ...  So, if you are going for a single record retrieval,
     and/or update, CHAINing is always faster. Is CHAINing always BETTER? Is
     this going to be the case into the future?

     So, we should always have embedded SQL for multi-record access, and F
     specs for single record access and update. Right?

     Dave

     -----Original Message-----
     From: midrange-l-bounces@xxxxxxxxxxxx
     [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of pnelson@xxxxxxxxxx
     Sent: Friday, December 15, 2006 1:42 PM
     To: Midrange Systems Technical Discussion
     Subject: RE: Saving the System i: Fight Rather Than Switch

       IMO, there will always be cases where green screen will always be
     faster
       for quickie changes and recompiles.
       I still haven't seen WDSC run on a hand held device, but I have seen
       someone modify and recompile a program using the keyboard of a Treo.
        
       And CHAIN will always be faster than SQL for single record access.
       --

       Paul Nelson
       Arbor Solutions, Inc.
       708-670-6978  Cell
       pnelson@xxxxxxxxxx
       -----midrange-l-bounces@xxxxxxxxxxxx wrote: -----

     --
     This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
     list
     To post a message email: MIDRANGE-L@xxxxxxxxxxxx
     To subscribe, unsubscribe, or change list options,
     visit: http://lists.midrange.com/mailman/listinfo/midrange-l
     or email: MIDRANGE-L-request@xxxxxxxxxxxx
     Before posting, please take a moment to review the archives
     at http://archive.midrange.com/midrange-l.