Re: SQLRPGLE question

[tomh@xxxxxxxxx]

My program does exactly as you suggest,, but using a file instead of a 
user space.  My problem is with "5) use the subfield of the data structure with 
the member name in your 
SQL-statement".  This implies that I would need to supply the member name 
to the SQL statement via a variable.  I've yet to find out how to do this 
in SQLRPGLE; I don't think it can be done directly (ie, not within a SQL 
block).  I can point to the correct member by issuing an "OVRDBF" command, 
but I've found no valid complementary method in SQLRPGLE (ie, I can't 
supply a variable member name to the "CREATE ALIAS" sql statement).





Carel Teijgeler <teygeler@bart.nl>
Sent by: owner-rpg400-l@midrange.com
08/25/00 10:57 AM
Please respond to RPG400-L

 
        To:     RPG400-L@midrange.com
        cc: 
        Subject:        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
>

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