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
SQL server error on parameter
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
SQL server error on parameter
N.Srinivas
India.
India.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 40
- Joined: Thu Apr 17, 2008 1:52 pm
- Location: Huntsville, AL
Take a look at this article. We just had the same issue using Oracle and used this information to solve the problem.