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