Re: SQL Fetch Into Multiple Externally Defined Data Structures

I have Googled around, but not found an answer.....so here goes -

My embedded sql usually looks something like this -

this is the select statement - "select * from d00001h"

d wD00001H e ds extname(D00001H)
.
.
c/exec sql
c+ fetch Fetch_Summary1 into : wD00001H
c/end-exec
.
.
.
and all of my fields are found in wD00001H. That works great.

I now have a situation where I want to return all of the fields from two
different files. The select statement looks like this -

select * from d00001h, dmaster WHERE mreqnum=186 and Y1REQ#=MREQNUM

I have tried this -

d wD00001H e ds extname(D00001H)
d wDMASTER e ds extname(DMASTER)

d results ds qualified
d oD00001H likeds(wD00001H)
d oDMASTER likeds(wDMASTER)
.
.
.
c+ fetch Fetch_Summary1 into : results
.
.

But the sql pre compile fails with this message "Variable RESULTS not
defined or not usable.". I have tried other scenarios too, but am
stumped!
Any suggestions?

Thanks,

Joe Wells

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.