SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-20
SQL 4073
Cause. The creation time for this table in your catalog does not agree with the creation
time noted in the file label. This problem could be the result of a TMF rollforward
recovery operation performed on this table. Do not perform any SQL operations on this
table now.
Effect. The statement does not compile.
Recovery. None. Report the entire message to your service provider.
SQL 4074
Cause. When the Binder program tried to parse the view text, a syntax error was
detected. For example, if the view text contained a UNION or JOIN operator and the
view was accessed from a node running a C10 version of SQL/MP, this error is
returned. You can look in the VIEWS table to see what the invalid view definition is.
The view definition in the VIEWS table is parsed once and must be syntactically
correct. If an earlier version of the compiler than the one that originally stored the view
text in the VIEWS table is used, view text will not parse without error if it contains any
new features.
Effect. The statement does not compile.
Recovery. Correct the syntax error.
SQL 4082
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Correct the LIKE predicate.
4073 An inconsistency in the creation time of an audited
table was detected.
4074 Syntax error occurred during parsing of the view text.
4082 The right side of a LIKE predicate cannot contain a
column name.