I have a few user stored procedures in our TEST environment that I would like to re-compile. These procs do not have any stored procedure language associated with them. When I try to show the definition I get a 5535 error indicating the SPL is missing. When I issue the following command I get the same error: alter procedure <procedure name> compile. I have a couple of questions...(1) How does one re-compile a stored procedure that does not contain any stored procedure language? and (2) How does a stored proc get stored without SPL in the first place?
#1: there's no way to recompile an SP without source code.
#2: this is an option during CREATE, in BTEQ .COMPILE FILE .. WITH NOSPL, in ODBC it's ProcedureWithSPLSource, etc.