SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
L-14
LINE_NUMBER Function
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.
You can use LINE_NUMBER in any report writer command with a print list, but SQL
calculates the function value for detail lines only (not title or footing lines, for example),
so it is generally useful only in DETAIL commands.
OVER REPORT
determines the line number by setting a count of 0 at the beginning of the report
and incrementing the number by 1 at the start of each detail line.
OVER PAGE
determines the line number by setting a count of 0 at the beginning of each page
and incrementing the number by 1 at the start of each detail line. (A detail line is a
logical output line specified by the print list on a DETAIL command; it might consist
of more than one physical line.)
OVER break-column
determines the line number by setting a count of 0 when the value of the specified
break column changes and incrementing the number by 1 at the start of each detail
line in the group. break column is a column name, alias, detail alias, or COL
number that identifies a column named in a BREAK ON command.
[ OVER REPORT ]
LINE_NUMBER [ OVER PAGE ]
[ OVER break-column ]
The default is OVER REPORT.