IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

COBOL-DB2 sample Stored procedure program


IBM Mainframe Forums -> HomeWorks & Requests
Post new topic   Reply to topic
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> HomeWorks & Requests

 


Similar Topics
Topic Forum Replies
No new posts IDCAMS listcat service using cobol JCL & VSAM 1
No new posts Make cobol variable value a variable COBOL Programming 3
This topic is locked: you cannot edit posts or make replies. Internal Autonomous Stored Procedure ... DB2 6
No new posts how to convert and use 1 bit hex-numb... COBOL Programming 10
No new posts VB file copy COBOL program gives erro... COBOL Programming 3
Search our Forums:

Back to Top