1 Reply Latest reply on Mar 4, 2014 1:43 AM by rareddy

    join query is not working in teiid designer 8.4.

    lx_r
    lx_r Mar 4, 2014 12:40 AM


      I am trying to join two tables . One table is from oracle and other is from db2. I am getting parsing error :

      TEIID31100 Parsing error: Encountered "db2.id=ora.id [*]_[*]__" at line 7, column 1.
      Lexical error. Character is not a valid token: _

       

      And query written by me is :

      SELECT db2.name,db2.id

      FROM New_DB2_for_Linux_UNIX_and_Windows_2_.emp db2 , New_Oracle_3_.emp ora

      where db2.id=ora.id

      __________________________

      info abt table:

      New_DB2_for_Linux_UNIX_and_Windows_2_.emp is data source from db2

      and New_Oracle_3_.emp is data source from oracle databases.

       

      Can anybody give suggestion to overcome from above problem.

        • 1. Re: join query is not working in teiid designer 8.4.
          rareddy
          rareddy Mar 4, 2014 1:43 AM (in response to lx_r)

          Laxmi,

           

          The above error and your query you posted not looking the same. Do you have other characters at the end. Also, where did you write the query? In the transformation editor?

           

          If you want you can attach Designer project file I can take a look.

           

          Ramesh..

            • Actions