[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.
1 Comment
Hans Bergsten
said
over 8 years ago
[This reply is migrated from our old forums.]
Re: Informix store procedure view
Hi,
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.
Best Regards,
Hans
anonymous