Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

field or table alias is not allowed as an input of table functions

Hi,

I am trying to write a query something like the following in a procedure but it gives me error SAP DBTech JDBC: [7] (at 1669): feature not supported: field or table alias is not allowed as an input of table functions:

SELECT  

TempEX."M1",

TempEX."M2",

ex."E_ID",

TempEX."B_ID",

TempEX.B_Text,

ADD_SECONDS(TempEX."StartDateTime",60) AS StartDateTime,

ex."E2ID" AS ItemID,

ex."ExName" AS ItemText,

(SELECT ITEMS FROM SCHEMA."FN_GetItemCategories"(ex."E2ID",'Exhibitor','')) AS P, 

TempEX."MinTime",

TempEX."Radius",

ex."Size",

FROM SCHEMA."Escalators" ex INNER JOIN  

(

  SELECT .............................

) TempEX

ON ex."E2D"=TempEX."ItemID"

ORDER BY ex."E2ID",TempEX."StartDateTime";

Inside my function i am just trying to return a string after doing some select queries and operations. I cannot use scalar UDF because it does not support SELECT queries and if i make it table UDF then i get the above specified error. Can anyone suggest what am i missing or an alternative to achieve my purpose?

TIA.

Nikhil

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question