I have the below function

CREATE FUNCTION thatreturnstable()
RETURNS TABLE(SHORT varchar(5))
language SQL
DETERMINISTIC
READS SQL DATA
CALLED ON NULL INPUT
EXTERNAL ACTION
return
select shot from temporary

I have compiled this successfully,
I called this function in a select query

select * from TABLE(thatreturnstable())

i got the following error.

SQL0104N An unexpected token "END-OF-STATEMENT" was found
following "(thatreturnstable())". Expected tokens may include:
"<correlation_name> ( <derived_co".



please advice me how to call that function in an SQL query

The answer is right there:

select * from TABLE(thatreturnstable()) t