1. Can anyone tell me how to write a Stored Proc for DB2-SQL application?
Ans: Using COBOL390 you can create a DB2 stored procedure. am now sure which version is used in PLI.
So if you have COBOL390 installed in your system you can write your own COBOL-DB2 stored procedures.
2. I would be pleased if someone can give me a SAMPLE Stored PROC
Ans: Its alreay being there in the post. If you want it anyway.. I can post that across...no probs..
3. Also provide me the link for converting VSAM to DB2 data using a Stored Proc.
Its just the same as writing a normal VS COBOL II program from copying VSAM to DB2 will a few standard formats to tell that this is a stored procedure.