J
Johnson Thomas
Guest
Thanks for the reply, my purpose of this is to copy the incremental data or the changed data in the source table to a staging table with some additional field to identify the update time stamp. I will use this staging table to populate the NON-Progress Datawarehouse with daily incremental data extracted through ETL. I am avoiding the search on the staging table considering the performance impact on the transaction and all the write operation in source table is simply copied to the staging table. The actual code will look like this. TRIGGER PROCEDURE FOR WRITE OF OLD BUFFER BeforeTableBuffer. DEF VAR V_LOGICAL AS LOGICAL NO-UNDO. BUFFER-COMPARE TO BeforeTableBuffer SAVE RESULT IN V_LOGICAL. IF NOT V_LOGICAL THEN DO: CREATE . BUFFER-COPY TO . ASSIGN LAST_UPDT_DATE = TODAY LAST_UPDT_TIME = STRING(TIME,"HH:MM:SS") UPDT_FLAG = 'W'. END. Housekeeping Job will be introduced to purge the data in this table. There is multiple tables data has to be done like this, hence I was looking for an generic procedure which I can pass the table name and use the same code.
Continue reading...
Continue reading...