Neoview Database Administrator's Guide (R2.2)

6. DB Admin prompts you to confirm that you want to alter the synonym. When you click
Yes, it attempts to alter the synonym and either displays an error or indicates that the alter
was successful and displays its information.
For additional information, see DB Admin online help.
Dropping (Deleting) Synonyms
1. Start DB Admin and log on using the user ID that created the synonym or log on as a user
authorized to change that synonym.
2. Click the Database tab, then expand the name of the schema in which the synonym is located
to display its synonyms in the left pane.
3. Expand the Synonyms folder in the left pane.
4. Right-click the synonym name and then select Drop.
5. DB Admin prompts you to confirm the drop. When you click Yes, it drops the synonym.
For additional information, see DB Admin online help.
Stored Procedures in Java (SPJs)
A stored procedure is a type of user-defined routine (UDR) that operates within a database
server. Starting in Neoview Release 2.2, the Neoview database supports stored procedures in
Java (SPJs). For details about creating and managing SPJs, see the Neoview Guide to Stored Procedures
in Java.
Displaying Stored Procedures
To display stored procedures in Java (SPJs):
1. Start DB Admin and log on using any user ID.
2. Click the Database tab, then navigate to the schema and click the Procedure link in the right
pane, or open the Procedures folder. DB Admin displays the procedures in this schema:
74 Managing Database Objects