Previous Topic: -18 - WITH CHECK OPTION IS NOT ALLOWED ON NON-UPDATABLE VIEWSNext Topic: -20 - BAD SYNTAX: description WHEN THE ERROR OCCURRED, THE SYNTAX BELOW HAD BEEN PARSED: statement


-19 - INDEX AND TABLE AUTHIDS DO NOT MATCH: aaaa, bbbb

Reason:

In a CREATE INDEX statement, the authorization ID specified for the index does not match the authorization ID of the table to be indexed.

The SQLSTATE that equates to this SQL return code is 53S02.

Action:

Give the index the same authorization ID as the table.