Get all procedures

[kenny.willems]

Hi everony,

there are running several structured procedures on the appserver as super-procedure.

Now I need to find a way to get all the names of the procedures that are in the super-procedures files who are running on the appserver.

hopefully someone can help.

 

[GregTomkins]

In one of your SP's, add a procedure called "get_all_procedures" that:

1. Looks for all the currently active super procedure handles using the SESSION:SUPER-PROCEDURES attribute.

2. For each handle, queries the procedure's INTERNAL-ENTRIES attribute.

3. Load all the internal procedure names into a temp-table or comma-delimited list, and return it to the client.

A drawback of this is that you can't find the internal procedure names until the file has been loaded persistently. There's no easy way to do that, that I know of.

 

[kenny.willems]

Thx GregTomkins.

Now I have the procedures stored in a list, with the input and output parameters. Is there a way to extract information thats placed in comments in the header (notes, purpose) ?

 

[GregTomkins]

Short of parsing the .P files... I don't think so.