5 Replies Latest reply: Jul 13, 2012 7:08 AM by shaun savage RSS

    ODBC field name/table join



      I want to use the following in qlikview with an odbc link to our iSeries database.


      sql SELECT DDWEEK, sum(DDTOTL) FROM ls3dta100a/ddp GROUP BY DDWEEK;


      but this doesn't create join to another table with a field called[WEEK NO], so I tried:


      load DDWEEKas [WEEK NO],



      sql SELECT [WEEK NO], sum([TOTAL AS DESPATCHED]) FROM ls3dta100a/ddp GROUP BY [WEEK NO];


      But this creates a ODBC error when connecting to the table on the iSeries. How can I achieve the renaming of the fields so that I can get a join?


      Many thanks in advance