>>-GET_ROUTINE_SAR----------------------------------------------> >--(--sarblob--,--type--,--routine-name-string--+-------------------+--)->< '-,--hide-body-flag-'
The schema is SYSFUN.
The GET_ROUTINE_SAR procedure retrieves the necessary information to install the same routine in another database server running the same level on the same operating system. The information is retrieved into a single BLOB string representing an SQL archive file.
EXECUTE privilege on GET_ROUTINE_SAR procedure
The qualified name of the routine is used to determine which routine to retrieve. The routine that is found must be an SQL routine. Not using a specific name may result in more than one routine, and an error is raised (SQLSTATE 42725). If this occurs, the specific name of the required routine must be used.
The SAR file must include a bind file, which may not be available at the server. If the bind file cannot be found and stored in the SAR file, an error is raised (SQLSTATE 55045).