Sybase Adaptive Server Anywhere - Adaptive Server Enterprise System and Catalog Procedures

Adaptive Server Enterprise system and catalog procedures
988
Adaptive Server Enterprise system and catalog
procedures
Adaptive Server Enterprise provides system and catalog procedures to carry
out many administrative functions and to obtain system information.
Adaptive Server Anywhere has implemented support for some of these
procedures.
System procedures are built-in stored procedures used for getting reports
from and updating system tables. Catalog stored procedures retrieve
information from the system tables in tabular form.
Adaptive Server Enterprise system procedures
The following list describes the Adaptive Server Enterprise system
procedures that are provided in Adaptive Server Anywhere.
While these procedures perform the same functions as they do in Adaptive
Server Enterprise and pre-Version 12 Adaptive Server IQ, they are not
identical. If you have preexisting scripts that use these procedures, you may
want to examine the procedures. To see the text of a stored procedure, you
can open it in Sybase Central or, in Interactive SQL, run the following
command.
sp_helptext procedure_name
You may need to reset the width of your Interactive SQL output to see the
full text, by selecting Command➤Options and entering a new Limit Display
Columns value.
System procedure Description
sp_addgroup group-name
Adds a group to a database
sp_addlogin userid,
password[, defdb [,
deflanguage [, fullname]]]
Adds a new user account to a database
sp_addmessage message-
num, message_text [,
language]
Adds a user-defined message to
SYSUSERMESSAGES, for use by stored
procedure PRINT and RAISERROR calls
sp_addtype typename, data-
type [, "identity" | nulltype]
Creates a user-defined data type
sp_adduser login_name [,
name_in_db [, grpname]]
Adds a new user to a database
sp_changegroup new-group-
name, userid
Changes a user’s group or adds a user to a group