Calling a sp from an AS400

  • Hey all you guru's

    I'm trying to figure out how to call a stored procedure off of the AS400 using SQL Server 2000.  I've created many SQL stored procs that use either a Linked Server connection or by using the OPENQUERY function to get information on the AS400.

    Does anyone know if it is even possible to run a stored proc on the AS400 using SQL.  Any help would be GREATLY appreciated.

    The last thing I want to do is re-write this 400 stored proc in SQL.

    Thanks

    Shane

  • This was removed by the editor as SPAM

  • Hi,

              There are Ritmo I Series data Providers Given by Hit software. I have downloaded DAta Provider for Dot net. and was sucessful in calling the AS400 stored procedures using VB.Net.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply