SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

ManualsBrandsHP ManualsServerHP NonStop G-Series

621

622

623

624

625

626

627

628

629

630

SQLSTATE Values Returned by NonStop SQL/MX

HP NonStop SQL/MX Messages Manual—523730-004

20-57

SQLSTATE Values

42000 -3187 Not supported: SET STREAM TIMEOUT per a specific

stream.

42000 -3189 cannot set lock timeout on a view.

42000 -4001 Column name is not found. Tables in scope: name. Default

schema: name.

42000 -4002 Column name is not found. Table name not exposed. Tables in

scope: name. Default schema: name.

42000 -4003 Column name is not a column in table name, or, after a

NATURAL JOIN or JOIN USING, is no longer allowed to be

specified with a table correlation name.

42000 -4004 Column name name is ambiguous. Tables in scope: name.

Default schema: name.

42000 -4005 Column reference name must be a grouping column or be

specified within an aggregate.

42000 -4006 Within an aggregate, all column references must come from

the same scope.

42000 -4007 The select list index num is out of range. It must be between 1

and the number of select expressions, which in this case is

num.

42000 -4008 A subquery is not allowed inside an aggregate function.

42000 -4009 An aggregate is not allowed inside an aggregate function.

42000 -4010 There are no columns with the correlation name name.

42000 -4011 Ambiguous star column reference name.

42000 -4012 Column reference name must be a grouping column or be

specified within an aggregate. On this grouped table a star

reference is not allowed.

42000 -4013 Column name is a system column and cannot be updated or

inserted into.

42000 -4014 The operands of an INTERSECT must be of equal degree.