CREATE PROCEDURE dbo.sp_ZyTax_Import

(
  @RetValue char(50),
  @Library  nvarchar(10),
  @File nvarchar(10),
  @Member nvarchar(10),
  @rc int output
)

AS

SET NOCOUNT ON

Exec ('Call QGPL.sp_ovrdbf(?,?,?,?)', @Library, @File, @Member, @rc) AT AS400SRV_IBMDASQL

quote:

---

Originally posted by snufse

I read below (http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20629811.html)

You can set ANSI options when you create the stored procedure...these will be inherited...

SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
CREATE PROCEDURE MyProc as

Select * from [LinkedServer].DBname.dbo.Mytable

So when I try create my proc:

SET ANSI_NULLS OFF
SET ANSI_WARNINGS OFF

CREATE PROCEDURE dbo.sp_ZyTax_Import

(
  @RetValue char(50),
  @Library  nvarchar(10),
  @File nvarchar(10),
  @Member nvarchar(10),
  @rc int output
)

AS

SET NOCOUNT ON

Exec ('Call QGPL.sp_ovrdbf(?,?,?,?)', @Library, @File, @Member, @rc) AT AS400SRV_IBMDASQL

I get error

Msg 111, Level 15, State 1, Procedure sp_ZyTax_Import, Line 19
'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.

---