2 Replies Latest reply: Sep 26, 2013 3:19 AM by Supratim Ray RSS

    Direct Discovery

    Paweł Manowiecki

      Hello Everyone,


      My questions goes to new functionality of Direct Discovery (QV 11.2).


      • Is it possible to load more then one table like this?
      • Is it possible to make WHERE limitations to source data while using DIRECT?


      I tried like this - and third statement failed (it fails even when I remove WHERE clause). It loads only tableA.


      ODBC CONNECT TO ODBC_Teradata (XUserId is zyzyryxy, XPassword is blablablasimple);
      DIRECT SELECT column_a, column_b IMPLICIT column_c
      FROM schema.tableA;
      DIRECT SELECT column_a,column_d IMPLICIT column_e
      FROM schema.tableB 
      WHERE date_of_day > date - 1;


      Thanks in advance for info.


      Best regards,