RE: SQLRPGLE question

[tomh@xxxxxxxxx]

I could do that, but the nature of the data is such that it would be highly inefficient.  It's EDI data, with an unknown number of record types in an unknown number of members.  The format of the data depends on who the data comes from (each vendor will send us the data structured in a format easiest for them, and still "matching" the standard).  Strings mostly.

 

Another drawback to building a logical is that the data is maintained by programs over which I have no control, or source code.  I do not know what would happen if I were to build a logical(s) over the file, and leave the logical on disk.  Of course, I could just re-create it whenever I needed but who wants to do that?

 

Besides, I'd just like to know how to use the SQL 'ALIAS' with a variable member name.

 

>
>
>jpcarr@TREDEGAR.COM
>Sent by: owner-rpg400-l@midrange.com
>08/23/2000 10:38 AM AST
>Please respond to RPG400-L
>
> To: RPG400-L@midrange.com
> cc:
> bcc:
> Subject: RE: SQLRPGLE question
>
>
>

>Actually ,  You could create a Logical over all members and use SQL, or
>Query/400 against it.    However,   Both will create a temporary copy of
>all the data in all the members to get it into one table , then process it.
>John Carr
>
>
>
>
>Hannes,
>
>MBR( *all ) doesn't work with SQL, OPNQRYF, or anything else that uses the
>query engine.
>
>Dave Shaw
>Spartan International, Inc.
>Spartanburg, SC
>
>-----Original Message-----
>From: Hannes Rosner [mailto:Rosner@AsSoft.com]
>
>What do you think about
>OVRDBF FILE( &file ) TOFILE( &tofile ) MBR( *all )
>
>regards
>Hannes Rosner
>
>
>-----Ursprüngliche Nachricht-----
>Von: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com] im
>Auftrag von tomh@simas.com
>Gesendet am:   Dienstag, 22. August 2000 23:04
>An:  rpg400-l@midrange.com
>Betreff:  SQLRPGLE question
>
>I had opportunity last week to write - from scratch! - my first SQL RPGLE
>program.  What a godsend that we can use embedded SQL.
>
>What it does: uses the 'C' SystemCmd function to run the DSPFD command to
>build a file containing the member list of a certain multi-member PF.  Then
>it uses the SystemCmd function to do an OVRDBF to open each member in the
>file.  Then using SQL I read each record in the member.
>
>I do not know beforehand what the members are in the multi-member file.
>I'd like to use the SQL 'ALIAS' command to do the override instead of using
>the OVRDBF.  So... how do I use the SQL 'ALIAS' command with a variable
>member name?
>
>
>
>
>+---
>| This is the RPG/400 Mailing List!
>| To submit a new message, send your mail to RPG400-L@midrange.com.
>| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---