[This topic is migrated from our old forums. The original author name has been removed]
Is there a way to display informix stored procedure code? The sql commander window displays columns. I am running
select * from sysprocbody where procid = 739 and datakey = 'T'
but that's not a very nice way to script the proc.
over 5 years ago
[This reply is migrated from our old forums.]
Re: Informix store procedure view
Assuming you are using the Pro edition, double-click on a procedure node in the tree to open a Procedure Editor with the code, or use Script Procedure in the right-click menu for the node to script a CREATE statement to an SQL Commander tab.