Re: Problem using tlookup bif

[Barbara Morris <bmorris@xxxxxxxxxx>]

On 12/16/2010 9:56 AM, David FOXWELL wrote:
> Thanks, but I don't remember ever coding ASCEND. Surely that is implicit?

ASCEND is implicit for sorting, but not for lookup.  If you code ASCEND 
on your array, RPG will assume the array is already in ascending order 
for %LOOKUP and will use a fast binary search.  If you don't code either 
ASCEND or DESCEND, RPG will not make any assumption about the order, and 
will use a sequential search.

So for your table, which doesn't have ASCEND or DESCEND, the %TLOOKUP 
will do a sequential search, and the elements don't have to be ordered.

David, if you haven't already solved this, check in the debugger to make 
sure that element really is in your table on the statement where you do 
the %TLOOKUP.

Use this debugger command:
===> EVAL TABERA(1..99)