SQL server error on parameter

srinivas.nettalam · Post by **srinivas.nettalam** » Wed Mar 07, 2012 6:24 am

I am writing a simple join query in ODBC connector stage as below:

SELECT
a.IP_ID,
ltrim(rtrim(a.UNQ_ID_IN_SRC_STM)) as UNQ_ID_IN_SRC_STM_ID
FROM vwIP_S a,
vwSRC_STM_S b
WHERE a.SRC_STM_ID = b.SRC_STM_ID And
b.SRC_STM_CODE ='#p_SourceSystemCode#'

#p_SourceSystemCode# is a job parameter and it has value 'VS'

When I validate I am getting a warning like below:

ODBC_Ip: ODBC Info: SQLSTATE = 57: Native Error Code = 207: Msg = [IBM(DataDirect OEM)][ODBC 20101 driver][Microsoft SQL Server]Invalid column name 'VS'.
The same approach is working in another job without any warning.please help

chulett · Post by **chulett** » Wed Mar 07, 2012 7:57 am

I don't see anything obviously wrong. What happens when you run the job?

ray.wurlod · Post by **ray.wurlod** » Wed Mar 07, 2012 3:04 pm

My guess (from the error message) is that the quotes are being stripped.

Kryt0n · Post by **Kryt0n** » Wed Mar 07, 2012 3:28 pm

Does the parameter literally contain 'VS' (including the single quotes)?

josh.guffey · Post by **josh.guffey** » Fri Mar 09, 2012 9:54 am

Take a look at this article. We just had the same issue using Oracle and used this information to solve the problem.