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
 

 

Calling a stored procedure which is running in WLM envi

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
venkatm99

New User


Joined: 01 Jun 2006
Posts: 23
Location: Sinagpore

PostPosted: Thu Aug 17, 2006 9:36 am    Post subject: Calling a stored procedure which is running in WLM envi
Reply with quote

Hi

Iam calling a stored procedure which is running in WLM environment.

For the first 2 calls , data is transmitted properly. For the third call ,
No data is trasfered(to and fro) from calling program to stored procedure .
Since stroed procedure is running the WLM environment,it is taking the data of the 2nd calls and processing(for the 3rd call).

All the 3 calls form a Unit of Work.

In which cases , does no data is trabsfered to stored procedure?????

cheers

venkat
Back to top
View user's profile Send private message

prasadvrk

Active User


Joined: 31 May 2006
Posts: 200
Location: Netherlands

PostPosted: Thu Aug 24, 2006 7:51 pm    Post subject:
Reply with quote

A job will be running for each of the DB2 regions(eg. DSNSP01). The log of the calls to the DB2 region from which you are calling your stored procedures is kept in that job(similar to SYSOUT of other jobs). If you can have a display in the stored proc, you can very easily know which call is getting which data. If you have further questions let me know
Back to top
View user's profile Send private message
venkatm99

New User


Joined: 01 Jun 2006
Posts: 23
Location: Sinagpore

PostPosted: Fri Aug 25, 2006 11:18 am    Post subject:
Reply with quote

HI prasad

Tnx for ur reply

I used display staements in stored procedure and watched the data.

For the third call , no data is transfered ( to & fro) from the stored procedure.

Since the stored procedure is running in WLM environment, it still having the data of the previous call.Its getiing processed with the pervious call data.

But no data is transfered to the called program.

Its like no data transfer is happeneing b/w the called program and stored procedure.

I put a break point in the program which is calling stored procedure.

For the 1&2nd call , data tranfer is fine.But when it comes to third call, data transfer is not happening.

Why data transfer is not happening in the 3rd call ?????

cheers

venkat
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 -> DB2 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. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm


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