In this blog post, let’s learn about the error message “1127 The specified table table-name is not a base table. Please verify that the correct table was specified.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1127 The specified table table-name is not a base table. Please verify that the correct table was specified.
Reason for the Error
You attempted to perform an operation that can be performed only on a base table, and the specified object is not a base table.
Solution
Specify a valid base table and resubmit