Ansicht
Dokumentation

SQL0270 - Function not allowed for table &1 in &2. ( OS/400 )

PERFORM Short Reference   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by IBM.


Message : SQL0270
Function not allowed for table &1 in &2.

Message Long Text :

Cause . . . . . : Table &1 in &2 is a distributed table or a partitioned table. The function is not allowed for one of the following reasons:
- The unique index or unique constraint is not allowed because all unique indexes or unique constraints of a distributed table or a partitioned table must contain all columns that make up the partitioning key. If this is a CREATE TABLE statement and the PARTITIONING KEY clause was not specified, then the default partitioning key is the first column of the primary key, or the first valid column of the table.
- Data in one of the partitioning key columns was changed by an UPDATE statement which would have forced the row to a different node.
- The table contains a LOB or XML column. LOB and XML columns are not allowed in a distributed table.
- The node group of the materialized query table is different than the node group of one or more tables referenced by the materialized query table.
Recovery . . . : Ensure that all unique indexes or unique constraints contain all the columns of the partitioning key. Ensure that data in the partitioning key columns is not changed, or is changed to a value that would reside on the same node. Ensure the table does not contain any LOB or XML columns. Ensure that the materialized query table references tables within the same node group.

Message File : QSQLMSG
Library Message File : QSYS2924


Addresses (Business Address Services)   General Data in Customer Master  
This documentation is copyright by IBM.

Length: 3230 Date: 20240425 Time: 084049     sap01-206 ( 3 ms )