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
 

 

Copying data from One Cloumn to another Column in a DB2 Tabl

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

New User


Joined: 21 Mar 2007
Posts: 7
Location: Bangalore

PostPosted: Wed Oct 24, 2007 11:16 am    Post subject: Copying data from One Cloumn to another Column in a DB2 Tabl
Reply with quote

Hi,

I need to copy data from an existing column A in a Db2 table to a newly added column B for all the existing records. Once done, I need to space out the Column A values. There are other columns as well in the table.

Column A CHAR(18) NOT NULL
Column B CHAR(20) NOT NULL

As per DBA suggestion, we shouldn't use SPUFI because we will be changing too many pages without the commit. DB2 may abend the SPUFI if the updated # of pages reach the system allowable limit. Hence we need to write a one-time DB2 batch job to do this and make sure to put the COMMIT logic for say every 1000 updates.

Could anyone provide any hint on how to accomplish 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: Wed Oct 24, 2007 7:21 pm    Post subject:
Reply with quote

Hello,

One easy to do what you need is to write a bit of cobol code that declares a cursor, reads and updates the rows (moving the colA value to colB and spaces to colA in the same update) , and issues a checkpoint periodically.

You will want (or ask your dba) to create a backup of the table before you update it.
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 Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts Copying Panvalet members to PDS LOGESHWARAN K CA Products 4 Mon Mar 06, 2017 10:45 am
No new posts Overriding PS data in rexx Shaheen Shaik CLIST & REXX 8 Fri Mar 03, 2017 5:08 pm


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