Hi,

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
j

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.

HTH,

Dany