May 11, 2004 at 6:18 am
Can anybody help me with the proper syntax for calling a DB2 procedure from SQL Server. I have a linked server and tried to call with the same syntax I would use selecting from a table in the linked server, just adding the parameter but it did not work. Here is the syntax I used
EXEC SerialNumber..Z1VN001$.Z1VNIPIN 'DDA01000'
May 12, 2004 at 6:41 am
A quote from Microsoft:
"Stored procedures are supported only against SQL Server data sources."
This is taken from "External Data and Transact-SQL" http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_3164.asp
You may be able to get around this, and I stress the "may", by utilizing the sp_OA* extended stored procedures to invoke ADO (I don't have the time to look into it further). But I don't see this as a really good solution.
HTH
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply