Topic
1 reply Latest Post - ‏2013-01-04T17:02:30Z by SystemAdmin
sbjerry
sbjerry
23 Posts
ACCEPTED ANSWER

Pinned topic LOOKUP VALUECOL NOT FOUND

‏2012-12-26T13:28:29Z |
The lookup table has two fields, one of them is ADRC01, but when I use the function

RAND_LOOKUP(ASSRCDB1.DB2ADMIN.LKUP,ADRC01)

It gives out "LOOKUP VALUECOL NOT FOUND"

The dbalias of the look up db exist....
Updated on 2013-01-04T17:02:30Z at 2013-01-04T17:02:30Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    304 Posts
    ACCEPTED ANSWER

    Re: LOOKUP VALUECOL NOT FOUND

    ‏2013-01-04T17:02:30Z  in response to sbjerry
    If you just created that column or table you may need to restart optim tool. It doesn't notice db changes realtime unfortunately.. If doesn't work, check your dbalias name.. It exists but you may be using wrong one :)