Validation error while creating calculation view

[Former Member]

I used the following syntax while creating a scripted calculation view-

/********* Begin Procedure Script ************/

BEGIN

  var_out =

Select ESSPLC , ESRVND , ESRSTY, ESSCOD,

SUM(ESHSQY),

FROM "JDA_SRC"."CIVS00P"

GROUP BY ESSPLC, ESRVND, ESRSTY, ESSCOD

Order by ESSPLC,ESRVND, ESRSTY, ESSCOD

END

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

I am getting the following error while attempting to validate my view(see attachment). Please help me

[former_member185165]

Hi Ankur,

Try the below. Just copy and paste this code in your scripted calculation view. It should work.

/********* Begin Procedure Script ************/

BEGIN

  var_out =

Select ESSPLC , ESRVND , ESRSTY, ESSCOD,

SUM(ESHSQY)

FROM "JDA_SRC"."CIVS00P"

GROUP BY ESSPLC, ESRVND, ESRSTY, ESSCOD

Order by ESSPLC,ESRVND, ESRSTY, ESSCOD;

END

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

[lbreddemann]

You do realise that this thread moved on a couple of days ago, right?

[former_member185165]

No Lars, I did not realize that since the question was not marked as answered.

[lbreddemann]

How is that a reason for not reading up on what's going on in a conversation before rushing in with something?

You are welcome to add something, by all means. But try to keep up with the flow of the discussion. Pretty much what you would do in a normal conversation, too.

[former_member185165]

No issues. Totally agreed (y)