To set a valid CCSID value

Note: Lawson now requires a CCSID of 37 on either the User Profiles of the users running Lawson, or on the OS/400 System Value QCCSID.
  1. Log in as QSECOFR or a user with authority to create the database.
  2. Determine whether you want to change the QCCSID system value (usually for systems running only one language) or change the CCSID value for each user profile (usually for systems running multiple languages).

    Perform only one of the following two procedures to ensure that the CCSID is set to the default 37, whichever is appropriate for your site. See IBM's National Language Version (NLV) documentation for more details and ramifications of these settings.

    – or –

    1. Type

      CHGSYSVAL SYSVAL(QCCSID) VALUE(37)

      Note: This is a one time system wide change and does not need to be redone for every database created.
    2. Set each Lawson Users' User Profile that will be running the Lawson system to default to this system value. Type

      CHGUSRPR USRPRF(LAWSONUSER) CCSID(*SYSVAL)

    1. Use CHGUSRPRF to set the appropriate value on each Lawson Users' User Profile that will be running the Lawson system (including users that install, configure, or patch the Lawson system, like QSECOFR). For example, type

      CHGUSRPRF USRPRF(LAWSONUSER) VALUE(37)

  3. Perform only one of the following procedures to create the database collection: To create the database from the SQL Green Screen interface, or To create the database from the OS/400 command line.