Stored Procedures and SQL Server

[jhorton]

I am new to the Stored Procedure stage and was hoping someone could point me in the direction of a good resource to creating a stored procedure job. I can get my stored procedure stage to connect to my SQL Server database but I am having troubles getting the arguments set up in the stage (I think). Whatever the case, after it connect it errors, I have tried many things and get many different errors. I don't have a specific problem but I do need a resource that can walk me through the process. I am just trying to call simple stored procs that take one or two inputs and do some manipulation in the database and only return a success or failure message. Thanks for your help.

[jdmiceli]

Realizing you are using Parallel Edition and I only have Server Edition, I found the Stored Proc Stage to be difficult to get working correctly as well. What I did to cheat was to add a before or after job command in the appropriate place to fire off the stored proc.

So my command line part looks like: exec sp_whatevername
and the parameters line (if you have parameters) is like:
#TableName# #BatchNumber#

This has worked very well for me so far. Is it the best way? Probably not, but if it ain't broke don't fix it!

[/code]

[lstsaur]

Read i46decsp.pdf (STP stage) file in the \IBM\InformationServer\Documentation folder.

[filename.txt]

[quote="jhorton"] I can get my stored procedure stage to connect to my SQL Server database but I am having troubles getting the arguments set up in the stage (I think).[/quote]

How you got connect to SQL Server using Stored Proc stage ..?
SQL Server is not supported in this stage.
If you look in Stage>General>Database Vendor
There are only three options namely...
1)Oracle
2)DB2
3)Sybase

Please correct me If I am wrong.
Let me know how you connect to SQL Server from Stored Proc stage.

[lstsaur]

For V8, you will have 5 options, SQL Server is one of them.