Start a new topic

Informix store procedure view

[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

[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