ODBC Server Reference Manual

Glossary

HP NonStop ODBC Server Reference Manual—429151-002

Glossary-10

pass-through mode [NonStop ODBC Server]

pass-through mode [NonStop ODBC Server]. A mode the NonStop ODBC Server provides

for executing statements other than TRANSACT-SQL statements. Pass-through mode

allows NonStop SQL/MP statements, catalog utility statements, and trace statements.

procedure [SQL Server]. See stored procedure [both ODBC and SQL Server] or system

procedures [SQL Server].

profile table [NonStop ODBC Server]. A NonStop ODBC Server mapping table, ZNSPROF,

used with the trace feature. The profile table records all log table names, trace flag

values, override trace values, and default trace values.

See also NonStop ODBC Server mapping tables [NonStop ODBC Server] and trace

feature [NonStop ODBC Server].

protection view [NonStop SQL/MP]. A view defined with the protection attribute. The view

can be derived from a single table by taking either a projection of the columns of the

table, a selection of the rows in the table, or both. A protection view provides a form of

field level security because the view can be secured, updated, and read.

See also shorthand view [NonStop SQL/MP].

repeatable access [NonStop SQL/MP]. The access option for transaction consistency that

guarantees that the data you access within a transaction cannot be changed by other

users until the transaction ends. With this access, a process tests for existing locks on

data before acquiring its own lock and holds the lock until the transaction completes.

Of the NonStop SQL/MP access options, this access provides the highest consistency

but the lowest concurrency.

See also browse access [NonStop SQL/MP] and stable access [NonStop SQL/MP].

row aggregate function [SQL Server]. A function that generates a new row for summary

data when used with the COMPUTE BY clause in a SELECT statement. The SQL

Server row aggregate functions are SUM, AVG, MIN, MAX, and COUNT.

The NonStop ODBC Server does not support the COMPUTE BY clause or row

aggregate functions.

See also aggregate function [standard SQL].

rule [SQL Server]. A specification that controls what data can be entered into a particular

column.

The NonStop ODBC Server does not support rules.