SQLScript Calculation View

[former_member1038687]

Hi friends!

I'm trying a simple SQLscript calculation view on HANA but it doesn't work. I'm put in target  marc_MATNR, marc_WERKS, marc_STEUC with same type of DECLARE. How can I use VAR_OUT?

BEGIN

DECLARE marc_MATNR VARCHAR(18);

DECLARE marc_WERKS VARCHAR(4);

DECLARE marc_STEUC VARCHAR(16);

DECLARE CURSOR cMARC FOR

  SELECT matnr werks steuc

  FROM "SAPECD"."MARC"

  ORDER BY MATNR WERKS;

OPEN cMARC();

FETCH cMARC INTO marc_MATNR, marc_WERKS, marc_STEUC;

CLOSE cMARC;

VAR_OUT = marc_MATNR, marc_WERKS, marc_STEUC;

END /********* End Procedure Script ************/

Thanks for any help!

[former_member1038687]

I tried something more simple like:

VAR_OUT = SELECT matnr FROM "SAPECD"."MARC";

But I'm getting this error...

No visible attribute or measure found in the calculation view

[RichHeilman]

If your output parameter(VAR_OUT) is defined with all three fields, you must select all three fields in your SELECT statement.

VAR_OUT = SELECT matnr, werks, steuc FROM "SAPECD"."MARC";

Cheers,

Rich Heilman