SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-3
SQL 4012
Cause. A specified column number referring to the select list was either less than 1 or
greater than the number of columns in the select list.
Effect. The statement does not compile.
Recovery. Specify the correct column number for the column reference in the select
list.
SQL 4013
Cause. No DEFINE is present to map the specified logical name to a physical object
name.
Effect. If this message appears as a warning when compiling an SQL program, the
statement is left uncompiled. The program is still valid, however, and the logical name
is resolved at run time.
Recovery. Use the ADD DEFINE command to map the logical name to a physical
object name.
SQL 4017
Cause. The CREATE TABLE statement included the PRIMARY KEY clause for a table
with ENTRY SEQUENCED or RELATIVE organization. These kinds of tables have a
system-defined primary key, called SYSKEY.
Effect. The statement fails.
Recovery. To define a column or set of columns as a primary key, change the
organization to KEY SEQUENCED. If you want the organization to be ENTRY
SEQUENCED or RELATIVE, you must use the system-defined primary key; however,
you can create an index using the desired columns.
4012 Column number reference value-1 is out of range.
4013 Logical name value-1 could not be resolved.
4017 The KEY clause is allowed only for a key-sequenced
table.