NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
L-12
LINE_NUMBER Function
The maximum possible number of tables in a database, if enough memory is
available, is 32,767. Only 16 of these tables can be referred to in any given query.
•
Temporary file size
The size of a temporary file is limited to the space available on the disk on which
the file resides. Temporary files provide space for sort operations required for some
queries, for creating indexes, for splitting partitions, and for loading tables.
•
Transactions per table
The limit on the number of TMF transactions or update transactions that can be
active on a given SQL table is the same as the limit on the number of transactions
that can be active in your NonStop system. That number is configurable and
depends on the TRANSPERCPU attribute of the BEGINTRANS object of TMF. For
more information, see the description of the ALTER BEGINTRANS command in
the NonStop TM/MP Reference Manual.
•
User-defined primary key length
The sum of the column lengths for the columns of the key cannot exceed 255 bytes.
•
User process sort
No more than 32,767 rows may be sorted.
•
View definition
The CREATE VIEW statement, including any name expansion from the use of
asterisks in column, view, and table specifications, can have a maximum of 3,000
bytes.
•
Views per table
Approximately 180 protection views can be defined for a table. The limit is
determined by the requirement that a small amount of information about each
protection view defined on a table must fit in a file label.
There is no maximum number of shorthand views for a table.
LINE_NUMBER Function
LINE_NUMBER is an SQLCI report writer function that returns the line number of the
current detail line. LINE_NUMBER is useful for numbering detail lines in a report.