Import-related Procedures
SYSADMIN.importView
This procedure imports a view. Import will not fail even if the data source the view is based on is not present.
SQL
SYSADMIN.importView(IN text string)
Example
SQL
CALL importView('CREATE VIEW test_views.v1 AS SELECT 1')
SYSADMIN.importProcedure
This procedure imports a virtual procedure.
SQL
SYSADMIN.importProcedure(IN text string)
Example
SQL
CALL SYSADMIN.importProcedure('CREATE PROCEDURE test_views.proc1() AS BEGIN SELECT * FROM test_tables.test_a; END')
SYSADMIN.importFunction
This procedure imports a data source-specific user-defined function.
SQL
SYSADMIN.importFunction(IN text string)
Example
SQL
CALL SYSADMIN.importFunction('CREATE PROCEDURE CREATE FOREIGN FUNCTION mssql.test_function(num1 integer, num2 integer) RETURNS integer OPTIONS (NAME_IN_SOURCE '"test_tables"."dbo"."test_UDF"');')
SYSADMIN.importFunction
is available since v4.8