QMF user-defined functions and procedures

Some of the optional QMF installation features allow you to create user-defined functions and procedures.

The following table lists the user-defined functions and procedures that are associated with optional installation features. The user-defined functions and procedures that are available in your environment will vary based on the optional features that are installed.

Table 1. User-defined functions and procedures
Name	Specific name	Type	Optional installation job that defines the function or procedure	Use
Q.DSQQMFSP	DSQQMFSP	Procedure	DSQ1BSP	QMF stored procedure interface
Q.DSQABA1E	DSQABA1E	Procedure	DSQ1BUDF	Enhanced list view processing
Q.DSQABA1E	DSQABA1E_D	Function	DSQ1BUDF	Enhanced list view processing
Q.APPL_AUTHNAMES	DSQABA1E_F0V	Function	DSQ1BUDF	Enhanced list view processing
Q.APPL_AUTHNAMES	DSQABA1E_F1V	Function	DSQ1BUDF	Enhanced list view processing

Important: If your WLM environment changes after QMF has been installed, you must run ALTER statements to update the WLM environment information for any of the user-defined functions or procedures that you are using. For example:

ALTER PROCEDURE Q.DSQQMFSP 
WLM ENVIRONMENT new_environment_name;   
ALTER FUNCTION Q.DSQABA1E              
WLM ENVIRONMENT new_environment_name;              
ALTER SPECIFIC FUNCTION Q.DSQABA1E_F0V 
WLM ENVIRONMENT new_environment_name;               
ALTER SPECIFIC FUNCTION Q.DSQABA1E_F1V 
WLM ENVIRONMENT new_environment_name;            
ALTER PROCEDURE Q.DSQABA1E               
WLM ENVIRONMENT new_environment_name;