ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-19
System Procedures
For information on pass-through mode, see Section 6, Using Pass-Through Mode.
sp_helpprotect Use Guardian commands to view file security.
sp_helpsql You can use SQLCI to get help on NonStop SQL/MP statements. You
must use SQLCI interactively, however; you cannot get help using the
NonStop ODBC Server.
sp_helptext You can see the text of a view by selecting against the NonStop
SQL/MP catalog tables.
sp_helpuser None
sp_lock You can display locks on an object or all objects in a subvolume using
FUP, but you cannot do it using NonStop SQL/MP.
sp_logdevice None
sp_monitor None
sp_password Must be done with Guardian commands.
sp_primarykey Use the NonStop SQL/MP CREATE TABLE statement.
sp_rename Use the NonStop SQL/MP ALTER TABLE, ALTER VIEW, or ALTER
INDEX statements. You must refresh the NonStop ODBC Server
mapping tables after renaming an object.
You cannot change a column name.
sp_renamedb None. You cannot rename a NonStop SQL/MP catalog.
sp_spaceused You can show the space used with the TACL FILEINFO statement.
You can find the number of rows in a table by using the SELECT
statement.
sp_unbindefault None. You cannot drop a default.
sp_unbindrule Use the NonStop SQL/MP DROP CONSTRAINT statement.
sp_who None
Table B-6. SQL Server System Procedures (page 3 of 3)
System Procedure
Alternatives Available Using NonStop SQL/MP or the HP
NonStop Kernel Operating System