Tore already gave you strategy.
Tactics might include bracketing each line with if/endif, wrapping inserts in a minimal function, creating a rule or trigger, defining a smartass candidate index expression, delete afterwards or just doing or select after the process into clean table.



>>search help for dow()
>>
>>HTH
>>thomas
>>
>>>

>>>CREATE table date_step (sno n(6),datex date, subject C(20))
>>>SET DATE TO DMY
>>>
>>>INSERT into date_step(sno,datex,subject) VALUES (1,{^2022-05-02},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (2,{^2022-05-03},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (3,{^2022-05-04},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (4,{^2022-05-05},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (5,{^2022-05-06},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (6,{^2022-05-07},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (7,{^2022-05-09},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (8,{^2022-05-10},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (9,{^2022-05-11},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (10,{^2022-05-11},'science')
>>>
>>>Now I want to update record like this. 
>>>start from new date and skip Sunday
>>>
>>>
>>>INSERT into date_step(sno,datex,subject) VALUES (5,{^2022-05-02},'science')&& start from 5
>>>INSERT into date_step(sno,datex,subject) VALUES (6,{^2022-05-03},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (7,{^2022-05-04},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (9,{^2022-05-05},'science')&& skip sunday
>>>INSERT into date_step(sno,datex,subject) VALUES (10,{^2022-05-06},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (11,{^2022-05-07},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (12,{^2022-05-09},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (13,{^2022-05-10},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (14,{^2022-05-11},'science')
>>>INSERT into date_step(sno,datex,subject) VALUES (16,{^2022-05-11},'science')&& skip sunday always skip sunday
>>>...................................................
>>>
>>>

>yes but how to skip date