How to get list of stored procedure in a namespace of Caché database using a query?

Question

How to get list of stored procedures available in a namespace from an Intersystems Caché database using query?

score 2 · Answer 1 · answered May 06 '14 at 11:51

2

SELECT * FROM %Dictionary.CompiledMethod WHERE SqlProc = 1

answered May 06 '14 at 11:51

Brandon Horst

score 1 · Answer 2 · answered May 06 '14 at 11:47

1

You should be able to query the table

%sql_dict.routine

to obtain the information you are looking for.

answered May 06 '14 at 11:47

Stephen Canzano

2 Answers2