The sample udf_rg_3 is included in a precompiled dynamic library called libv4apiex (extension is platform-dependent). Its implementation is in the samples directory in udf_rg_3.cxx.
- To declare the Table UDF to the server, issue:
CREATE OR REPLACE PROCEDURE udf_rg_3( IN num INT )
RESULT( c1 INT )
EXTERNAL NAME 'udf_rg_3@libv4apiex'
- Select rows from the table UDF:
SELECT * FROM udf_rg_3( 200 );
This query produces values for c1 from 0…99 followed by 0…99.