Dear team,
currently for one of requirement, we are using some insert statement with SQLEXEC at replicat(SOURCE Extract has one record for the table we're using). When testing, that insert statement had some issues and failed due to some syntax error, but replicat did not fail and started executing other steps.
extract:
--------
extract teste1
useridalias src1
extfile AA purge
encrytptrail AE256 KEYNAME TEST1
SOURCECATALOG PDB1
TABLE SCHEMA.TABLE1, FILTER(C1='VAL1'); --so that it retrieves only one row
TABLE SCHEMA.TABLE2;
TABLE SCHEMA.TABLE3;
replicat:
----------
repicat testr1
useridalias tgt1
DECRYPTTRAIL AES256 KEYNAME PMS1KEY
DBOPTIONS NOSUPPRESSTRIGGERS
NODISCARDFILE
SOURCECATALOG PDB1
TABLE SCHEMA.TABLE1,
SQLEXEC(ID INS1, "INSERT INTO LOG VALUES('ASDFSD')");
MAP SCHEMA.TABLE2, TARGET SCHEMA.TABLE2;
…..
I also tried with mentioning ERROR FATAL(referring oracle doc)
SQLEXEC(ID INS1, "INSERT INTO LOG VALUES('ASDFSD')", ERROR FATAL); but still same behavior, process is not getting abended.