If TableA has 3 columns: Col1, Col2, Col3. and I want to create a row in an archive table (tbl_arch), for the Old part of a change operation:
My guess that it would look something like:
CREATE TRIGGER LOGCHANGES1 NO CASCADE BEFORE UPDATE ON dbo.TableA REFERENCING OLD AS O
FOR EACH ROW
INSERT INTO dbo.tbl_arch VALUES
(O.Col1, O.Col2, O.Col3, "O")
I think this is what it would look like in db2, what would it look like in sybase?
I need to capture the date and time stamp (just the system date & time) & load date.
Can you correct the trigger and complete the definition of the table for system generated fields I am looking for (user, date-time-stamp, load date)
My question: Review the trigger and correct any syntax, and complete the table. Provide the system variable name in sybase for the time stamp and load date. Anything close and I'll award the points.