1 Reply Latest reply: Apr 14, 2015 11:19 PM by Randy Teng RSS

    Direct Query -SQL error

    Mahesh Kumar Kuttappa

      Hi ,

      i get following SQL error When I Direct Query SAS table any suggestion to resolve this issue .

       

      SQL##f - SqlState: S1000, ErrorCode: 4294967295, ErrorMsg: [SAS][SAS ODBC Driver][SAS Server] SPDS_NOTE: Correct Syntax for select expression is:

      DIRECT QUERY

      dimension

          DIV,

          industry_subseg_wrtn,

          payroll_gov_class,

          POL_EFF_MO,

          POL_EFF_YR,

         measure

         Sales

         

      FROM X001.ABC_2014Q4;