Creating a SQLJ Procedure

Create a SQLJ procedure using the Sybase Control Center Administration Console.

1. In the left pane of the Administration Console, expand ASE Servers > Compiled Objects > Procedures, then select Stored Procedures.
2. Click the drop-down arrow and select New.
   You see the Create SQLJ Procedure wizard.
3. On the Introduction screen, select the server, database, and owner of the new procedure.
4. Enter the name of the procedure.
5. Specify the external name, which identifies the Java method, class, and an optional package name.
6. On the SQL Properties screen, select:
   • Modifies SQL data – indicate that the Java method invokes SQL operations and modifies SQL data in the database.
   • Dynamic result set – set the number of rows returned. The default number of returned rows is 1.
   • Deterministic option – include the keywords deterministic or not deterministic for compatibility with the SQLJ standard. However, Adaptive Server does not make use of this option.
7. On the SQL Editor screen, provide the SQL statements for the procedure. Ensure that all objects referenced by the procedure exist in the database.
8. (Optional) Click Preview to see the SQL statements for your command.
9. (Optional) Click Summary to verify your selected options.