BCP and Triggers
Posted on 2002-06-21
The Scenario: Two tables, A and B. One trigger T, a row inserted into table A will get the trigger T to fire to automatically insert some values into B. I have no trouble getting the trigger to fire when performing an SQL to insert something into table A. The problem is with BCP. Trigger never fired when I loaded data into table A via the BCP utility. Is this something that Sybase support or am I out of luck?
Also, in Oracle, triggers can be fired after or before a transaction is taken place. Can I do the same thing in Sybase and how?