Skip to Content
avatar image
-1
Former Member

Can any one explain what mistake i have done in this script

Can any one explain what mistake i have done in this script

BEGIN var_out = column_table("MY_PROJECT"."PAYMENTS", ["CUSTOMERNUMEBR","CHECKNUMBER","PAYMENTDATE","AMOUNT"]); END /********* End Procedure Script ************/

i am facing thsi error

: Encountered an error in repository runtime extension;Model inconsistency. Deploy Calculation View: SQL: sql syntax error: incorrect syntax near "[": line 5 col 4 (at pos 310) Set Schema DDL statement: set schema "SYSTEM"

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 24 at 02:51 AM

    Well, one thing is that you don't use correct syntax here.

    Your "column_table" looks like you wanted to use the old, meanwhile, obsolete CE_-functions.

    Instead, use SQL like this:

    BEGIN 
        var_out = SELECT "CUSTOMERNUMEBR", "CHECKNUMBER", "PAYMENTDATE", "AMOUNT"
                  FROM "MY_PROJECT"."PAYMENTS"; 
    END;

    Since the error message also indicates that you try to create a scripted calculation view, please note that these also have been deprecated.

    Instead, you may use stored procedures or table typed user-defined functions nowadays.

    If I had to guess, I'd say you're following some HANA 1 SP 4/5 development guide. Don't waste your time with that, in case I guessed right.

    Use the freely available development guides, tutorials, and courses for your current HANA 1 or HANA 2 system.

    Add comment
    10|10000 characters needed characters exceeded