Ansicht
Dokumentation

QWM1802 - Object format not compatible with query data. ( OS/400 )

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


Message : QWM1802
Object format not compatible with query data.

Message Long Text :

Cause . . . . . : The data resulting from a previous RUN QUERY command is not compatible with object &2 in library &1 due to reason number &3.
The possible reasons are:
1) The number of columns in the query data
is not equal to the number of columns in
the object.
2) A column length is not compatible.
3) A data type is not compatible.
4) A column has incompatible null attributes.
5) A column has an incompatible GRAPHIC UCS-2 CCSID.
Recovery . . . :
Change the table or view specified on the SAVE DATA command or run another query which results in data that is compatible with the table or view to be replaced.
Technical description . . . . . . . . :
The SAVE DATA command cannot complete because the table or view to be replaced does not have the same format as the data from the previous RUN QUERY command. The following rules must be followed when replacing data in a table or view using the SAVE DATA command.
The number of columns in the query data must be the same as the number of columns in the table or view.
The data type of the columns from the query data must be compatible with the data types defined for the corresponding columns in the table or view.
If the column in the query data is a number, the corresponding column in the table or view must be a number with the capacity to represent the integral part of the query data. If the column in the query data is a string, the column in the table or view must be a string column with a length attribute at least as great as the length of the query data.
If the column in the query data contains a NULL value, the corresponding column in the table or view must be null capable.
If the data type of the column in the query data is GRAPHIC with a UCS-2 CCSID, the corresponding column in the table or view must be GRAPHIC with a UCS-2 CCSID.
If the data type of the column in the query data is GRAPHIC with a DBCS CCSID, the corresponding column in the table or view must be GRAPHIC with a DBCS CCSID.

Message File : QCPFMSG
Library Message File : QSYS2924


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

Length: 3261 Date: 20240416 Time: 214624     sap01-206 ( 3 ms )