Neoview Messages Manual (R2.2)

Effect The statement does not compile.
Recovery Do not use ORDER BY with an embedded INSERT, UPDATE, or DELETE statement.
SQL 4190
4190 Table table-name is not a volatile table.
table-name
is the user-specified table name in the statement.
Cause The volatile table name specified in the VOLATILE TABLE SQL statement does not
exist.
Effect None.
Recovery Ensure that the volatile table with the specified table-name is created before
issuing the SQL statement.
SQL 4191
4191 Username schema-name specified as part of the volatile table or
index must be the same as the current username, user-name.
schema-name
is the user-specified schema name in the SQL statement.
user-name
is the current default SQL user name.
Cause The schema name specified in the volatile table command does not match the current
default SQL user name.
Effect None.
Recovery Ensure that schema-name matches the current default SQL user name and reissue
the SQL statement.
SQL 4192
4192 An invalid volatile object name was specified.
Cause The table name specified in the VOLATILE TABLE SQL statement should be either
a two-part name or single-part name.
Effect None.
Recovery Change the table name in the command to be either a single-part name or two-part
name and reissue the SQL statement.
SQL 4193
4193 The schema name prefix volatile-schema-prefix is reserved and
cannot be used.
volatile-schema-prefix
is a reserved schema prefix used internally to manage
volatile tables.
Cause The volatile schema managed by the system uses a reserved schema prefix. This
prefix is a reserved word and cannot be used in an SQL statement.
Effect None.
Recovery Change the schema name provided as part of the two-part name to anything other
than volatile-schema-prefix and reissue the SQL statement.
SQL 4194
4194 Table table-name is a volatile table and not allowed within this
sql statement.
table-name
is the user-specified table name in the statement.
Cause The table name specified is a volatile table that is not allowed in this SQL statement.
152 Binder and Compilation Messages (4000 Through 4999)