Error calling DB2 stored procedure from SQL Server 2000

• SQL STEWIE

  SSCommitted

  Points: 1837

  More actions

  September 10, 2014 at 11:52 am

  #100191

  I am trying to execute the following to call a DB2 stored procedure from SQL Server 2000.

  DECLARE @ICVR_CLAIM_NBR VARCHAR(19)

  SET @ICVR_CLAIM_NBR= 'XXXXXXXXXXXXXXXXXXX'

  EXEC('call PPSPCOL.X2COVSEL (?)', @ICVR_CLAIM_NBR) AT [EXCEEDPP]

  and I get the following error

  Incorrect syntax near ','.

  It works in SQL Server 2008. Any ideas?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  September 18, 2014 at 2:26 am

  #1746309

  I'm not sure the EXECUTE...AT construct was available in SQL 2000.

  Concatenate the parameters and use OPENQUERY:

  DECLARE @ICVR_CLAIM_NBR VARCHAR(19)

  SET @ICVR_CLAIM_NBR= 'XXXXXXXXXXXXXXXXXXX'

  DECLARE @sql varchar(100)

  SET @sql = 'SELECT * FROM OPENQUERY(EXCEEDPP,''call PPSPCOL.X2COVSEL (''''' + @ICVR_CLAIM_NBR + ''''')'')'

  EXEC(@sql)

  -- Gianluca Sartori