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

How to identify a stored procedure in our application
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
bh

New User


Joined: 19 Mar 2006
Posts: 26
Location: India
PostPosted: Sun Mar 26, 2006 1:01 pm
 Reply with quote
Hi !

How to identify a stored procedure in our application ?

Regards,
bh
Back to top
View user's profile Send private message
T-REXDB2

New User


Joined: 28 Apr 2005
Posts: 11
Location: USA
PostPosted: Mon Mar 27, 2006 7:39 am
 Reply with quote
bh wrote:
Hi !

How to identify a stored procedure in our application ?

Regards,
bh


Hope this helps...... ;-]

An example straight from the z/OS DB2 Application Programming & SQL Guide:

publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/dsnaph15/6.2.2?DT=20050720111055#HDRQXMPST
Back to top
View user's profile Send private message
rajakumar10

New User


Joined: 03 Aug 2005
Posts: 12
PostPosted: Wed Mar 29, 2006 9:21 pm
 Reply with quote
Stored procedures are always coded between EXEC SQL & END EXEC
E.G.
Consider I have a stored procedure TEST12 then the code will look like this..

EXEC SQL
CALL TEST12 (:WS-DATA1)
END-EXEC
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 -> DB2

 

Similar Topics
Topic Forum Replies
No new posts 10 byte RBA conversion -non applicati... JCL & VSAM 1
No new posts DB2 Event passed to the Application P... DB2 1
No new posts How to identify the transaction categ... IMS DB/DC 3
No new posts Identify Program Insert DB2 7
No new posts Invoke stored procedure via batch JCL. DB2 2
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us