Ansicht
Dokumentation

SQL0150 - View or logical file &1 in &2 read-only. ( OS/400 )

SQL0150 - View or logical file &1 in &2 read-only. ( OS/400 )

ROGBILLS - Synchronize billing plans   CPI1466 during Backup  
This documentation is copyright by IBM.
SAP E-Book


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 )