HPE NonStop SQL/MX Error – 21054 Index target-index has no matching index from table source-table.

Data 19 Views 1 Min Read

In this blog post, let’s learn about the error message “21054 Index target-index has no matching index from table source-table.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

21054 Index target-index has no matching index from table source-table.

Reason for the Error

An initial FASTCOPY command is executed and no index on the source table matches the target-index . Two indexes match when all the following conditions are satisfied:

indexes have the same number of index columns

each source-target pair of index columns, in key sequence order, have the same column number in the tables

Solution

None

Tags: