Hello All,
This is my first post to this forum and I need some help in trying to figure out what is wrong with my query that runs in our DB2 (AS400) environment but when I try to use the above driver connection in Excel I get the following error:

[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0104 - Token .01 was not valid. Valid tokens: + - AS <IDENTIFIER>

SELECT   DISTINCT ivno1.01, rfdcno.01, ivtyp.01, cuno.01, cunm.05, stn1.01, 
           ivdat8.01 EDTCDE(W), wosgno.02, sqno5.03, cgcd.03, qty5.03,      
           tolbhr.03, uncs.03, unsel.03, epidno.03, eplsnm.04               
FROM     libd09h/msphdrs0, libd09h/mspsegs0, libd09h/mspdetl0,              
           libd09/wopempf0, libd09/cipname0                                 
JOIN     ivno1.01=ivno1.02 AND ivno1.01=ivno1.03 AND wosgno.02=wosgno.03 AND
           epidno.02=epidno.04 AND cuno.01=cuno.05                          
WHERE    ivdat8.01 BETWEEN 20120901 AND 20121031 AND tolbhr.03<>0 AND       
           hdsgii NOT IN('T','Z')
I realize it is a syntax error working within MS SQL but I do not know what to change for it to recognize my columns. It does not like the .01 numbering? Any help in getting the syntax for this entire query to run in the MS environment would be extremely beneficial and I would be grateful!