there is a way to create Triggers in standard way

[outis]

Hi all, I need to create a DataBase whith triggers and StoreProcedures, but I have to use mostly standard as possible
because i need to migrate data base to informix, oracle, and other DB's, does anybody have any Idea, or suggestion.
I will apreciate your response
Thanks in advance

 

[johnherman]

Triggers and SP's use extended versions of SQL which are proprietary to the vendor and product involved. Oracle uses PL/SQL, Sybase and Microsoft use Transact-SQL (or T-SQL), DB2 uses SQL/PL, and so on. There is no way to insure direct transportability of your code across systems. You can, however, minimize the modifications required by using ANSI-SQL within those triggers and sp's whenever possible.

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright