A
Anverion
Guest
Hi John, just to see what would happen, I created a single rulesheet before my service connector that sets CmsEfd transient values for my UPDATE SQL. New UPDATE SQL: UPDATE cms.cms_efd SET cms_efd.detail_status_id={CmsEfd.detailStatusId}, cms_efd.updated_by={CmsEfd.tempUpdatedBy}, cms_efd.updated_at={CmsEfd.tempUpdatedAt} where cms_efd.detail_record_id IN ({CmsEfd.detailRecordId}) The same behavior was the result: SQL 1: select detail_record_id from cms.cms_efd WHERE earnings_file_id IN ('370') SQL 2: UPDATE cms.cms_efd SET cms_efd.detail_status_id=1, cms_efd.updated_by='John Wick', cms_efd.updated_at='2019-06-19 13:55:59' where cms_efd.detail_record_id IN ('370P1') SQL 3: UPDATE cms.cms_efd SET cms_efd.detail_status_id=1, cms_efd.updated_by='John Wick', cms_efd.updated_at='2019-06-19 13:55:59' where cms_efd.detail_record_id IN ('370P2') SQL 4: UPDATE cms.cms_efd SET cms_efd.detail_status_id=1, cms_efd.updated_by='John Wick', cms_efd.updated_at='2019-06-19 13:55:59' where cms_efd.detail_record_id IN ('370P3') SQL 5: UPDATE cms.cms_efd SET cms_efd.detail_status_id=1, cms_efd.updated_by='John Wick', cms_efd.updated_at='2019-06-19 13:55:59' where cms_efd.detail_record_id IN ('370P4') I'm guessing that this is just the behavior for a WRITE statement using batch. Like I said before, I would prefer to see 2 SQL statements: SQL 1: select detail_record_id from cms.cms_efd WHERE earnings_file_id IN ('370') SQL 2: UPDATE cms.cms_efd SET cms_efd.detail_status_id=1, cms_efd.updated_by='John Wick', cms_efd.updated_at='2019-06-19 13:55:59' where cms_efd.detail_record_id IN ('370P1','370P2','370P3','370P4') But maybe that'll be something they enhance down the road. Thanks for your time and effort on this. -Branden
Continue reading...
Continue reading...