Manage SQLJ Procedures

Create, delete, modify , and administer SQLJ procedures using the Sybase Control Center Administration Console.

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 using the Sybase Control Center Administration Console.
• SQLJ Procedure Properties
  Use the SQLJ procedure Properties wizard to access and modify information on SQLJ procedures.
• Generating a DDL Script
  Use Sybase Control Center to generate DDL to create a database or any of its objects.
• Deleting a SQLJ Procedure
  Sybase Control Center helps you delete database objects, or the database itself.