How to see the content of a Procedure/UDF?

[former_member511603]

I have created a HANA procedure/function using CREATE PROCEDURE/FUNCTION.   After that how do I see the content of the procedure/function?

Regards,

Sau-Boon

[Former Member · Accepted solution]

Hi Sau-Boon,

Call the procedure in SQL console or in script based calculation view

Refer https://scn.sap.com/thread/3158823

Best Regards,

Shireesha

[former_member511603 · Accepted solution]

Sorry I don't get it.  Can you show an example?

I want to see the procedure/function text.

Regards,

Sau-Boon

[former_member182302 · Accepted solution]

Open from Catalog and select the schema and you will see the folder structure mentioning about Procedure

Regards,

Krishna Tangudu

[former_member511603 · Accepted solution]

Sorry I am not using any HANA studio stuff.   How do I see it from SQL?

Regards,

Sau-Boon

[lbreddemann · Accepted solution]

Hmm... as a SAP employee you might want to reconsider your approach towards our own tools.

I also like to encourage you to turn your attention towards the product documentation, that provides information like the one you are looking for.

• FUNCTIONS - SAP HANA SQL and System Views Reference - SAP Library
• FUNCTION_PARAMETER_COLUMNS - SAP HANA SQL and System Views Reference - SAP Library
• FUNCTION_PARAMETERS - SAP HANA SQL and System Views Reference - SAP Library
• PROCEDURES - SAP HANA SQL and System Views Reference - SAP Library
• PROCEDURE_OBJECTS - SAP HANA SQL and System Views Reference - SAP Library
• PROCEDURE_PARAMETERS - SAP HANA SQL and System Views Reference - SAP Library
• PROCEDURE_PARAMETER_COLUMNS - SAP HANA SQL and System Views Reference - SAP Library

The above mentioned system views should provide a comprehensive view on the definition of catalog procedures and functions.

[Former Member]

just run the sql script in a  sql console and view the output. all the select statements can be viewed as output.

Regards,

Anupama