View previous topic :: View next topic
|
Author |
Message |
anju subrahmanian
New User
Joined: 11 Jul 2010 Posts: 21 Location: Bangalore
|
|
|
|
I have to update a row inserts by another process, but row insert is uncommitted. Detailed explanation below
One process inserts a row to table, but before commtting row insert it calls my process. And my process have to update one column of this row and then will return control back to the first process. Then first process will committ all changes.
My question is, is it possible to update a column which is uncommitted as explained above? |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
what kind of call ?
If we're talking COBOL : all calls run in the same thread / same Logical unit of work, so no problem there.
if we're talking about different java threads to DB2 , then it's a different story |
|
Back to top |
|
|
anju subrahmanian
New User
Joined: 11 Jul 2010 Posts: 21 Location: Bangalore
|
|
|
|
Application which calls my process is a .Net front end application |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
Application which calls my process is a .Net front end application |
absolutly no information.....
is this a question?
did you not understand what GuyC tried to explain?
process is a term used to describe something.
a process is not called. a process is.
use the correct terminology and you will get an answer.
(the exercise of determining the correct terminology will probably provide you the answer.) |
|
Back to top |
|
|
anju subrahmanian
New User
Joined: 11 Jul 2010 Posts: 21 Location: Bangalore
|
|
|
|
.Net front end aplication inserts a row to table, but before commtting row insert it calls my CICS program. And my program have to update one column of this row and then will return control back to .Net application. Then .Net application will committ all changes.
Sorry for using wrong terminologies........... |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
anju subrahmanian,
excellent explanation. (hope my answer is also)
now the .net front end INSERT creates a task on the mainframe.
the invocation of the CICS program is a second task.
The second has no update access to the first.
why don't you get the info from the CICS program first, then insert the row?
or
use a stored procedure - to perform the cics program stuff
- make the insert
or
.net makes the insert
.net commits
.net calls cics |
|
Back to top |
|
|
|