We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

QRY1737 - Function selected for &7 may require character substitution. ( OS/400 )

QRY1737 - Function selected for &7 may require character substitution. ( OS/400 )

ROGBILLS - Synchronize billing plans   PERFORM Short Reference  
This documentation is copyright by IBM.
SAP E-Book


Message : QRY1737
Function selected for &7 may require character substitution.

Message Long Text :

Cause . . . . . : Substitution characters were used when converting the collating sequence from coded character set identifier (CCSID) &29 to CCSID &30 for doing comparisons to determine a minimum, maximum or report break for field &7. Converting a value for such a comparison could require use of one of these substitution characters, but comparisons involving substitution characters are not allowed for this query. For each record processed, the value from field &7 will be treated as though it has a mapping error if converting the value for such a comparison requires the use of a substitution character.
Recovery . . . : Do one of the following:
-- Remove the minimum, maximum or report break for the field.
-- If &7 is a DBCS field, specify the processing option that prevents the collating sequence from being used with DBCS fields.
-- Use record selection tests to exclude field &7 values that cannot be converted for comparison without using substitution characters.
-- Use the processing option for ignoring character substitution warnings.
-- Use a different collating sequence. The sequence was originally retrieved from &19 &24 in &25 for sort sequence or table name &17 and language id or library name &18.

Message File : QQRYMSG
Library Message File : QSYS2924


General Data in Customer Master   ROGBILLS - Synchronize billing plans  
This documentation is copyright by IBM.

Length: 3252 Date: 20201028 Time: 030214     sap01-206 ( 19 ms )