Compiling Stored Procedures with No SPL (No Stored Procedure Language)

Database
Enthusiast

Compiling Stored Procedures with No SPL (No Stored Procedure Language)

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?

Thanks,

Joe

1 REPLY
Senior Apprentice

Re: Compiling Stored Procedures with No SPL (No Stored Procedure Language)

#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.

Dieter