1 Reply Latest reply on Aug 6, 2010 10:56 AM by Ramesh Reddy

    Update Text file using teiid 6.2

    ramya r Newbie

      Hi,

       

      I would like to know whether it is possible to update or insert records into text file using Teiid 6.2. As i get error "Metadata does not allow updates on this group." . Or Could you suggest me any alternatives.

        • 1. Re: Update Text file using teiid 6.2
          Ramesh Reddy Master

          Using 6.2, it is not possible to write back to the text files. We consider Text files are read-only resources. There is some what similar feature coming in 7.2 version

           

          https://jira.jboss.org/browse/TEIID-962

           

          that does some what what you are looking for. Still it is not update but you can write back a whole file. If you use 7.0 version, you should be able to write a XML version of the file instead of CSV file using the suggestion in the comment of the above JIRA. Look in the Reference Guide for how you can use those XML functions.

           

          Ramesh..