ODBC Server Reference Manual

Stored Procedures
HP NonStop ODBC Server Reference Manual—429151-002
5-59
Sharing Procedures
Because there is so much similarity between the TSQL-mode and the CORE-mode
stored procedure models and because both kinds of procedures are implemented in
server class processes, it is possible for any client to execute any procedure. For clean
sharing of procedures, the following guidelines are suggested:
•
Use procedure names that are valid names for both Transact-SQL and CORE
SQL. That is, use procedure names that are valid CORE SQL names, do not
exceed 30 characters in length, and do not have a “;number” suffix.
•
Use parameter names that are valid names for both Transact-SQL and CORE
SQL. That is, use parameter names that are valid CORE SQL names and do not
exceed 30 characters in length.
•
Use Parameter data types that are legal for both Transact-SQL and CORE SQL.
•
Do not instruct the procedure to return output parameters; CORE SQL does not
support output parameters. Return all information through result sets.