DB2 and Derby stored procedures

You can use the workbench to create, test, and deploy DB2® or Derby stored procedures. You can also debug SQL stored procedures.

Stored procedures contain procedural constructs with SQL statements. Stored procedures are stored in databases and run on servers. An application can call a stored procedure by name and run the SQL statements that are included in the stored procedure. The application can be on the client, while the stored procedure executes its logic on the server. Stored procedures and user-defined functions are sometimes referred to collectively as routines.

Related concepts
Importing and exporting routines
Related tasks
Deploying and running routines
Related information
Cambiar opciones predeterminadas para el desarrollo de procedimientos almacenados y UDF

Comentarios