Was this helpful?
How You Create Data Types in VMS
The general procedure for defining and installing user-defined data types and functions in the VMS environment is as follows:
1. Design and code the routines necessary to perform the functions necessary to manipulate the new or existing data types.
2. Establish a test installation in which to test the new data types and functions.
3. Create the IIudadt_register( ) routine.
4. Create the shared image by adding object module descriptions to the template command files found in II_SYSTEM:[INGRES.LIBRARY]II_USERADT_BUILD.COM.
5. Define the logical name II_USERADT to point to this shared image.
6. Build module tests which call all routines in the prescribed manner to test the basic functionality outside of the complexity of the Ingres system. It is advisable to verify that all sections of code are reached.
7. Start a new DBMS server or Star server and test the new functionality. Testing must involve a large variety of query types to ensure full coverage of the code.
8. Once you are confident that the server works, shutdown and restart your entire test installation to verify that the support processes (the Recovery, Archiver, and cluster server) operate correctly. You can verify this by checking the error logs:
ii_config:errlog.log
ii_config:ii_rcp.log
ii_config:ii_acp.log
Note:  If your system is configured for Ingres Cluster Solution, each node in the Ingres cluster maintains a separate Archiver and Recovery error log. Each log is distinguished by having _nodename appended to the base log name, where nodename is the Ingres node name for the host machine as returned by iipmhost.
9. When the code has been fully tested, make sure that the add_risk_consistency field of the IIADD_DEFINITION data structure is set to IIADD_CONSISTENT. For more information about this field, see Structure IIADD_DEFINITION Fields on page 1.
10. Install the new code in the target system.
Move all of your code to the desired location for your target system and repointing the II_USERADT logical if necessary. Once your code is in place, you must shutdown and restart your installation so that the support processes recognize the new code.
Last modified date: 01/30/2023