Re: joining 2 files in datastructure assignment

You are right Dave. For some reason I was conditioned to think that you
could only list one datastructure in a fetch, but as I'm testing it, it
looks like you can. Thank you so much. This may save time in more than
just this current project.



___________________________________
Darren Strong
Dekko





From: dlclark@xxxxxxxxxxxxxxxx
To: "RPG programming on the IBM i\(AS/400 and iSeries\)"
<rpg400-l@xxxxxxxxxxxx>
Date: 05/30/2018 02:10 PM
Subject: Re: joining 2 files in datastructure assignment
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>



"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 05/30/2018 02:03:01
PM:

I'm trying to figure out a better way to define a datastructure for a
cursor fetch when I have two files joined in an SQL. See the next as an

example. I'd like to define the datastructure as two external

structures

combined, but the compiler doesn't like it much when I try.

I have done this exact thing an dit worked just fine. However, I
was using dynamic SQL. Though, I don't know why it wouldn't work just the

same in static SQL.


exec sql fetch from ACTMAUDRS_Matched_Triggers
into :ViewDS :ViewIndAry,
:TrigDS :TrigIndAry;


Sincerely,

Dave Clark