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 SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Execute TSO ACF commands from COBOL-I... supreethi.srid TSO/ISPF 0 Tue Feb 21, 2017 5:19 pm
No new posts Query on DB2 WLM stored procedures ashek15 DB2 8 Sun Feb 12, 2017 11:13 pm
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Submit job from Cobol with input data abdulrafi COBOL Programming 4 Wed Feb 01, 2017 12:41 pm


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