Ansicht
Dokumentation

SQL0255 - Function not supported for query. ( OS/400 )

RFUMSV00 - Advance Return for Tax on Sales/Purchases   General Data in Customer Master  
This documentation is copyright by IBM.


Message : SQL0255
Function not supported for query.

Message Long Text :

Cause . . . . . : The reason code is &1:
-- Code 1 -- Scalar subselects and lateral correlation from a nested table expression are not allowed with distributed files.
-- Code 2 -- Error occurred while using a temporary distributed file.
-- Code 3 -- EXCEPT or INTERSECT not supported for this query.
-- Code 4 -- A sequence reference is not supported with distributed files.
-- Code 5 -- A recursive common table expression is not supported for this query.
-- Code 6 -- An OLAP function is not supported for this query.
-- Code 7 -- ORDER OF is not supported for this query.
-- Code 8 -- Scalar fullselect is not supported for this query.
-- Code 9 -- A distributed file is being processed in a multi-thread capable job or this is not the initial thread.
-- Code 10 -- Grouping sets are not supported for this query.
-- Code 11 -- Full outer join is not supported for this query.
-- Code 12 -- VALUES fullselect is not supported for this query.
-- Code 13 -- UTF-8 with non-ICU NLSS table is not supported for this query.
-- Code 14 -- OmniFind function is not supported for this query.
-- Code 15 -- Subselect ordering is not supported for this query.
-- Code 16 -- XML function is not supported for this query.
-- Code 17 -- Array variables are not supported for this query.
-- Code 18 -- Global variables are not supported for this query.
Recovery . . . : A list of corrective actions follow:
-- If code 1, change the query so it does not use scalar subselects or correlation from a nested table expression.
-- If code 2, see the previous messages for more information.
-- If code 3, remove EXCEPT or INTERSECT from the query.
-- If code 4, remove the sequence reference from the query.
-- If code 5, remove the recursive common table expression from the query.
-- If code 6, remove the OLAP function from the query.
-- If code 7, remove the ORDER OF from the query.
-- If code 8, respecify the query without a fullselect.
-- If code 9, do not use multiple threads to run the query.
-- If code 10, remove grouping sets from the query.
-- If code 11, remove the full outer join from the query.
-- If code 12, remove the VALUES fullselect from the query.
-- If code 13, use an ICU NLSS table or remove the reference to the UTF-8 column or variable.
-- If code 14, remove the OmniFind function from the query.
-- If code 15, remove the subselect ordering from the query.
-- If code 16, remove the XML function from the query.
-- If code 17, remove references to array variables from the query.

Message File : QSQLMSG
Library Message File : QSYS2924


TXBHW - Original Tax Base Amount in Local Currency   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.

Length: 3285 Date: 20240426 Time: 161959     sap01-206 ( 3 ms )