Ansicht
Dokumentation

CPD32E1 - Distributed file error, reason code &6. ( OS/400 )

rdisp/max_wprun_time - Maximum work process run time   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by IBM.


Message : CPD32E1
Distributed file error, reason code &6.

Message Long Text :

Cause . . . . . : Distributed file &1 in library &2 can not be created, or the operation could not be completed because of an error. The field &3, is not valid for reason code &6. The reason codes and their meanings are as follows:
1 - The file format must match the distributed file.
2 - The file cannot have a LOB field.
3 - The file cannot have a DataLink field with FILE LINK CONTROL.
4 - The file cannot have an IDENTITY or ROWID field.
5 - The file cannot be created in a library that is located on an independent auxiliary storage pool.
6 - The SQL materialized query table and all of its based-on files must have the same distribution.
7 - The file cannot be a partitioned table.
Recovery . . . : Do one of the following based on the reason code shown, and then try the request again.
1 - Delete and recreate the file so its format matches the distributed file.
2 - Remove the LOB field from the file.
3 - Do not change file attributes that may distribute rows with DataLink fields to other nodes.
4 - Remove the IDENTITY field from the file.
5 - Create the file in a library that is not located on an independent auxiliary storage pool.
6 - Either create the SQL materialized query table on the local system or ensure that the materialized query table and all of its based-on files have the same distribution.
7 - Do not create the file as a partitioned table.
Technical description . . . . . . . . : &3

Message File : QCPFMSG
Library Message File : QSYS2924


TXBHW - Original Tax Base Amount in Local Currency   PERFORM Short Reference  
This documentation is copyright by IBM.

Length: 3251 Date: 20240427 Time: 065106     sap01-206 ( 2 ms )