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
 

 

When I am looking into the table ,the table is not updated

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

New User


Joined: 14 Mar 2007
Posts: 24
Location: gurgaon

PostPosted: Thu May 17, 2007 10:20 am    Post subject: When I am looking into the table ,the table is not updated
Reply with quote

Hi
I am facing a trouble in updating the table.
The problem is when i am executing the program and displaying the values after the update query , the values are updated values.

But when I am looking into the table ,the table is not updated.
Back to top
View user's profile Send private message

Phrzby Phil

Active Member


Joined: 31 Oct 2006
Posts: 962
Location: Richmond, Virginia

PostPosted: Thu May 17, 2007 5:42 pm    Post subject:
Reply with quote

I thought rows are updated, not columns, and that it is the rows that are indexed.
Back to top
View user's profile Send private message
krishnasaikiah

New User


Joined: 14 Mar 2007
Posts: 24
Location: gurgaon

PostPosted: Fri May 18, 2007 8:45 am    Post subject: Re: Update in the oreder of Clustering Index
Reply with quote

I am updating a particular column and it is not getting updated into the table but while i am executing the same update query in spufi, it is updating the table as desired.

Somebody if finds a clue to what should be the solution to my problem,please help .

thanks,
Krishna
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat May 19, 2007 2:36 am    Post subject:
Reply with quote

Hello,

It sounds like your update is not being committed or something is specifically causing a rolback.
Back to top
View user's profile Send private message
krishnasaikiah

New User


Joined: 14 Mar 2007
Posts: 24
Location: gurgaon

PostPosted: Mon May 21, 2007 11:03 am    Post subject:
Reply with quote

ya thanks dick...
m trying to figure out the problem...though not yet successful.
Back to top
View user's profile Send private message
kgumraj

Active User


Joined: 01 May 2006
Posts: 151
Location: Hyderabad

PostPosted: Mon May 21, 2007 10:33 pm    Post subject:
Reply with quote

Hi,

We too had similar problem, I feel it is with the variables declared.
Check whether the precomplilation step is warnig free, if it has waring dont ingnore that.

We approched this by moving FD variable to WS and then inserted/ updated it worked fine..

beter check this..
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue May 22, 2007 3:11 am    Post subject:
Reply with quote

Hello,

As a test, you could put a checkpoint in the code just after the update and end the program. The update should be in the table at that time. If the updated data is in the row(s), the code is either never issiung as checkpoint or it is (or some called module is) issuing a rollback.

Good luck and we're here when you have news icon_smile.gif
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 unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am


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