Stored Procedure

I have been looking a manual or tutorial but without results at this time, I hope that you can help me, I want to create stored procedure in db2.. how can i do that?

Regards

Depends upon what/how you want to do it and the system you are doing it on.

For Using PSQL to write on Linux/Unix/Windows take a look here: http://www.phptr.com/title/0131007726 and there are probably a couple of more books on the phptr site. The one I have is pretty good. Should also be some good articles here:
http://www-130.ibm.com/developerworks/db2/
Search for stored procedures.

I have done a few using PSL on Windows and also few in COBOL on OS/390.

With DB2 Version...8.2? (Stinger) there is also integration to do these within Visual Studio in ASP.NET, for example.

Or I think you can do them with Java also.

So, it depends upon which way you need to go...

fv

You basically have three different methods to do stored procs in:
Java, SQL, & C. This may be different in 8.2 though, they might have added .net capability to it.

You must have the compiling environment on the database server even if you write it in SQL.

Yes, for SQL and C stored procs, you do have to have a C compiler at least on the developement box.


More than 3 ways though....
On the mainframe side you can use COBOL and PL1.

Starting with Stinger you can do stored procs with .NET.

I think starting with v 7.2 you could use VB 6 to create something called OLE stored procs, but hadn't seen squat for documentation or examples of that...

So depending on your environment(s) you have a number of ways you can go with DB2 Stored Procedures. Do check out the IBM DevloperWorks site aforementioned - some good articles and info there.

fv

ok, but which program i have to use to make Stored Procedure, I'm working in DB2 on AS400, and i want to make Stored Procedure called from java ..

also i have looking the DB2 add in for VB.NET. I searched in IBM but the link is broken.., where can i find that??? any suggestion??

Your best bet would be to look here :
http://www-130.ibm.com/developerworks/db2/

You will probably need/want the client software that contains the IBM control center and that whole suite of tools. Our UDB DBA came around and installed all the software from CDs he got, so don't have a link for that. In UDB V 8 the control center became the Development center. I have used a little in V 7 to create PSL stored procs. You could do the same and call from Java apps I am sure. I think you can even write stored procs in Java also, though I never have. Do some searches at that link I gave - there are tutorials and guidance about all of these things there.

fv