ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-76
Example
•
OUTPUT variables are not part of a transaction, so if a parameter is changed in a
transaction that is rolled back, the parameter’s value does not revert to its previous
value.
•
If the data type of a parameter and its corresponding parameter definition in the
procedure declaration are not compatible, a data conversion error occurs. If data
conversion results in data truncation, a warning is issued. It is the responsibility of
the Pathway server class program to take the appropriate action.
Example
The following statement invokes a stored procedure named DEBIT_ACCOUNT:
exec debit_account (@name = "smith", @amount = 50.00)
The statement passes the name of the account to access and the amount to be
debited.
NonStop ODBC Server Compared With SQL Server
When used through the NonStop ODBC Server, EXECUTE operates in the same way
as it does with SQL Server.
NonStop ODBC Server Compared With NonStop SQL/MP
NonStop SQL/MP has no statement corresponding to EXECUTE.
Stored procedure execution is described in detail in Execution of Stored Procedures on
page 5-4.
INSERT
Use INSERT to add new rows to a table or a view.
The INSERT statement has the following syntax:
table-name
identifies the table into which the rows are inserted; table-name can be qualified
with the database name and owner name.
INSERT [ INTO ] [ [database.]owner. ] { table-name }
{ view-name) }
[ ( column-name [, column-name] ... ) ]
{ VALUES ( constant-expr [, constant-expr ] ... ) }
{ select-statement }