Checklist for Creating Data Types
How You Create Data Types in Windows
The general procedure for defining and installing user-defined data types and functions in a Windows environment is as follows:
1. Design and code the routines needed 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. Relink the IILIBUDT.DLL using the User Defined Data Type Linker Utility.
5. Build module tests that 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.
6. 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.
7. Once you are confident that the server works, shut down and restart your entire test installation to verify that the support processes (the Recovery, Archiver, Star, and Remote Command) operate correctly. You can verify this through Visual Manager.
8. 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.
9. Install the new code in the target system.
Move all of your code to the desired location for your target system. Once your code is in place, you must shut down and restart your installation so that the support processes recognize the new code.
Last modified date: 11/28/2023