To do multible compids, use the following script:
php /var/www/html_j3sg/institutions/ChangeCompidOfAllInstitutionalAfewCompaniesAtATime.php
Please note that the script mentioned above (ChangeCompidOfAllInstitutionalAfewCompaniesAtATime) only updates the current13FFilingpositions table, no archived tables.
This script actual updates 13F current table as well as both archive13F tables.
We got coming in compid: : 168571
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168571'
The Shares Amount is 0
The cusip is 00653H201
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '00653H201'
Number of Rows :2
update current13Fpositions set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584' ,
percentOut = '0'
where entryId = '105661760'
update current13Fpositions set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584' ,
percentOut = '0'
where entryId = '130467906'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '00653H201'
Number of Rows :165
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '98679846'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99330890'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102216507'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99151541'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99406991'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99517681'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99525255'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99818265'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99852983'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100455602'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100755807'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99252641'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99381058'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99424863'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99476689'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99594451'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99663547'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99683797'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99739848'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99759809'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99775758'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '99814574'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '103193335'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100587243'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '98622886'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100379724'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100406542'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100417780'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100423316'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100465512'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100489563'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100493243'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100508758'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100686944'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100422554'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100746259'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '100979700'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '103194715'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102080404'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102439421'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '103074648'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102345148'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '101210739'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102383470'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102092154'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102135257'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102316278'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102439068'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102431210'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102080035'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102066973'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '101522630'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102069407'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '101709763'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102088723'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102178921'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102216830'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102225648'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102352939'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102416460'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102992359'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102998131'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102755815'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '103000538'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '103017366'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102796460'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '103008463'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102840798'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '103008161'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '103116678'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102821915'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '103243485'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '102435952'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '103706043'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '104114825'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '103985663'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '104046737'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '104804562'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '104514426'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '105118690'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '103741769'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '104560445'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '105001560'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '105057213'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '105085480'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '105505874'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '105274959'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '105292412'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '105326586'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '105451519'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '105673298'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '105524870'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '105621928'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '105921477'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '106124712'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '107212300'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '106445435'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '106626190'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '107800725'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '107867824'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '108137808'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '108025300'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '108245655'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '108090731'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '108236529'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '106542913'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '107451612'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '107525350'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '107820476'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '107889849'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '108727958'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '109189444'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '109834571'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '109717430'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '110387009'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '109631992'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '110536780'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '110255457'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '109110180'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '113450813'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '110047105'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '110329873'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '110598053'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '111220894'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '111475936'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '111718123'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '111593705'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '110107109'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '112342354'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '112042338'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '111920513'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '112148639'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '112373501'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '112749614'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '113462478'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '113490039'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '113690392'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '114752723'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '114877178'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '114026166'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '114391589'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '114551247'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '115619188'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '115222663'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '114169883'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '116283529'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '118407342'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '117145390'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '117886271'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '117128859'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '116878466'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '117359114'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '115914052'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '116492609'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '119068446'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '120604747'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '120597644'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '120625338'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '120704400'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '120604441'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '120588989'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '121336916'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '122451995'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '124458548'
update archive13F set
compid = '168571',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001823584'
where entryId = '127856980'
End Function
The Script is complete, exiting....