Skip to Content
0
Former Member
Nov 18, 2012 at 02:26 PM

Error Using CE_AGGREGATION

35 Views

/********* 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