Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Where to get sample for processing RM... vice_versa PL/I & Assembler 2 Tue Jan 16, 2018 2:03 pm
No new posts KSDS and Index file in cobol deepak14450 COBOL Programming 9 Fri Dec 22, 2017 9:36 am
No new posts CICS web service from DB2 Triggers or... kiranprasad DB2 1 Wed Dec 20, 2017 11:10 am
No new posts The same REXX program doesnt work for... jackzhang75 CLIST & REXX 5 Wed Dec 06, 2017 2:51 am
This topic is locked: you cannot edit posts or make replies. Cobol to fetch the content by using s... arunc55 COBOL Programming 4 Fri Nov 17, 2017 1:25 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us