SFL Load - SQL vs. LF

 Back in about 1997 Midrange Computing published an article by Richard
Rubin regarding handling subfiles and using SQL to load them.  If you
can find it or if it is still on MC website, Check it out. 


Stan Fellers
Senior Programmer Analyst
Magellan Health Services
314-387-4243
314-387-4270 fax

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
midrange-l-request@xxxxxxxxxxxx
Sent: Wednesday, September 07, 2005 2:07 PM
To: midrange-l@xxxxxxxxxxxx
Subject: MIDRANGE-L Digest, Vol 4, Issue 1682

Send MIDRANGE-L mailing list submissions to
        midrange-l@xxxxxxxxxxxx

To subscribe or unsubscribe via the World Wide Web, visit
        http://lists.midrange.com/mailman/listinfo/midrange-l
or, via email, send a message with subject or body 'help' to
        midrange-l-request@xxxxxxxxxxxx

You can reach the person managing the list at
        midrange-l-owner@xxxxxxxxxxxx

When replying, please edit your Subject line so it is more specific than
"Re: Contents of MIDRANGE-L digest..."


Today's Topics:

   1. Re: DB/2 Query Mgr & SQL Dev Kit Product ID 5769-ST1
      installation p    roblem (Billy Rowe)
   2. Re: SFL Load - SQL vs. LF (James H H Lampert)
   3. RE: Does  anyone use  noaa?   (Al Mac)
   4. Re: SFL Load - SQL vs. LF (rob@xxxxxxxxx)
   5. RE: DB/2 Query Mgr & SQL Dev Kit Product ID 5769-ST1
      installation      problem (Ramon Urbina)
   6. RE: DB/2 Query Mgr & SQL Dev Kit Product ID 5769-ST1
      installation      problem (rob@xxxxxxxxx)
   7. RE: SFL Load - SQL vs. LF (Hewitt, Rory)
   8. RE: NOLA/COMMON S06 (Carey Jeff - jcarey)
   9. RE: NOLA/COMMON S06 (pnelson@xxxxxxxxxx)
  10. Window Colours in ILE C++ (Brian Piotrowski)


----------------------------------------------------------------------

message: 1
date: Wed, 07 Sep 2005 13:06:22 -0500
from: Billy Rowe <billyrowe@xxxxxxx>
subject: Re: DB/2 Query Mgr & SQL Dev Kit Product ID 5769-ST1
        installation p  roblem

Try:  Go LicPgm and take option 50 - Completion Status             
  50. Display log for messages
and see if this helps with more details.

hth,
spaceBAR

------ Original Message ------
Received: Wed, 07 Sep 2005 12:45:36 PM CDT
From: Ramon Urbina <rurbina@xxxxxxxxxxxx>
To: "'midrange-l@xxxxxxxxxxxx'" <midrange-l@xxxxxxxxxxxx>
Subject: DB/2 Query Mgr & SQL Dev Kit  Product ID  5769-ST1 installation
p roblem

Can anyone help me on installing this product on V4R5?
I went to the license program and selected option 11.
Went to the list and selected 5769ST1.
Inserted CD L29xx_01, the system read the CD.
Installation incomplete message on the log.


Thank You,
Ramon Urbina
Cover-All Computer Services
905-477-8494 x295

--
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.








------------------------------

message: 2
date: Wed, 07 Sep 2005 11:09:16 -0700
from: "James H H Lampert" <jamesl@xxxxxxxxxxx>
subject: Re: SFL Load - SQL vs. LF

Billy Rowe <billyrowe@xxxxxxx> wrote:
> No matter which presentation method you decide to you, 
> definitely create the tables/indexes/views with SQL.

Why?

--
JHHL
(who is much more fluent in DDS and OPNQRYF than with SQL)


------------------------------

message: 3
date: Wed, 07 Sep 2005 12:17:50 -0500
from: Al Mac <macwheel99@xxxxxxxxxxx>
subject: RE: Does  anyone use  noaa?  

I subscribe to this place, to send me dire warnings that affect the city

county that I live in, and none of the surrounding USA.  I do get some 
mundane stuff like after every heavy rain there is the flooding and fog
alerts.

>To: MacWheel99@xxxxxxxxxxx
>Subject: HURRICANE KATRINA RELIEF RESOURCES
>
>Hurricane Katrina Relief resources at...
>
>http://www.emergencyemail.org/katrinarelief1.asp
>
>THE EMERGENCY EMAIL & WIRELESS NETWORK
>http://www.emergencyemail.org/




------------------------------

message: 4
date: Wed, 7 Sep 2005 13:29:35 -0500
from: rob@xxxxxxxxx
subject: Re: SFL Load - SQL vs. LF

Sounds like an ideal use for SQL.  Positioning to can be a challenge 
though.  Perhaps that can be overcome by selection criteria.  For
example 
take a 'position to' of an S and change it to a "like 'S%'" selection. 
Different, but maybe acceptable.

Rob Berendt