Two tables involved in this update script that I need. ARINVT and TRANSLOG. I need to update ARINVT.CYCLE_COUNT_DATE with the data from TRANSLOG.TRANS_DATE. The conditions for this update is that TRANSLOG.TRANS_DESCRIP = 'CYC CT' and the date of TRANSLOG.TRANS_DATE must = systemdate.
ARINVIT.CYCLE_COUNT_DATE (DATE TIME)
TRANSLOG.TRANS_DATE (DATE TIME)