DB2 Version 10.1 for Linux, UNIX, and Windows

GET_ROUTINE_OPTS scalar function

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.


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

The schema is SYSPROC.

Authorization

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

EXECUTE privilege on the function
DATAACCESS authority
DBADM authority
SQLADM authority

Default PUBLIC privilege

In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the function is automatically created.

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