/********* Begin Procedure Script ************/
BEGIN
var_tab = CE_COLUMN_TABLE("EFASHION_TUTORIAL"."SHOP_FACTS");
var_out =
CE_AGGREGATION( (:var_tab, SUM(AMOUNT_SOLD) , [ARTICLE_ID, WEEK_ID]);
-- CE_AGGREGATION( (:var_tab, SUM(D) , [A, B, C ]);
END /********* End Procedure Script ************/
O/P
0 ARTICLE_ID INT
1 WEEK_ID INT
2 AMOUNT_SOLD DECIMALS 34
Error Message
<info>Internal deployment of object failed;Repository: Encountered an error in repository runtime extension;Internal Error:Deploy Calculation View: SQL: transaction rolled back by an internal error: sql syntax error: incorrect syntax near "(": line 8 col 21 (at pos 352) (qp_gram.y:31564) nSet Schema DDL statement: set schema "ECC6"nType DDL: create type "_SYS_BIC"."student999/CVS_43/proc/tabletype/VAR_OUT" as table ("ARTICLE_ID" INTEGER, "WEEK_ID" INTEGER, "AMOUNT_SOLD" DECIMAL(34,0))nProcedure DDL: create procedure "_SYS_BIC"."student999/CVS_43/proc" ( OUT var_out "_SYS_BIC"."student999/CVS_43/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as n /********* Begin Procedure Script ************/ n BEGIN nvar_tab = CE_COLUMN_TABLE("EFASHION_TUTORIAL"."SHOP_FACTS"); t n tn tn var_out =n CE_AGGREGATION( (:var_tab, SUM(AMOUNT_SOLD) , [ARTICLE_ID, WEEK_ID]);n-- CE_AGGREGATION( (:var_tab, SUM(D) , [A, B, C ]);n n-- var_out =n--CE_PROJECTION(:var_tab, [ARTICLE_ID,WEEK_ID,AMOUNT_SOLD], ' "WEEK_ID" = ''243'' AND "ARTICLE_ID" = ''171889'' ');nnnnEND /********* End Procedure Script ************/nVersion: 71n</info>
Thanks in Advance