Manage SQLJ Procedures

Create, delete, modify , and administer SQLJ procedures.

SQLJ procedures are named collections of SQLJ statements and flow control statements. A stored procedure that performs a select, execute, or data modification command must have the same owner as the object acted upon.

A system administrator, a database owner, or a user or group with create procedure permission can create a stored procedure.

• Creating a SQLJ Procedure
  Create a SQLJ procedure by adding a SQL wrapper to a Java static method..
• Replacing a SQLJ Procedure Definition
  You can replace the SQL definition of a SQLJ procedure.
• SQLJ Procedure Properties
  Use the SQLJ procedure Properties window to access and modify SQLJ procedures.
• Deleting a SQLJ Procedure
  Use SAP Control Center to delete SQLJ procedures.
• Generating DDL for a SQLJ Procedure
  Use SAP Control Center to generate a DDL script for SQLJ procedures.