var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Chanfing the SP
I have modified a Stored procedure for UDB 7.2 on AIX.
How do I implement the modified SP in the database.
Is the Drop proc / Create proc enough OR Alter PROC is good option.
Also do I need to do anything else than this in order to call this proc from application codes?
Also how do I test the proc using just the command line tools?
Thanks in advance
To change a Stored Proc you need to drop/re-create. To execute a Stored Proc look at the CALL command which look like this:
CALL schema.storedprocname ();
empty () implies their are no variable that are pass.