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: : 167147
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167147'
The Shares Amount is 9000000
The cusip is 00857F118
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '00857F118'
Number of Rows :5
update current13Fpositions set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492' ,
percentOut = '138.89'
where entryId = '120808315'
update current13Fpositions set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492' ,
percentOut = '0'
where entryId = '132545125'
update current13Fpositions set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492' ,
percentOut = '0'
where entryId = '127778707'
update current13Fpositions set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492' ,
percentOut = '0'
where entryId = '127304853'
update current13Fpositions set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492' ,
percentOut = '52.01'
where entryId = '132095237'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '00857F118'
Number of Rows :186
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '103805213'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '104441022'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '104514437'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '105176365'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '103621715'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '104618121'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '104921681'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '105001738'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '105018624'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '105045535'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '105161202'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '105191348'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '105247217'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '105292434'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '105305441'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '105409163'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '105159238'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '105969576'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '106228595'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '106842428'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '107132764'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '106445571'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '106626205'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '106788573'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '107135675'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '108082443'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '107839022'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '108076196'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '107098530'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '108086202'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '107470843'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '107511413'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '107785175'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '107698656'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '107717298'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '107722005'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '107764978'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '107820501'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '107954800'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '108259934'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '108505865'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '108474146'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '108751421'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '110008883'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '108823233'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '109540388'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '110447773'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '110438707'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '109632005'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '110536808'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '109110326'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '110858002'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '109672749'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '110869559'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '110273892'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '110316833'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '110444265'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '110448653'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '110752368'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '110657732'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '111140838'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '111428925'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '111595147'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '111597287'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '113356200'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '112342367'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '111591210'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '112345110'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '111920660'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '112243793'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '112373528'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '112944328'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '112982132'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '113004432'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '113136212'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '113141905'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '113148247'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '113346213'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '113656897'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '114527481'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '114877324'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '114551259'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '114572064'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '115619214'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '115447955'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '115070898'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '115131351'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '115429932'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '114553325'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '115419671'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '114516485'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '115096483'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '115421844'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '114528513'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '115763942'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '116623326'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '118133193'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '117145416'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '118270468'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '117156654'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '118700687'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '117128869'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '116608247'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '118089811'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '117767207'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '118562716'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '118058475'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '118095539'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '118559023'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '116492746'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '118594951'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '118056454'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '118356052'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '117810019'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '119174868'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '120181799'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '120555208'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '120203376'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '120299305'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '120309857'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '120195712'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '120311843'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '120704537'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '120330720'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '120858219'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '120814416'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '120926692'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '121119535'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '121075850'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '121073855'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '120822652'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '121553479'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '122452131'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123720236'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '122873275'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123864571'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123233516'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123248607'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123716204'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123714886'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123463759'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '122865776'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123424759'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123259576'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '122960259'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123180138'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123495827'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123816683'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123689780'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123514147'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '123691726'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '126118588'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '124367884'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '125179346'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '126152731'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '124458675'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '124098231'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '126158860'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '126822669'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '125691087'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '125762276'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '125791457'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '125805534'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '126118144'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '126271412'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '126334413'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '126499396'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '126582623'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '126897025'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '126899147'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '127784613'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '128370526'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '129667760'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '129759004'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '129666260'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '129306738'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '129739459'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '127789489'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '129173563'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '129763565'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '129729523'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '129692109'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '129695410'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '129697775'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '129762627'
update archive13F set
compid = '167147',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006492'
where entryId = '129698880'
End Function
The Script is complete, exiting....