How to check if column is defined in source table?
I was trying to use @COLTEST function but I got following error:
MAP resolved (entry smigacz.ms2):
map "SMIGACZ"."MS2", target smigacz2.ms2, colmap (usedefaults, MS2_ISFLAGY= @IF(@COLTEST(MS2_FLAG_Y, PRESENT),"PRESENT", "NOTPRESENT"));
Using the following default columns with matching names:
MS2_ID=MS2_ID, MS2_TEKST=MS2_TEKST, MS2_MOJA=MS2_MOJA, MS2_FLAG_X=MS2_FLAG_X
2014-02-14 13:05:40 INFO OGG-01298 Column function diagnostic message: could not find column MS2_FLAG_Y.
... @IF(@COLTEST(MS2_FLAG_Y, PRES...
Error in COLMAP clause. Invalid function or argument.
I've trying also with option MISSING but result is the same.
Column MS2_FLAG_Y is defined only on target table. Tables definitions are not the same so I'm using SOURCEDEFS parameter with generated definitions for source tables.
Could anyone help with this issue?