Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
Quick question... should normal error handling of an ApplyMap() that referenced a non-existant mapping table return an error?
ApplyMap('thismappingtabledoesntexist',F1,'this is the map default message') AS MAP_TEST
No, Applymap doesn't know about errors. Everything is OK to applymap, but you may not get the results you expect.
Note that applymap() by default returns NULL only when the mapping table doesn't exist. Otherwise it will return either the search result, the original index value or the value of the third parameter (can also be NULL)
Peter
No, Applymap doesn't know about errors. Everything is OK to applymap, but you may not get the results you expect.
Note that applymap() by default returns NULL only when the mapping table doesn't exist. Otherwise it will return either the search result, the original index value or the value of the third parameter (can also be NULL)
Peter