COBOL DB2 Stored Procedures

sandhyaimmadi · New User Joined: 18 Aug 2008 Posts: 6 Location: Bangalore

Hi,

I need Cobol Db2 stored procedures material.
I want to learn about the SP programming.
If anyone have the link or material,could you please send it to me.

Thanks in advance

Regards,
Sandhya

Anuj D. · Posted: Mon Sep 22, 2008 1:08 pm Post subject:

Hi,

For this you might to check this link..

sandhyaimmadi · New User Joined: 18 Aug 2008 Posts: 6 Location: Bangalore

Hi Anuj,

Thanks for the very quick reply.
I want to write a new cobol+DB2 stored procedure.
I need the programming concepts and all corresponding material.

Regards,
Sandhya.

Anuj D. · Posted: Mon Sep 22, 2008 1:50 pm Post subject:

Sandhya,

Your best bet would be to start with some existing COBOL+DB2 Stored Procedure at your shop, standards for such things will differ across shops.

At my shop, in such Procedures there is usually a Temporary table, a Global Table in program; OPEN cursor is the output of the program. Such Procedures are used to feed an input to a "screen" program which is called as "front end", to test Procedures either front-end should be ready with their codes or there is a Software called as "Proc Builder"...well but this is about my shop..approach would differ at your shop, probably.