I think this is what your looking for:

Sample Call:

exec spSelect_CallWebPage 'http://www.google.com'

CODE:

CREATE PROCEDURE [dbo].[spSelect_CallWebPage]

(@URL varchar(1000))

AS

DECLARE  @vPointer INT,  

  @vResponseText VARCHAR(8000), 

  @vStatus INT, 

  @vStatusText VARCHAR(200)

EXEC sp_OACreate 'WinHttp.WinHttpRequest.5.1', @vPointer OUTPUT

EXEC sp_OAMethod @vPointer, 'open',NULL, 'GET', @URL,0

EXEC sp_OAMethod @vPointer, 'send'

EXEC sp_OAMethod...

We too had no luck with DB2 Linked server. We also tried HIS (Host/SNA) with some success (could not get stored procedures to work). We have had GREAT success with...