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
This topic is locked: you cannot edit posts or make replies. Full Time COBOL Software Development ... shally Mainframe Jobs 0 Fri Jan 20, 2017 5:24 am
This topic is locked: you cannot edit posts or make replies. COBOL Software Development Lead at Fi... shally Mainframe Jobs 0 Fri Jan 20, 2017 5:21 am
No new posts Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm


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