Ansicht
Dokumentation
SQL0150 - View or logical file &1 in &2 read-only. ( OS/400 )
ROGBILLS - Synchronize billing plans CPI1466 during BackupThis documentation is copyright by IBM.
Message : SQL0150
View or logical file &1 in &2 read-only.
Message Long Text :
Cause . . . . . : Update, delete, insert, or merge is not allowed. &1 in &2 can be used only for read operations.
A view or logical file can be used only for read operations if one or more of the following conditions are true:
-- The view contains a DISTINCT keyword, GROUP BY clause, HAVING clause, or an aggregate function in the outer fullselect.
-- The view or logical file references more than one table in the outer fullselect.
-- The view contains a subquery that refers to the same table as the table of the outer fullselect. A view of this type may be used for inserting rows.
-- The view contains UNION, EXCEPT, or INTERSECT in the outer fullselect.
-- All the columns of the view are expressions, constants, or special registers.
-- All the columns of the logical file are input only.
-- The select list of the view omits a column of the based on table that does not allow null values or default values. Inserting into the view is not allowed.
Recovery . . . : Change the statement to insert, delete, update, or merge data into the base table of view &1. All columns of the table that do not allow null values or default values must be assigned a value when inserting a row into a table or view unless an INSTEAD OF trigger is defined for the view. Try the request again.
Message File : QSQLMSG
Library Message File : QSYS2924
CPI1466 during Backup General Data in Customer Master
This documentation is copyright by IBM.
Length: 3238 Date: 20240329 Time: 082505 sap01-206 ( 2 ms )