12-06-2016 10:55 AM - edited 02-03-2024 5:32 PM
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.