Skip to Content
0
Former Member
Jul 12, 2016 at 02:33 PM

UDF Return-Table Based On Repository Table

47 Views

I have tried the following:

FUNCTION "mySchema"."myFunction" ( )

RETURNS TABLE ( "SAPR3"."TCURR" )

LANGUAGE SQLSCRIPT

SQL SECURITY INVOKER AS

BEGIN

/*****************************

Write your function logic

*****************************/

END;

and various derivations thereof, but activation fails with the syntax error "Syntax error in table function object: incorrect syntax near ".": line 13 col 26 (at pos 475)" and I cannot find anything which works.

Any suggestions out there?