Tags for #UPDATE
Mload Update: Records are not getting updated
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.
multiload Mload - 2797 mload #UPDATE char
update syntax
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;
swap values in two columns using update SQL
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: T1A B 2 1 4 3 6 5
swapping #UPDATE
help required for a update scenario
Hi, We have a customer group with some customer under it with different product. Need to update a value for below scenario.
Update statement with recursive function
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
#Update multiple time #UPDATE