topic Direct Query -SQL error in QlikView

Direct Query -SQL error

maheshkuttappa — Fri, 10 Apr 2015 01:56:54 GMT

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;

Re: Direct Query -SQL error

Wed, 15 Apr 2015 03:19:19 GMT

Hi Manesh,

Remove the comma after the field POL_EFF_YR

// Removed comma

DIRECT QUERY

dimension

DIV,

industry_subseg_wrtn,

payroll_gov_class,

POL_EFF_MO,

POL_EFF_YR

measure

Sales

FROM X001.ABC_2014Q4;