1 2 Previous Next 16 Replies Latest reply on Sep 24, 2012 6:30 PM by gamvi01 Go to original post
      • 15. Re: Using the Changing variable
        gamvi01
        gamvi01 Sep 21, 2012 11:20 AM (in response to rareddy)

        Done. https://issues.jboss.org/browse/TEIID-2222

          • Actions
        • 16. Re: Using the Changing variable
          gamvi01
          gamvi01 Sep 24, 2012 6:30 PM (in response to gamvi01)

          Hi Steve/Ramesh

           

          I tested it on teiid 8 and dynamic sql worked fine on teiid 8.I couldnt use the same vdb as our codebase is not migrated completely but used something on the same lines.

          <model visible = "true" type = "VIRTUAL" name = "viewupdate">
          <source name="h2-connector" translator-name="h2" connection-jndi-name="java:/accounts-ds"/>

          <metadata type="DDL"><![CDATA[
          CREATE VIRTUAL PROCEDURE test() AS
          BEGIN ATOMIC
          EXECUTE IMMEDIATE 'update accounts.account SET TYPE=''INACTIVE'' WHERE ACCOUNT_ID=19980002';
          END
          ]]>
          </metadata>
          </model>

            • Actions
          1 2 Previous Next