Deploying and running routines

You can deploy one or more routines from a Data Development project in the Data Project Explorer, from a database connection in the Database Explorer, or from a script file that was exported to the file system. After you deploy a routine, you can run it on the server.
Restriction: You can only deploy routines to like servers and to supported unlike servers from the Data Development project in the Data Project Explorer or from the Database Explorer. When you deploy from the file system, you can only deploy routines to like servers. The following database combinations for unlike servers are supported:
  • Derby to DB2® for Linux®, UNIX®, and Windows®
  • Derby to DB2 for z/OS®
  • DB2 for Linux, UNIX, and Windows to DB2 for z/OS

For Derby stored procedures in Java™, the Java source is not stored in the database catalog.

Parent topic: Creating database routines
Related concepts
Working with stored procedures
User-defined functions (UDFs)
Feedback