SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-11
Reserved Words
Reserved Words
Table R-5 lists words that are reserved for NonStop SQL/MP. You cannot use these
words as names of constraints, columns (including correlation names), cursors, or
statements, but you can use these words in catalog names; in Guardian names that
identify tables, indexes, views, partitions, and collations; and in host variable names.
NEED Number of lines to keep together on page
PAGE Advance to the next page and optionally start a new page-number
sequence
SKIP Number of lines before next item
SPACE Number of blanks between items
TAB Position of the next item on a line
Table R-4. Report Writer Functions
Function What the Function Returns
COMPUTE_TIMESTAMP Timestamp for specified date and time
CURRENT_TIMESTAMP Timestamp for current date and time
LINE_NUMBER Current line number within a break group, page, or report
PAGE_NUMBER Current page number
Table R-5. Reserved Words (page1of2)
ALL CURSOR IN NOT TABLE
AND INNER NULL TO
ANY DEC INPUT NUMERIC
AS DECIMAL INSERT UNIQUE
ASC DECLARE INT OF UPDATE
AVG DELETE INTEGER OPEN
DESC INTO OPTION VALUES
BEGIN DISTINCT IS OR VIEW
BETWEEN ORDER
BY ESCAPE JOIN WHERE
EXISTS RIGHT WITH
CATALOG KEY ROLLBACK WORK
CHAR FETCH
CHARACTER FOR LEFT SAMPLE
Table R-3. Report Writer Clauses (page2of2)
Clause What the Clause Specifies