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

    ODBC field name/table join

      Hi,

       

      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],

      DDTOTL as [TOTAL DESPATCHED];

       

      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

       

      Shaun