Solution : https://service.sap.com/sap/support/notes/554792 (SAP Service marketplace login required)
Summary :
Following a Codepage Conversion from EBCFIC to the Global Language Solution (GLS) on iSeries, issues arise involving Unicode table-based databases that affect external tool and program access. Customers experience SQL0332 errors when accessing non-SAP files with ABAP. The conversion to Unicode affects the behavior of tables, making RPG programming challenging. Solutions proposed include using commands like DSPPFM, UPDDTA, STRSQL, SQLUTIL, and RUNQRY to enhance compatibility. Additionally, utilizing CRTSAPVIEW and CRTSAPLF commands can tailor the system to better handle these Unicode tables while maintaining necessary interactions with non-SAP tools. Permanent CCSID adjustments via CHGJOB or user profiles are advised to sustain these changes.
Key words :
strsql create table library/mytable, special command creates dds logical files, avoid unexpected side-effects, configure qaqqini parameter ignore_derived_index=, ile-rpgsql -332 sql0332 13488 reason, double byte character set, special parameters defined, rename dds keywords, alternating collating sequences, operating system utilities
Related Notes :
556969 | iSeries : Troubleshooting during ASCII Codepage Conversion |
500950 | iSeries: R/3 EBCDIC --> ASCII Codepage Conversion Doc. |