Performance Issue Using Original Script With SQL Alter UPDATE in PI35

Hi Team,

We are doing PeopleSoft Image  update from PI 01 TO PI 35 as part of the alter scripts there is three sql statement

UPDATE PS_CLOSE_LEDG_LOG SET SCE_ID = ' ' - This has close to 7 lakh rows to be updated

UPDATE PS_DISTRIB_LINE SET AMORT_TYPE = ' ', AMORTIZATION_ID = ' ' -This has 12460155 rows to be updated

UPDATE PS_JRNL_LN SET ACCOUNT_CODE = ' ', SCE_ID = ' ', SOURCE_DATA = ' ', TAS_GWA = ' ', BETC_CD = ' ', JRNL_LINE_ORIG_SRC = ' ' - This has 7 crores rows

Please let us know how to run the below sql in our FINDEV database so that it completes.