ASCII Definition of the Lawson Database

To allow Lawson applications to use specific search functions, the IBM DB2 for OS/390 database for all applications, GEN, and LOGAN product lines must be defined in an ASCII format. This can be done through either the CREATE DATABASE command or the DSNZPARM parameter. If you need to have a mixture of database types contained within the same DB2 subsystem, the CREATE DATABASE SQL command can provide that flexibility. To use the CREATE DATABASE command to set the ASCII format, issue a SQL statement similar to the following:

CREATE DATABASE dbname BUFFERPOOL BP? STOGROUP defltstg CCSID ASCII;

If you use the DSNZPARM parameter to set the ASCII format, change its value from the EBCIDIC default to ENSCHEME=ASCII. This method allows for all databases created to be ASCII-based.