stored procedure in cobol

This is a Mainframe COBOL forum - you can post your queries on Mainframe COBOL, VS COBOL II, COBOL/370 , Enterprise COBOL

Moderators: dbzTHEdinosauer, Moderator Group

Post Reply
shailesh.joshi
Member
Posts: 3
Joined: Sat Nov 24, 2007 4:00 pm
Location: Hyderabad

stored procedure in cobol

Post by shailesh.joshi » Thu Nov 29, 2007 12:59 pm

HI,

I need to know about how stored procedure work in cobol?
what exactly mean by stored procedure?
Think,communicate and do it.

User avatar
Krishna
Site Admin
Posts: 1052
Joined: Fri Jan 27, 2006 7:50 am

CALLING DB2 STORED PROCEDURES FROM COBOL

Post by Krishna » Thu Nov 29, 2007 3:04 pm

Hi Shailesh,

find the details.

stored procedure - It is a piece of code stored in database server.
When program calls this stored procedure, database server will run this code
in server and send the results to the program.

Calling stored procedure from COBOL -

Using EXEC SQL CALL statement you can call stored procedure.

Code: Select all


 EXEC SQL
          CALL PROC1(:NUM,:NAME)
 END-EXEC.


shailesh.joshi
Member
Posts: 3
Joined: Sat Nov 24, 2007 4:00 pm
Location: Hyderabad

Post by shailesh.joshi » Mon Dec 03, 2007 12:02 pm

Thanks Krishna,

can u please tell me in what case we use this stored procedure in cobol.
and (who and how) this procedure are loaded in Data base server.
is it possible for us to create our own procedure...

Thanks again for quick reply..... :)
Think,communicate and do it.

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others