MVSFORUMS.com

[icon]

say i have to update 1000 unique records, is there a db2 utility out there that can do this? is there something built into spufi to do this?

update table
set field_2 to aaa
where field_1 = xxx;

i have a file that contains values for aaa and xxx.

my alternatives are:
1) write a cobol program
2) write 1000 iterations of the sql statement
3) others??

tia

[kolusu]

icon,

Please search before posting. check these links which discuss the updation of DB2 table.

http://www.mvsforums.com/helpboards/viewtopic.php?t=3369&highlight=sqlcards

http://www.mvsforums.com/helpboards/viewtopic.php?t=2787&highlight=sqlcards

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu