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.

Read syntax diagramSkip visual syntax diagramGET_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.

Information returned

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