SQL/MP Messages Manual

ManualsBrandsHP ManualsServerHP NonStop G-Series

231

232

233

234

235

236

237

238

239

240

SQL Compiler Binder Messages (4000 to 4999)

HP NonStop SQL/MP Messages Manual—427720-006

6-15

SQL 4054

Cause. A CREATE CONSTRAINT statement referred to the SYSKEY column in the

defining predicate. Because SYSKEY is a system-generated value, this constraint

would prevent normal insertions.

Effect. The statement fails.

Recovery. Use a placement option (APPEND or ANYWHERE) to control SYSKEY

values where appropriate. If the application requires a constraint on the value of the

primary key, re-create the table using a user-defined primary key instead.

SQL 4055

Cause. A CREATE TABLE statement did not specify a user-defined primary key and

named a user-defined column SYSKEY. SYSKEY became a duplicate column name

because SQL/MP also created a column named SYSKEY to be the system-defined

primary key.

Effect. The statement fails.

Recovery. Supply a different name for the user-defined column.

SQL 4056

Cause. The insertion was not allowed because the protection view was defined with a

query expression that included the system-defined primary key column (SYSKEY by

default) in the WHERE clause and was based on either a key-sequenced or entry-

sequenced table.

Because of the view definition, SQL/MP generated the system-defined key value but

could not ensure that the new value would be valid for the protection view. This

message can also be returned as a warning after a CREATE VIEW statement that

creates a protection view, if the view does not include all of the NO DEFAULT, NOT

NULL columns in the underlying table.

Effect. The statement does not compile.

Recovery. Correct the INSERT statement. If you want the system-defined key in the

WHERE clause, the INSERT operation must be on a relative table or on a protection

view based on a relative table, and the INSERT statement must provide a value for the

system-defined key column.

4054 A constraint definition cannot refer to SYSKEY.

4055 SYSKEY cannot be specified as a column name for a table

that creates a SYSKEY column.

4056 Characteristics of protection view value-1 prohibit

insertions.