0 - 5 of 5 tags for #UPDATE

Hello All,
I am running a mload job. In the source file, the fields are having different data types like Decimal, Char & Varchar. But when i am running the job, major volume of records are going to error tables with error code 2797 (saying MLoad MARK MISSING UPDATE). That means its not finding records with given where conditions.

table_1
(
c1 int
,c2 int
,c3 int
);

insert into table_1 values (1,2,3);

update table_1
set c2 = c2 + 5 --c2's value suppose to be 7 now
,c3 = c2 + c1; --c3's value suppose to be 7 + 1 = 8 now

select c1, c2, c3 from table_1;

How can I swap both column values using only update statement? No Alter table permitted.
Table: T1 
A B
1 2
3 4
5 6
 
After execution the table will look like:
Table: T1
A B
2 1
4 3
6 5

Hi,
We have a customer group with some customer under it with different product. Need to update a value for below scenario.

Hi
 
I am looking to update a Row like when ever it finds a word THE it should replace with THERE.
 
I tried to update using the BTEQ with repeat it was working fine but i need to mention how many times to repeat can you guys help me any other way. OREPLACE dosen't work in my environment.
 
Eg:
Table having