Re: Using a DS in an sql lookup

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