× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Try renaming your data structure to begin with "TAB". My recollection is that the %lookup op-code does not work on tables named something else in the same way the column LOOKUP worked.

-----Original Message----- From: Bill Howie ; Bill Howie
Sent: Thursday, November 06, 2014 8:10 AM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: RNF0571 The second parameter of LOOKUP is not valid

Hello all,

I have what I think is a simple question........I have an array with an
associated data structure defined like this:

HCAArray ds 363 dim(100) qualified
HCAID 3 0
HCAHarms 360


Basically this is to be an array with two fields, an ID (HCAID) and a large
text field (HCAHarms). I'm then trying to do a lookup on the large text
field portion of this array as follows:

eval IndexF = %lookup(workharms:HCAArray.HCAHarms)

However I'm getting the RNF0571 compile error. Second parm of LOOKUP is
not valid. I know the second parm has to be an array, but I guess I thought
it was. I've also tried this variation:

eval IndexF = %lookup(workharms:HCAArray)

And I get the same error. I basically want to search the HCAHarms field
for a value that I have in a work field (workharms). Any thoughts out
there on what I'm doing wrong? All help appreciated. Thanks!

Bill



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.