0 Replies Latest reply: Feb 14, 2014 6:59 AM by 2612661 RSS

    OGG-01298  Column function diagnostic message: could not find column

    2612661

      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?