Add data to col only which is newly added through batch

guptae · Posted: Wed Oct 11, 2006 11:27 am

Hi,

Would u please tell me is there any utility by which we can data to only that coloum which is newly added?

Suppose we have a db2 table that contain 3 coloum now we added another coloum lets say field-d &now we have to insert values for only field-d through batch

surya_pathaus · Active User Joined: 28 Aug 2006 Posts: 110

Hi Ekta,

Whether you want to Insert static value to all rows or different values depending on the condition?

guptae · Posted: Wed Oct 11, 2006 6:30 pm

Hi there ,

i want to insert different value

priyesh.agrawal · Posted: Thu Oct 12, 2006 10:51 am

added another column to existing table ???

Something like this... and now you want to populate SAL based on GRADE or DEPT... am I getting it correctly ?

guptae · Posted: Thu Oct 12, 2006 11:10 am

Hi there,

Not exactly like that suppose we had a table taht contain only emp#, dept, grade. Now we have alter the table & add 1 more coloum sal.
now i want add data in sal coloum for every record through batch . i dont want to write insert query nor unload the table in to file edit the file and load it.

now I want to insert 1000,2000,3000,4000 for all the four record i have in my table through batch

I hope I make myself clear enough.

surya_pathaus · Active User Joined: 28 Aug 2006 Posts: 110

Hi,

Usually, Data will be migrated using Insert/update query or unload-edit-load method.

Lets see if any one come up with a UTILITY.....

priyesh.agrawal · Posted: Fri Oct 13, 2006 12:12 pm

Hi Ekta,

guptae · Posted: Fri Oct 13, 2006 12:16 pm

Hi priyesh,

I just want to add some randome value which is not based on any prev coloum.
I heard that can be done some utility i dont wnat to insert through SQL.

twissi · Posted: Fri Oct 13, 2006 1:39 pm

priyesh.agrawal · Posted: Fri Oct 13, 2006 7:17 pm

twissi... My understanding on this is same. Utility is not going to do anything special.

Ekta... I realized later... I was wrong in saying using a batch SQL, as you would not be able to use cursors there.... and looking at your requirement seems you'll need cursors as you want to update row by row.

guptae · Posted: Fri Oct 13, 2006 7:22 pm

Priyesh,

Like for loading a db2 table we need not require any sql is there any other utility by which we can add the data for only one coloum.

vijay_bn79 · New User Joined: 20 Nov 2006 Posts: 48 Location: Hyderabad

Hi...,

By using DB2 FILEAID utility you can insert, update and delete the values of the table

command is TSO FA
give table name and the region qualifier
and give the option like edit, browse etc...

then you can edit the table and save

Thanks