Kbase P95463: SQL: How to list the SQL Java Stored Procedures and Triggers in a database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/04/2009 |
|
Status: Verified
GOAL:
SQL: How to list the SQL Java Stored Procedures and Triggers in a database?
GOAL:
How to view the SQL Java Stored Procedures and Triggers in a database?
GOAL:
How to display the database SQL Java Stored Procedures and Triggers?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
The following SQL-92 statement returns one rows for each SQL stored procedure in the database:
SELECT * FROM SYSPROGRESS.SYSPROCEDURES;
The following SQL statement returns one rows for each SQL trigger in the database:
SELECT * FROM SYSPROGRESS.SYSTRIGGER;
The following SQL statement returns one or more rows for each stored procedure and trigger in the database. The row contains the Java source code for a procedure or trigger.
SELECT * FROM SYSPROGRESS.SYSPROCTEXT;