You must use the External Routine Installation Tool (tdextroutine) to create C, C++, or Java UDFs and external stored procedures in VantageCloud Lake.
If you have existing SQL scripts (BTEQ files) that use the CREATE PROCEDURE, REPLACE PROCEDURE, CREATE FUNCTION and REPLACE FUNCTION statements to create UDFs and external stored procedures for VantageCloud Enterprise or VantageCore, you can use the External Routine Migration tool (XRMigrationTool) to convert these scripts for use in VantageCloud Lake.
XRMigrationTool does the following:
- Parses an input SQL script and updates the script to replace the CREATE PROCEDURE, REPLACE PROCEDURE, CREATE FUNCTION and REPLACE FUNCTION statements with calls to tdextroutine.
- Creates the manifest.json files based on the CREATE/REPLACE FUNCTION and PROCEDURE definitions. tdextroutine uses these files to create the UDFs and external stored procedures .
After running XRMigrationTool, you can run the updated SQL script to create the UDFs and external stored procedures in VantageCloud Lake.