Using OpenQuery and Linked Server and passing a Parm
I am trying to run a script that calls a proc on db2/400 and cannot seem to get ot to work. Can somenone help please?
Code:
DECLARE @JobNumber1 char(12)
SET @JobNumber1 = ' 3505040'
DECLARE @OPENQUERY nvarchar(4000), @TSQL nvarchar(4000), @LinkedServer nvarchar(4000)
SET @LinkedServer = 'AS400SRV_MSDASQL'
SET @OPENQUERY = 'SELECT * FROM OPENQUERY('+ @LinkedServer + ','''
SET @TSQL = 'Call QGPL.get_eqmqty(?)' + ',''' + @JobNumber1 + ')'
EXEC (@OPENQUERY+@TSQL)
The value of my string is:
SELECT * FROM OPENQUERY(AS400SRV_MSDASQL,'Call QGPL.get_eqmqty(?),' 3505040)
The error I get is:
Incorrect syntax near '3505040'.
Thank you.