The migration process automatically recompiles stored procedures if the corresponding source code exists. Running the pre_upgrade_prep.pl generates the sp_nospllist.txt report, which lists stored procedures that were not saved with their source code and must, therefore, be recreated.
The SPL option to CREATE/ALTER PROCEDURE causes the procedure source text (SQL and procedural code) to be stored in the database. Stored procedures can be created without SPL for several reasons, but in general this is done to prevent unauthorized modifications, replication,, or distribution of the source code. Teradata stored procedures created without SPL can usually be recreated by executing an appropriate DIP script. Stored procedures without SPL provided by third party vendors may require re-installing a software package, and possibly assistance from the vendor.
Stored procedures need to be recompiled only for major upgrades.
-
View the sp_nospllist.txt report.
The report provides stored procedure names in ASCII text and in hexint forms.
- Recreate each listed stored procedure.