Re: Using a DS in an sql lookup

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

You don't "get around" it. You fix it <grin>

Interchange_t does not exist in TransactionSet - the name you gave it was was InterchangeHeader.

SO the where clause should have been Where aiCust = :TransactionSet.InterchangeHeader.GUID


On 2013-10-04, at 3:36 PM, RPGLIST <rpglist@xxxxxxxxxxx> wrote:

> I have the following DS's defined:
>
> D TransactionSet  ds                  qualified
> D   InterchangeHeader...
> D                                     likeds(Interchange_t)
>
> D Interchange_t   ds                  qualified
> D                                     based(template)
> D   GUID                        25a
> D   TransDate                   10a
> D   TransTime                   10a
> D   Version                     10a
> D   Sender                      25a
> D   Receiver                    25a
> D   TestProdInd                  1a
>
>
> I'm attempting to do a lookup on an sql table iwth the following and its
> not liking my idea:
>
> Where aiCust = :TransactionSet.interchange_t.GUID;
>
> I'm getting a token . was not valid error.  Now, it if had
> :TransactionSet.GUID; it would take it...
>
> How do I get around this?
>
>
>
> -- 
> This is the RPG programming on the IBM i (AS/400 and 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.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com