Results 1 to 15 of 18

Thread: Using OpenQuery and Linked Server and passing a Parmr

Threaded View

  1. #1
    Join Date
    Mar 2009
    Posts
    32

    Question 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.
    Last edited by snufse; 04-01-2009 at 09:19 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •