Calling a Stored Procedure in DB2

[sagittarian]

I have been working on migrating a old ASP app to asp.net and the VBScript block that calls a DB2 stored procedure looks like this: oCmd.Prepared = true Set oParam = oCmd.CreateParameter("RETURN", adsmallInt, 3, 2, 0) oParam.Precision = 4 oParam.NumericScale = 0 oCmd.Parameters.Append oParam ExecuteCmd oCmd oRsReturn = oCmd.Parameters If someone can tell me how to convert the code to VB.Net that would be great, I don't seem to find the equivalent of the first line and the last line and I don't know how to create similar parameters. Thanks for reading!

[Christian Graus]

Well, you will use the OleDBSQL classes to do this. There won't be a one to one mapping of methods, I don't think.

Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )