3 Replies Latest reply on Aug 6, 2018 8:00 AM by Steven Hawkins

    DECLARE and SET not working on VDB

    Aditi Patel Newbie

      We are executing below on VDB: DECLARE @date DateTime SET @date = (SELECT CURRENT UTC TIMESTAMP) SET @date = dateadd(dd,-5, @date) Error Message: [Code: , SQL State: 50000] Remote org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "[*]SET[*] @date =" at line 1, column 1. Was expecting: "alter" | "begin" | "call" | "create" | "delete" | "drop" | "exec" | "execute" | "insert" | "merge" ...