Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

COBOL-DB2 sample Stored procedure program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests
View previous topic :: :: View next topic  
Author Message
sakthivel_t100
Warnings : 1

New User


Joined: 03 Aug 2007
Posts: 10
Location: chennai

PostPosted: Fri Aug 17, 2007 6:59 pm    Post subject: COBOL-DB2 sample Stored procedure program
Reply with quote

HI ALL,
Please Any one help me.
I need Simple Stored procedure program with example using COBOL-DB2 ?
Note : I having theory material for stored procedure,if possible could give me simple program.

Thanks in Advance
Back to top
View user's profile Send private message

kgumraj2

New User


Joined: 01 Aug 2007
Posts: 42
Location: Hyderabad

PostPosted: Fri Aug 17, 2007 7:12 pm    Post subject:
Reply with quote

Hi,

This is the Main Logic

Code:
0030-CALL-ST-PROCEDURE.                               
                                                     
     EXEC SQL                                         
          CONNECT TO PHX_DEV                         
     END-EXEC.                                       
                                                     
     EXEC SQL                                         
          CALL PHOENIXR.SP_SUB_SELECT                 
          ( :WS-SOURCE-NAME,                         
            :WS-DATE,                                 
            :WS-RETURN-CODE:WS-NULL-RETURN-CODE,     
            :WS-ERROR-MESSAGE:WS-NULL-ERROR-MESSAGE   
          )                                           
     END-EXEC.                                       


here ws-source-name and ws-date we pass through parm
and ws-return code and error message are the variable we get from stored procedure..
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> HomeWorks & Requests All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts XML Parse for COBOL 5.2 Bhanu Praveen COBOL Programming 1 Sat Jul 08, 2017 8:58 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Dynamic output file creation in cobol... smileheal COBOL Programming 7 Thu Jun 15, 2017 10:53 pm
No new posts Search utility(3.14) using JCl and Cobol RKS3 COBOL Programming 12 Sat Jun 10, 2017 10:24 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us