Show TOC

DBPROCEDURESLocate this document in the navigation structure

Use

Use of the system table DOMAIN. DBPROCEDURES

Prerequisites

You can use the demo data for the SQL tutorial. Start the Database Studio as database administrator MONA with the password RED and log on to demo database DEMODB: Logging On to a Database.

Create database procedures. Proceed as described in SQL Tutorial, Database Procedures.

Activities

You can use Database Studio to enter and execute SQL statements. More information: Working with SQL Statements: Overview

Note the General Instructions for formulating SQL statements.

You can use the system table DBPROCEDURES to determine the following database information, among other things:

  • All database procedures of the HOTEL schema and their comments that were created in the last 10 days

    SELECT schemaname, dbprocname, comment

    FROM DOMAIN.DBPROCEDURES

    WHERE schemaname = 'HOTEL' AND createdate >= subdate(date,10)

  • All database procedures of the SYSLOADER schema and their definition

    SELECT schemaname, dbprocname, definition

    FROM DOMAIN.DBPROCEDURES

    WHERE schemaname = 'SYSLOADER'

More Information

Parameters for a database procedure: See DBPROCPARAMS