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

Need to update a field of a table


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Harish Kumar

New User


Joined: 20 Jul 2007
Posts: 4
Location: 26,leela nivas, Pari nagar, Sungam, Coimbatore

PostPosted: Fri Oct 05, 2007 11:25 pm
Reply with quote

Hi,

My requirement is to update all the values in a field of a particular table.
Can anyone tell me which utility i can use to directly give the SQL query to update the table in the parm card itself.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Sat Oct 06, 2007 4:04 am
Reply with quote

Hello,

How many rows are in the table?

If this is a test database and the number of rows is small, you could use SPUFI from a tso/ispf session.

If this any kind of production or if there is a large number of rows, you would want to run in batch.
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 Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
Search our Forums:

Back to Top