Example: Using the ALTER TYPE Statement with the COMPILE ONLY Option - Teradata Vantage - Analytics Database

The following example recompiles the UDT named address and generates the appropriate object code, but does not generate the new .so file, or redistribute the file to all system nodes.

     ALTER TYPE address COMPILE ONLY;

The following example recompiles the multidimensional ARRAY named seismic_cube and generates the appropriate object code, but does not generate the new .so file, or redistribute the file to all system nodes.

     ALTER TYPE seismic_cube COMPILE ONLY;