Re: SQLRPGLE question

tomh@simas.com wrote:

> So... how do I "Use the data from that as a variable on the SQL-statement"?  
>Some example
> code would be greatly appreciated.
>
> tomh@simas.com wrote:
>
> > I had opportunity last week to write - from scratch! - my first SQL
> RPGLE
> > program.  What a godsend that we can use embedded SQL.
>
> <snip></snip>
>
> > 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?
>
> Why not list the members in a user space with the Display member list API
> and
> retrieve any occurrence from the user space. Use the data from that as a
> variable
> on the SQL-statement.
>
> Hope this will help,
>
> Carel
>
> +---
> | 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
> +---

I do not have an example, but it has the following sequence:
1) create a user space.
2) list the members of the file into the user space (API is List Members)
3) retrieve the generic header of the user space: it gives information on the 
number of
entries the entry length and the starting position of the entry.
4) do a loop with the number of entries retrieving one entry each time; 
retrieve an entry in
a data structure.
5) use the subfield of the data structure with the member name in your 
SQL-statement.
6) At the end delete the user space.

User sapces are described in the Object API manual, List Members in the File 
API manual.
There have been published many examples using user spaces. Use those as 
examples.

Sorry for the fact I cannot provide sample code.

Hope this will put you into the right direction.

Carel.


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