NewLookupRow, in Dynamic Cache Lookup

[sln007]

I am attempting to use a Lookup with Dynamic Cache.

The lookup is not working correctly.

When I run the workflow with an empty lookup table, good insert.

If I immediately run the workflow again, NewLookupRow is getting set to "1" every time, and I end up reinserting
all rows again.

What am I missing? or What do I need to look closer at?

Please assist.

Thanks.

State of Ohio, MIS

 

[sln007]

This is solved.

The DB2 field(s) in the lookup are defined as 8-Char Strings.
The field(s) themselves may not have a total of 8-chars in them.

You must RPAD(<field>, 8, 'space') the parameter being sent to the Lookup, so that the lookup has all 8-characters filled (or all of the field's length).

It now works.


Steve N.
State of Ohio, MIS