Defining a Default Database Collation Method

GT.M lets you define an alternative collation sequence as the default when creating a new database. Subsequently, this default is applied when each new global is created.

This default collation sequence is set as a GDE qualifier for the ADD, CHANGE, and TEMPLATE commands using the following syntax:

	
	GDE>CHANGE/REGION $DEFAULT /COLLATION_DEFAULT=<0-255>
	
	
	

This qualifier always applies to regions, and takes effect when a database is created with MUPIP CREATE. The output of GDE SHOW and DSE DUMP/FILEHEADER display this value. The default collation sequence is 0, or ASCII.

The value cannot be changed once a database file is created, and will be in effect for the life of the database file. The same restriction applies to the version of the collation sequence. The version of a collation sequence implementation is also stored in the database fileheader and cannot be modified except by recreating the file.

If the code of the collation sequence changes, making it incompatible with the collation sequence in use when the database was created, use the following procedure to ensure the continued validity of the database. MUPIP EXTRACT the database using the older compatible collation routines, then recreate and MUPIP LOAD using the newer collation routines.