Creating stored procedures
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.
About the statement terminator
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.