Several system stored procedures can provide information about SQLJ routines:
sp_depends lists database objects referenced by the SQLJ routine and database objects that reference the SQLJ routine.
sp_help lists each parameter name, type, length, precision, scale, parameter order, parameter mode and return type of the SQLJ routine.
sp_helpjava lists information about Java classes and JARs installed in the database. The depends parameter lists dependencies of specified classes that are named in the external name clause of the SQLJ create function or SQLJ create procedure statement.
sp_helprotect reports the permissions of SQLJ stored procedures and SQLJ functions.
See the Adaptive Server Reference Manual for complete syntax and usage information for these system procedures.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
