DB2 Version 9.7 for Linux, UNIX, and Windows

GET_ROUTINE_OPTS scalar function


>>-GET_ROUTINE_OPTS--(--)--------------------------------------><

The schema is SYSPROC.

The GET_ROUTINE_OPTS function returns a character string value of the options that are to be used for the creation of SQL procedures in the current session.

Authorization

One of the following authorities is required to execute the function:

EXECUTE privilege on the function
DATAACCESS authority
DBADM authority
SQLADM authority

The result of the function is a varying-length character string (VARCHAR) value with a length attribute of 1024.

Example:

Return the options to be used for the creation of SQL procedures as the result of a query.

   SELECT GET_ROUTINE_OPTS()
     FROM SYSIBM.SYSDUMMY1