Using an appropriate CCSID is essential when registering users in the DE2 or WS2 database

[axessupport]

After successfully registering users in the database, you may encounter an error similar to the one below when logging into DE2.

This error can be caused by not using an appropriate CCSID when registering users. Before updating the files, you need to change your job CCSID to 37. The following note will be included in the next version of the aXes DE2 Administrators Guide and WS2 Administrators Guide in the How to register users manually section.

Using an appropriate CCSID is essential when registering users manually.

DE's database is DBCS, uses a graphic field (CCSID 1200), and data in the tables includes square brackets [ ] and braces { }, also known as curly brackets. Use CCSID 37 as the job CCSID to ensure correct character conversions. This recommendation applies to all methods that register users manually, both interactive SQL and programmatic updates.

Using other CCSIDs may produce incorrect conversions, two examples are CCSID 37 and CCSID 500:

CCSID 37 produces correct data: {"startupfilterid":0,"recent":[15],"showwelcome":true}
CCSID 500 produces incorrect data: {"startupfilterid":0,"recent":¢15!,"showwelcome":true}
The data created using CCSID 500 interprets the square brackets incorrectly, [ becomes ¢ and ] becomes !. CCSID 37 produces the correct result.

The command to set CCSID 37 for a job is: CHGJOB CCSID(37)