Ansicht
Dokumentation

QMR1802 - Query data is not compatible with specified output table. ( OS/400 )

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.


Message : QMR1802
Query data is not compatible with specified output table.

Message Long Text :

Cause . . . . . : The data resulting from the query you just ran is not compatible with output table &2 in collection &1 due to reason &3:
1. The number of columns in the query data is not equal to the
number of columns in the output table.
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 UCS2 CCSID.
Recovery . . . : Change the specified output table, or run another query that results in data that is compatible with the table to be replaced.
Technical description . . . . . . . . : The SAVE DATA AS 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 AS 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 column 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 UCS2 CCSID, the corresponding column in the table or view must be GRAPHIC with a UCS2 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 : QSQLMSG
Library Message File : QSYS2924


PERFORM Short Reference   Addresses (Business Address Services)  
This documentation is copyright by IBM.

Length: 3265 Date: 20240424 Time: 222132     sap01-206 ( 3 ms )