I have defined a linked server and a sp residing on db2 machine.
When I call the sp, I get error at line 3:
declare @bcmcu char(12)
Set @bcmcu =' 1100281'
Exec ('Call QGPL.get_jobs(?)', @bcmcu) AT AS400SRV_MSDASQL
Incorrect syntax near ','.
Now, when I call the same on a SQL Server 2005 it works fine.
Any ideas? Is there a difference between 2000 and 2005?