Executing SP wth routine

snassimr · Post by **snassimr** » Sat Jun 25, 2005 7:05 am

Hi !

I want to code in VB calling for SP from another server in MS SQL SErveer .

Thank you

elavenil · Post by **elavenil** » Sat Jun 25, 2005 7:28 am

Do you need the VB code, which will call a stored procedure that is available in MS SQL Server?

Pls explain a bit more what you really expect to be answered!!!

Regards
Saravanan

chulett · Post by **chulett** » Sat Jun 25, 2005 7:48 am

Back to the VB approach, eh?

You're better off posting a request like that on some sort of a VB related site, or possibly one for Sql Server. That's really not a DataStage problem, in spite of the fact where you plan to leverage it.

And before you ask - nope, sorry, don't know of any.

snassimr · Post by **snassimr** » Sat Jun 25, 2005 7:49 am

Yes . I need VB code that may be placed within routine

kduke · Post by **kduke** » Sat Jun 25, 2005 9:36 am

If you are on a Windows server then you can execute any exe with DSExecute including a compiled VB program. You can do the same from UNIX with a remote execute command like rsh or rexec.

snassimr · Post by **snassimr** » Sat Jun 25, 2005 10:43 am

Thank you . But I need vb code

ray.wurlod · Post by **ray.wurlod** » Mon Jun 27, 2005 6:41 pm

Fosters market a beer called VB (Victoria Bitter). You're as likely to get a VB answer there as here. DataStage is not written in, and does not use, Visual Basic. Are you confusing DataStage with Microsoft's DTS (data transformation services)?