You can use the Interactive SQL view to create stored procedures or triggers, but make sure that the Database painter’s SQL statement terminator character is not the same as the terminator character used in the stored procedure language of your DBMS.
By default, PowerBuilder uses the semicolon as the SQL statement terminator. You can override the semicolon by specifying a different terminator character in the Database painter. To change the terminator character, select Design>Options from the Database painter’s menu bar.
Make sure that the character you choose is not reserved for another use by your database vendor. For example, using the slash character (/) causes compilation errors with some DBMSs.
