Previous Topic: -157 - TTM INIT. FAILED. SQL CODE xxx, DB RC yy(zzz).Next Topic: -159 - HOST VARIABLE INCOMPATIBLE WITH COLUMN AT POSITION aaaa

SQL Codes › SQL Return Codes -1 through -999 › -158 - CANNOT CREATE SYNONYM FOR INVALID VIEW aaaa

-158 - CANNOT CREATE SYNONYM FOR INVALID VIEW aaaa

Reason:

You attempted to create a synonym on a view that has been marked invalid.

The SQLSTATE that equates to this SQL return code is 55S05.

Action:

First, determine why the view is invalid. Next, drop the view and re-create so that it is valid.