How do I force the specific name for a procedure so that the DB doesn use its random number?
Use the SPECIFIC keyword when creating the proc. See the example below… CREATE PROCEDURE HH.SOME_PROC_P( IN v_iSomeId SMALLINT) DYNAMIC RESULT SETS 1 LANGUAGE SQL SPECIFIC SOME_PROC_P BEGIN … You can then drop and recreate the proc via it’s specific name as many times as you want without having to find the new specific name…
