sometimes I want to pass only 3 params in macro, how can I do that?
Macro #sync_exception
PARAMS (#SCHEMA_NAME,#MAP_TABLE,#TABLE_NAME,#TABLE_CODE, #key1,#key2,#key3,#key4,#key5,#key6,#key7)
BEGIN,
MAP #SCHEMA_NAME.#MAP_TABLE, TARGET CORE_NAT.GG_SYNC_ERR_LOG,
EXCEPTIONSONLY,
INSERTALLRECORDS
COLMAP(
ID = @COLSTAT(NULL),
TABLE_NAME = #TABLE_NAME,
KEY1 = #key1,
KEY2 = #key2,
KEY3 = #key3,
KEY4 = #key4,
KEY5 = #key5,
KEY6 = #key6,
KEY7 = #key7,
ERROR_CODE = @GETENV ('LASTERR', 'DBERRNUM'),
ERROR_MSG = @GETENV ('LASTERR', 'DBERRMSG'),
CREATED_DATE = @DATENOW (),
TABLE_CODE = #TABLE_CODE,
ERR_DETAILS = @GETENV ('LASTERR', 'OPTYPE'));
END;