Issue in table function in HANA Studio

[former_member184624]

Hi BW Experts,

I have written the TABLE FUNCTION. While executing, i am getting different error which i am unable to solve this issue. Please find the below code for your reference. Please find the error screenshot for the below code.

FUNCTION "XXX"."YYYY::AAAA" (IP_COMP_CODE VARCHAR(3),

IP_DAY_FROM DATE, IP_DAY_TO DATE)

RETURNS TABLE

(

WC_TRID1 VARCHAR(87),

SOURSYSTEM VARCHAR(2),

COMP_CODE VARCHAR(3),

"0CALDAY" VARCHAR(8),

DRIVE_ON_TIME DECIMAL(15,2),

NO_OF_PO DECIMAL(15,2)

)

LANGUAGE SQLSCRIPT

SQL SECURITY INVOKER AS

BEGIN

TABLE_TEMP = select "WC_TRID1", "0SOURSYSTEM", "0COMP_CODE", "0CALDAY",

AVG(WK_BDS) OVER(PARTITION BY "WC_MAFERT","WC_VTIPO","WC_SRPNO","WC_SDTF") AS "DRIVE_ON_TIME",

COUNT(*) OVER(PARTITION BY "WC_PONO") AS "NO_OF_PO"

from "ZTI_FLEETANALYTICS"."AHX1B_WRYCWR06"

where "WK_BDS" <> '0' AND "0COMP_CODE" = :IP_COMP_CODE AND "0CALDAY" BETWEEN :IP_DAY_FROM AND :IP_DAY_TO ;

RETURN

SELECT * FROM :TABLE_TEMP;

END;

Thanks.

table-function-error.jpg

table-function-error1.jpg

table-function-error2.jpg

[former_member184624]

Thank you Abhi and Venkat.

[venkateswaran_k · Accepted solution]

In Hana Studio

Go to Windows - Preferences - General - Workspace

Set the Text encoding to Default UTF-8

[venkateswaran_k · Accepted solution]

Hi jelina.masilamani

The Answer was reverted as un-accepted. Is there any issues. Kindly update so that I can correct it.

[venkateswaran_k]

Hi jelina.masilamani

jelina.masilamaniIs this issue still not working?

Regards,

Venkat