ogg 列映射函数使用方法汇总

MAP source.Table_name, target target.Table_name, exceptionsonly,
INSERTALLRECORDS, KEYCOLS (Column1), colmap (usedefaults, gg_dml_type = @GETENV ("LASTERR", "OPTYPE"), gg_db_error = @GETENV ("LASTERR", "DBERRNUM"));

eg:

source.Table_name, target target.Table_name,, exceptionsonly,
INSERTALLRECORDS, colmap (usedefaults, gg_dml_type = @GETENV ("LASTERR", "OPTYPE"), gg_db_error = @GETENV ("LASTERR", "DBERRNUM")GG_DML_FIXFLAG = @COLSTAT (MISSING));

or

source.Table_name, target target.Table_name,, exceptionsonly,
INSERTALLRECORDS, colmap (usedefaults, gg_dml_type = @GETENV ("LASTERR", "OPTYPE"), gg_db_error = @GETENV ("LASTERR", "DBERRNUM") GG_DML_FIXFLAG = 'Y');

MAP cmm_user_center.cst_np_social_rl,target FLUSRTEST.cst_np_social_rl, COLMAP (usedefaults,birthday = @IF(birthday ='',@COLSTAT (NULL),birthday));