Trace Operator()

[Vivek-RR]

Hi

I tried using the TRACE operator to debug and find the intermediate results. But

the temporary table SQLSCRIPT_TRACE  is always blank.

CREATE PROCEDURE ZVIV.TEstTRACEOP11  AS

BEGIN

tst = select PROD AMOUNT FROM ZVIV.SALES WHERE O_ID = 'O01';

trc = TRACE(:tst);

trc1 = SELECT * FROM :tst;

END;

Is there some configuration to be done @ Administration->Trace Configuration ->Global database trace?

Regards

Vivek

[lbreddemann · Accepted solution]

Hi Vivek,

as discussed - this seems to be a new bug in current revisions.

- Lars

[Vivek-RR · Accepted solution]

Thanks Lars..

[former_member182114]

Hi Vivek,

Is this sample code your complete code?

I'd say that HANA optimizer "understood" that you don't have any usage of trc1 and also tst is discarded...

If this is not your complete code, try put trc1 as output of your procedure.

Also later make another test using same name:

tst = TRACE(:tst);

Regards, Fernando Da Ros