"SQL0104 - Token * not valid" - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

"SQL0104 - Token * not valid"

Author

Topic

jecb
Starting Member

2 Posts

Posted - 2009-05-05 : 17:45:19

Hello I am trying to extract data from DB2 using this query

SELECT T2.CIADNH, T2.DPTDNH, T2.FICDNH, T1.APEFI1, T1.NOMFI1, T2.CTODNH, T3.DESCTO, T2.CANDNH, T2.MONDNH, T2.PRDDNH, T2.AÑODNH
FROM SPIDATA.NMPP060 T1, SPIDATA.NMPP099 T2, SPIDATA.NMPP027 T3
WHERE (T2.CTODNH In (011.071.072))

but I get the following msg

SQL0104 - Token .072 was not valid. Valid tokens: ,.

If I take out the .072 from the query it does work

Why?
Thanks in advanced.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-05-05 : 18:04:39

You should post your question on a site that specializes in DB2. This site is for Microsoft SQL Server, so it's unlikely you'll find an answer here.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

jecb
Starting Member

2 Posts

Posted - 2009-05-05 : 18:43:00

Hello Tara, thanks for replying however I first did a search on the site, found similar posts and they all were in this forum, thanks anyway.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources