CODEWITHSUNDEEP
netezza
MANA
MANA

Reputation: 17

How to view the procedures in Netezza

How to view the procedures in Netezza?

In oracle , we can view with the help of below query.

select * from user_source where object_name=upper('PROC_NAME');

Upvotes: 1

Views: 6790

Answers (3)

Varun Bajaj
Varun Bajaj

Reputation: 1043

Simple way to view procedure signature is -

DB.SCHEMA(USER)=> show procedure <procedure name>

Upvotes: 0

bmaglar
bmaglar

Reputation: 31

On the left panel where the databases are shown click the database, click stored procedures, right click on the procedure, click edit procedure and the procedure will be seen on the right panel

Upvotes: 0

ScottMcG
ScottMcG

Reputation: 3887

The Netezza equivalent would be:

SELECT * FROM  _v_procedure WHERE procedure = 'PROC_NAME';

Upvotes: 4

Related Questions