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: : 159663
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159663'
The Shares Amount is 9000000
The cusip is 37950E507
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '37950E507'
Number of Rows :10
update current13Fpositions set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129' ,
percentOut = '0'
where entryId = '51354653'
update current13Fpositions set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129' ,
percentOut = '0'
where entryId = '98135117'
update current13Fpositions set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129' ,
percentOut = '0.74'
where entryId = '65086519'
update current13Fpositions set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129' ,
percentOut = '0'
where entryId = '131350511'
update current13Fpositions set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129' ,
percentOut = '0'
where entryId = '132610008'
update current13Fpositions set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129' ,
percentOut = '0'
where entryId = '131375312'
update current13Fpositions set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129' ,
percentOut = '151.58'
where entryId = '116078156'
update current13Fpositions set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129' ,
percentOut = '0'
where entryId = '130736509'
update current13Fpositions set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129' ,
percentOut = '0'
where entryId = '131345313'
update current13Fpositions set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129' ,
percentOut = '0'
where entryId = '132618594'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '37950E507'
Number of Rows :186
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '66985691'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '68084802'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '68054642'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '68024843'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '68031229'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '64557987'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '66351025'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '66320452'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '66285604'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '65352033'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '63391086'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '63725367'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '64591374'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '64632457'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '64551434'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '69132258'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '69971878'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '69557635'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '69591537'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '69968089'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '70721567'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '71614486'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '71402477'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '71678247'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '71607863'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '72481716'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '73607012'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '73426675'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '73738080'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '73600202'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '74132321'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '75592400'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '75248578'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '75547487'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '75512199'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '75630516'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '75032801'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '76055486'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '77521307'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '77614055'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '76207060'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '77380710'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '77043164'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '79530086'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '78021420'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '79425493'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '78670785'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '78853524'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '79292092'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '79372557'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '80902103'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '80469569'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '81017335'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '81179214'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '81380529'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '81597853'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '82423831'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '82605415'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '83071851'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '83206148'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '83439780'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '83615317'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '84206189'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '84683060'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '84899150'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '85302377'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '85556228'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '87622516'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '86958126'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '87153524'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '87681588'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '89158675'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '89334118'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '90950217'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '91210028'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '91646970'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '93149027'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '93310329'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '93922764'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '95274592'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '66279379'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '95629753'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '95724579'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '96223301'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '97802334'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '98151841'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '99256273'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '100623835'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '100546795'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '102139115'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '103012815'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '104050766'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '104840764'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '105601410'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '106449704'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '106648727'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '106839480'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '107958928'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '106541756'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '107169442'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '107265123'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '108314453'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '109653064'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '110125816'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '110719574'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '109114633'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '108882018'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '109907444'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '110095168'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '110369530'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '110777335'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '110606069'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '111464848'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '112048114'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '111620807'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '111860688'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '111925010'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '112267372'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '112551097'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '112809857'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '113465545'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '113305973'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '113349742'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '113100638'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '114143091'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '114021201'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '114881639'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '114772753'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '115822766'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '115767572'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '115955282'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '114836069'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '115726026'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '115618388'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '115928228'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '114803668'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '116507775'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '116728221'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '118631950'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '118594346'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '116885581'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '117237395'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '118635386'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '115444134'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '118684730'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '118480513'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '117994998'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '116496919'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '118360005'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '119187011'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '119083423'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '120159195'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '120309093'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '120310210'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '121324580'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '120636660'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '119902715'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '120708710'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '120179139'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '121192470'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '121255840'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '121374286'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '122456364'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '122237714'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '123217093'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '122636577'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '123233708'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '123185406'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '124000387'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '123987537'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '123936804'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '123223019'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '122977424'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '124028050'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '124932171'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '124462853'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '125036473'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '126589191'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '126306396'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '126461868'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '127861210'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '128326136'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '129418611'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '128410999'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '129295718'
update archive13F set
compid = '159663',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004129'
where entryId = '127972515'
End Function
The Script is complete, exiting....