Skip to Content
0

Syntax error while creating Calculation view based on sql script

Dec 06, 2016 at 10:55 AM

55

avatar image
Former Member

Hi expert,

I'm creating Calc view based on sql script and drafted a simple code but I'm getting syntax error.

Please help me!!

Message :
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: invalid column name: A.field_a: line 4 col 13 (at pos 293)nSet Schema DDL statement: set schema "SYSTEM"nType DDL: create type "_SYS_BIC"."ytai_test01/ZTAI_TESTVIEW_01/proc/tabletype/VAR_OUT" as table ("field_a" VARCHAR(20), "field_b" DOUBLE)nProcedure DDL: create procedure "_SYS_BIC"."ytai_test01/ZTAI_TESTVIEW_01/proc" ( OUT var_out "_SYS_BIC"."ytai_test01/ZTAI_TESTVIEW_01/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as n /********* Begin Procedure Script ************/ n BEGIN var_out = n t SELECT a."field_a" as field_a,a."field_b" as field_bn t from "M940038"."ZTAI_TEST01" as an t ;nEND /********* End Procedure Script ************/n

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers