Replacing a SQLJ Procedure Definition

You can replace the SQL definition of a SQLJ procedure.

  1. In the left pane of the Administration Console, expand ASE Servers > Compiled Objects > Procedures > SQLJ Procedures.
  2. Choose one of the following:
    • Click the drop-down arrow on the SQLJ procedure for which you want to replace the definition and select Replace.
    • From SQLJ Procedures in the left pane, click the drop-down arrow and select New. Enter the name of the existing SQLJ procedure for which you want to replace the definition.

      When selecting an existing SQLJ procedure, the Confirm Replace dialog appears with an option to replace the object definition or cancel the replacement.

    The Replace SQLJ Procedure wizard appears.
  3. (Optional) On the External Name screen, enter a new Java class name.
  4. (Optional) On the SQL Properties screen, modify the SQL data such as setting the dynamic result sets option, and the deterministic option.
  5. (Optional) On the SQL Editor screen, enter any changes to the SQL description.
  6. (Optional) On the Summary screen, verify the procedure name, database, and owner.