Ansicht
Dokumentation

SQ20093 - Attempt to ALTER table &1 in &2 failed. Reason code &3. ( OS/400 )

SQ20093 - Attempt to ALTER table &1 in &2 failed. Reason code &3. ( OS/400 )

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   General Data in Customer Master  
This documentation is copyright by IBM.
SAP E-Book


Message : SQ20093
Attempt to ALTER table &1 in &2 failed. Reason code &3.

Message Long Text :

Cause . . . . . : The ALTER request involving a materialized query table cannot be completed. Reason codes and their meanings are:
2 -- The ALTER specified DROP MATERIALIZED QUERY or ALTER MATERIALIZED QUERY, but the specified table is not a materialized query table.
4 -- The table has one or more triggers defined.
8 -- The table is referenced in the definition of another materialized query table.
9 -- The table is referenced directly or indirectly (such as through a view) in the SELECT statement.
10 -- The ALTER specified ADD MATERIALIZED QUERY, but the specified table is already a materialized query table.
11 -- The number of columns in the existing table does not match the number of columns for the result of the SELECT statement.
12 -- Column data types in the existing table do not match the column data types for the result of the SELECT statement.
16 -- The ALTER specified ADD MATERIALIZED QUERY, but the specified table has more than one member.
Recovery . . . : Change the ALTER statement, specify a different table, or change the SELECT statement to specify different result columns. Try the request again.

Message File : QSQLMSG
Library Message File : QSYS2924


ROGBILLS - Synchronize billing plans   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by IBM.

Length: 3254 Date: 20240328 Time: 165954     sap01-206 ( 3 ms )