VB code for calling SP

snassimr · Post by **snassimr** » Mon Jun 27, 2005 1:03 am

Hi!

Does anybode can show me the code for calling Stored procedure on SQL Server.

I need help with this.

roy · Post by **roy** » Mon Jun 27, 2005 2:02 am

Hi,
Do you really mean from VB(Visual Basic)???
In DS you can try using the ODBC stored procedure or simly run a user defined sql to run it.
(depending on wether it has a result set or not might determin if you need to use an output or input link.

IHTH,

elavenil · Post by **elavenil** » Mon Jun 27, 2005 2:02 am

What stage are you using to load data into SQL server. The stored procedure can be called if the stage has 'Before/After' tabs in the SQL tab. The stage does not have the above options, then you may need to write a routine to call SP. I think Stored procedure in DS supports only Oracle, DB2 & Sybase databases.

Hope you can call the SP using call command. (Call <SP Name>)

HTWH.

Regards
Saravanan

kduke · Post by **kduke** » Mon Jun 27, 2005 8:24 am

Why not use a shell script or a batch file?

chulett · Post by **chulett** » Mon Jun 27, 2005 8:58 am

Ah, deja-vu all over again.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 27, 2005 7:01 pm

To invoke a stored procedure from DataStage you must first import the stored procedure definition. If DataStage objects to the import process, then the stored procedure is not amenable to DataStage's method of operation (it must process a record set).
See also this post