Large Key Support

For CA IDMS running in a z/OS or z/VSE environment, the maximum key length in an SQL database has been increased from 256 to 2000 bytes. This enhancement allows CA IDMS to support a richer set of applications.

You can now define CALC, index, sort, foreign, and referenced keys that are up to 2000 bytes in length. To use this feature, define a key with a length greater than 256 bytes.

When using large keys, consider the following restrictions:

You must use the REORG utility instead of the UNLOAD and RELOAD utilities to reorganize a database that contains keys longer than 256 bytes.
You cannot use the FOR CALC option of the PRINT PAGE utility for locating the target page of a large key value, because you can only specify key values that are less than or equal to 256 bytes