cancel
Showing results for 
Search instead for 
Did you mean: 

Syntax error while creating Calculation view based on sql script

ye_dai2
Member
0 Kudos

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

Accepted Solutions (0)

Answers (0)