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

Can anyone please help me?
Thanks in advanced.

What data type is T2.CTODNH?

If it is numeric, then 011.071.072 is nat a valid numeric expression.
If it is character the it is not a valid character expression.


Andy

Hello ARWinner in both cases what should be the correct format?
I did a query for T2.CTODNH and result data was
10
96
103

I think it is numeric
Thank you

run
describe table SPIDATA.NMPP099

and post it here

Cougar8000 unfortunately I am the in control of that information I only have access to extract data from the DB2 server

What other choice do I have?
Thank you.

Well assuming it is numeric, then the list would look like this:

(T2.CTODNH In (11,71,72))

Andy

I tried but I am getting the following error:

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

This way, it works

WHERE (T2.CTODNH In (011,071))

This way, it doesn't

WHERE (T2.CTODNH In (011,071,072))

Thx.

This error indicates you are still using the period (.) instead of the comma (,) for separating the numbers.

Andy

Sorry Andy but I don't get it if I am using this

WHERE (T2.CTODNH In (011,071))

I am not using (.) to separate the numbers what could be wrong?

Thx again.

If it is numeric, try removing the leading zeros from the numbers.

Andy

Hello Andy sorry to bother you again, nothing yet friend, still getting the same error, I tried what you mentioned. I am trying to extract the data from MS Query the option in Excel 2007, in the SQL statement I build my query there, does this have anything to do? thanks.

Can you try the query using the CLP instead of Access?

Andy