X400 - X449

Lists the Engine error messages from X400 through X449.

Restriction: This topic applies to Windows environments only.

X400 Named cursor already assigned to a result set locator.
The named cursor could not be reused.
X401 Statement can't be issued until the stored procedure has been called.
Either a DESCRIBE PROCEDURE or an ASSOCIATE LOCATOR statement has been executed prior to the CALL to the stored procedure.
X402 Invalid result set locator.
The result set locator was never assigned a valid value. Result set locators are returned by the ASSOCIATE LOCATORS statement.
X403 Cursor name CursorName was not defined.
The named cursor was not defined.
X404 A Rollback is required.
The transaction is in a must rollback state.
X405 An ON clause in a JOIN operator is invalid.
An ON clause used to specify a JOIN condition is invalid. VALUE/COALESCE functions are only allowed in FULL OUTER JOINs. Only an '=' operator is valid in FULL OUTER JOINs. Also, column may be inappropriately referenced from within the JOIN clause.
X406 Stored procedure StoredProcName parameter ParameterName is larger than declared.
The stored procedure has used a value that is too large for the definition declared in the SYSIBM.SYSPROCEDURES PARMLIST field.
X407 Stored procedure StoredProcName requires a host variable for parameter ParameterName.
The parameter in the stored procedure PARMLIST definition in SYSIBM.SYSPROCEDURES is defined as OUT or INOUT. A host variable must be supplied in the call for that parameter.
X408 Stored procedure StoredProcName did not return result sets.
The stored procedure has not returned any results sets to the caller. Verify that the stored procedure has been coded correctly.
X409: Error in trigger trigger-name, section number trigger-section
A trigger trigger-name executed during an INSERT, UPDATE, or DELETE statement contained an SQL statement that returned an SQL error. The section number trigger-section identifies the statement in error.
X410: Function function-name named without signature, function not unique
The signature of the user defined function function-name is not unique within its schema. Either the CURRENT PATH must be changed or the SPECIFIC name of the function must be used.
X411: Signature for function function-name not unique within schema
The function function-name that is being created does not have a unique signature within the schema.
X412: Set transition variable is used for before trigger per row only
SET transition-variable can only be used within a before trigger whose granularity is FOR EACH ROW.
X413: Invalid insert into column %s defined as generated always
No input value is allowed for a column defined as GENERATED ALWAYS.
X414: Internal error, identity column definition not found
An internal error has occurred. The identity column definition could not be found.
X415: Only one rowid or identity column is allowed in a table
A table contains more than one row ID or identity column. This is not allowed.

Parent topic: X - Engine Error Messages