SQL/MP Messages Manual

SQL Catalog Manager Messages (1000 to 1999)
HP NonStop SQL/MP Messages Manual—427720-006
3-56
SQL 1363
Cause. Stated in the error message.
Effect. The statement fails.
Recovery. Correct the FIRST KEY value.
SQL 1364
Cause. The view definition would not fit in the file label.
Effect. The statement fails.
Recovery. Change the selection expression. Consider using short correlation names
in the expression, or create two protection views and join them with a shorthand view.
SQL 1365
Cause. The selection expression does not meet the requirements for a protection
view. These requirements are the following:
•
The FROM clause can refer to only one underlying table.
•
The WHERE clause can refer only to columns that appear in its select list.
•
The statement cannot have subqueries, the keyword DISTINCT, or any of the
following clauses: GROUP BY, HAVING, or ORDER BY.
•
The select list cannot have expressions or functions.
•
The select list cannot refer to duplicate column names.
Effect. The statement fails.
Recovery. For more information, refer to the CREATE VIEW statement description in
the SQL/MP Reference Manual. Correct the selection expression and reissue the
statement.
1363 You attempted to add a partition and the FIRST KEY value
is already the FIRST KEY of another partition.
1364 The selection expression in the protection view
definition is too large.
1365 The selection expression in the protection view
definition is invalid.