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
 

 

Updating uncommitted row

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

New User


Joined: 11 Jul 2010
Posts: 21
Location: Bangalore

PostPosted: Thu Feb 03, 2011 4:10 pm    Post subject: Updating uncommitted row
Reply with quote

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
View user's profile Send private message

GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Thu Feb 03, 2011 4:30 pm    Post subject:
Reply with quote

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
View user's profile Send private message
anju subrahmanian

New User


Joined: 11 Jul 2010
Posts: 21
Location: Bangalore

PostPosted: Thu Feb 03, 2011 4:59 pm    Post subject:
Reply with quote

Application which calls my process is a .Net front end application
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Feb 03, 2011 5:30 pm    Post subject:
Reply with quote

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
View user's profile Send private message
anju subrahmanian

New User


Joined: 11 Jul 2010
Posts: 21
Location: Bangalore

PostPosted: Thu Feb 03, 2011 5:45 pm    Post subject:
Reply with quote

.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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Feb 03, 2011 6:32 pm    Post subject:
Reply with quote

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
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
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts Updating the counters after eliminati... PANDU1 DFSORT/ICETOOL 12 Mon Nov 21, 2016 9:47 am
No new posts Updating Cursor row withour using FOR... chandan.inst DB2 15 Tue Nov 08, 2016 11:17 am
No new posts Updating online Db2 table kishpra DB2 3 Fri Aug 12, 2016 2:44 pm
This topic is locked: you cannot edit posts or make replies. Updating value of key using rewrite s... ParminderKumar COBOL Programming 4 Thu Aug 04, 2016 12:46 am


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