ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-17
Stored Procedures
For detailed information on supported statements, see Section 4, Transact-SQL
Language.
Stored Procedures
The NonStop ODBC Server supports the execution of stored procedures, using the
EXECUTE statement, including the use of parameters supplied to the stored
procedures at the time of invocation. Stored procedures cannot be created using
Transact-SQL, however, but must be created in the Pathway environment.
System Procedures
The NonStop ODBC Server does not support SQL Server system procedures.
Table B-6 lists the system procedures and, where possible, offers alternatives to using
system procedures. Note that you can execute a NonStop SQL/MP statement by using
pass-through mode with the NonStop ODBC Server.
WAITFOR – –
WHILE – –
WRITETEXT – –
Table B-6. SQL Server System Procedures (page 1 of 3)
System Procedure
Alternatives Available Using NonStop SQL/MP or the HP
NonStop Kernel Operating System
sp_addalias You can add alias usernames with the ADDNAME ALIAS statement.
sp_addgroup None. Groups are not supported and are not available in NonStop
SQL/MP.
sp_addlogin Must be done by a Guardian administrator. Anyone with a Guardian
login can access the NonStop ODBC Server and NonStop SQL/MP.
sp_addtype None
sp_addumpdevice None
sp_adduser You can add logical usernames with the ADDNAME USER statement.
A logical username must correspond to a Guardian logon ID.
sp_bindefault Use the DEFAULT keyword on CREATE TABLE or ALTER TABLE.
sp_bindrule Use CREATE CONSTRAINT.
Table B-5. NonStop ODBC Server Support of Transact-SQL
Statements (page 7 of 7)
Transact-SQL
Statement
NonStop ODBC
Server Support Comments
x Indicates that the statement is supported
– Indicates that the statement is not supported