2 Replies Latest reply on Apr 12, 2016 10:26 PM by Dmitry Chirkov

    Error: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token '1' was not valid. Valid tokens: ,.

    Jaideep Rokade

      Hello Team,

       

      I am working on Tableau: 9.1.1 (32 bit).
      Data source is Live connection with DB2.

      Used iSeries Access ODBC Driver to connect DB2

      Used Custom Sql with parameter to get data according to parameter selection

      SQL Statement:

      SELECT "TRENDFPF"."FALIND" AS "FALIND",

        "TRENDFPF"."FBUDQ" AS "FBUDQ",

        "TRENDFPF"."FCOMDES" AS "FCOMDES",

        "TRENDFPF"."FCOMNO" AS "FCOMNO",

        "TRENDFPF"."FDAYC" AS "FDAYC",

        "TRENDFPF"."FDDMMYY" AS "FDDMMYY",

        "TRENDFPF"."FLOB" AS "FLOB",

        "TRENDFPF"."FMONTH" AS "FMONTH",

        "TRENDFPF"."FSALES" AS "FSALES",

        "TRENDFPF"."FYYMM" AS "FYYMM",

        "TRENDFPF"."FZONE" AS "FZONE"

      FROM "TABLIB"."TRENDFPF" "TRENDFPF"

      where RIGHT( <Parameters.Date Parameter1>,2)=FMONTH



      Problem statement:
      Error while applying date filter in view

       

      Detail description:

      I am applying below filter

       

       

      [Date_cal]>= DATEADD('month',-12,[Date_Para_cal])

       

      and

      [Date_cal]<=DATEADD('month',-1,[Date_Para_cal])


      but getting below error

       

      [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token '1' was not valid. Valid tokens: ,.

       

       

      I hope you got the problem..

       

      IF you require more details let me know.

       

      PS: Sorry, Not able to attach sample workbook, because the error is with live connection.

      if I took extract the filter works fine without error.

       

      Regards

      Jaideep