Question Re: Issue in table function in HANA Studio in Technology Q&A

Issue in table function in HANA Studio

former_member184624 — Tue, 31 May 2022 13:43:37 GMT

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

Re: Issue in table function in HANA Studio

venkateswaran_k — Tue, 31 May 2022 14:08:35 GMT

In Hana Studio

Go to Windows - Preferences - General - Workspace

Set the Text encoding to Default UTF-8

Re: Issue in table function in HANA Studio

former_member184624 — Wed, 01 Jun 2022 11:42:06 GMT

Thank you Abhi and Venkat.

Re: Issue in table function in HANA Studio

venkateswaran_k — Mon, 06 Jun 2022 06:26:41 GMT

Hi jelina.masilamani

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

Re: Issue in table function in HANA Studio

venkateswaran_k — Mon, 06 Jun 2022 09:00:20 GMT

Hi jelina.masilamani

jelina.masilamaniIs this issue still not working?

Regards,

Venkat