the below bolded text is the logic. inthat im getting this error. proc sql feedback; connect to &db_engine as &db_engine (authdomain=&ecm_dbauth &ecm_db_conopts.); execute ( merge into party_live pl using (select party_rk, version_no, party_full_nm, valid_from_dttm from iem_party_staging) tmp_iem on (tmp_iem.party_rk = pl.party_rk) when matched then update set pl.version_no = tmp_iem.version_no, pl.valid_from_dttm = tmp_iem.valid_from_dttm, pl.party_full_nm = tmp_iem.party_full_nm %if %upcase(&db_engine) eq ODBC %then %do; ; %end; ) by &db_engine; disconnect from &db_engine; quit; SYMBOLGEN: Macro variable DB_ENGINE resolves to oracle MPRINT(FCF_IEM_UPDATE_SUBJECT): execute ( merge into party_live pl using (select party_rk, version_no, party_full_nm, valid_from_dttm from iem_party_staging) tmp_iem on (tmp_iem.party_rk = pl.party_rk) when matched then update set pl.version_no = tmp_iem.version_no, pl.valid_from_dttm = tmp_iem.valid_from_dttm, pl.party_full_nm = tmp_iem.party_full_nm ) by oracle; ERROR: ORACLE execute error: ORA-30926: unable to get a stable set of rows in the source tables. NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements. SYMBOLGEN: Macro variable DB_ENGINE resolves to oracle MPRINT(FCF_IEM_UPDATE_SUBJECT): disconnect from oracle; NOTE: Statement not executed due to NOEXEC option. MPRINT(FCF_IEM_UPDATE_SUBJECT): quit;
... View more