SQL/MP Messages Manual

SQL Compiler Parser Messages (3000 to 3999)
HP NonStop SQL/MP Messages Manual—427720-006
5-26
SQL 3104
Cause. You specified both a PRIMARY KEY and a CLUSTERING KEY clause in the
CREATE TABLE statement.
Effect. The statement fails.
Recovery. Specify either a PRIMARY KEY clause or a CLUSTERING KEY clause in
the CREATE TABLE statement; determine which key is appropriate for the table and
remove the other clause. Reissue the statement.
SQL 3105
Cause. You specified an ORDER BY clause with a subquery.
Effect. The statement fails.
Recovery. Remove the ORDER BY clause from the subquery, and reissue the
statement.
SQL 3106
Cause. You used a parameter name in two different contexts within the same
statement: perhaps as two different data types, or with and without an indicator, or with
two different indicators.
Effect. The statement fails.
Recovery. Use the parameter name consistently.
SQL 3107
Cause. You specified a CURRENT value for a column with a data type other than
DATETIME. CURRENT can only be specified with columns that have a DATETIME
data type.
Effect. The statement fails.
Recovery. Specify CURRENT only with a DATETIME data type.
3104 A CLUSTERING KEY clause and a PRIMARY KEY clause cannot
appear in the same CREATE TABLE statement.
3105 The ORDER BY clause cannot be specified with a subquery.
3106 Parameter name is used in two different contexts.
3107 The default value CURRENT can be specified only for the
DATETIME data type.