Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

mahesh3k
Contributor

Direct Query -SQL error

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;

Tags (1)
1 Reply
Not applicable

Re: Direct Query -SQL error

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;

Community Browser