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: : 160387
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '160387'
The Shares Amount is 9000000
The cusip is 22542D316
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '22542D316'
Number of Rows :3
update current13Fpositions set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545' ,
percentOut = '0.19'
where entryId = '82113364'
update current13Fpositions set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545' ,
percentOut = '0.04'
where entryId = '89553490'
update current13Fpositions set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545' ,
percentOut = '53.33'
where entryId = '97978377'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '22542D316'
Number of Rows :170
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '78490197'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '79862843'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '79736645'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '79860544'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '80195240'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '80836682'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81128970'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81581737'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81588314'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81015916'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81038492'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81214257'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81345733'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81380157'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81423612'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81597167'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81725752'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81841281'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '82169304'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '82139646'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81864017'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '81726825'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '82736100'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '82921426'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '83559480'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '82941556'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '82970876'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '83070383'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '83570671'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '83268523'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '83389378'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '83396468'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '83439403'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '83461800'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '83614536'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '82868256'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '83385888'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '83778210'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '84504561'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '84614161'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85270753'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '84526479'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '84681540'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '84752363'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85494895'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '84992694'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85005614'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85505707'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85229538'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85240384'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85302033'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85544392'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85366452'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85405376'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85626773'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85654614'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85477012'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '85772737'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '86607267'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '86768743'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '86220001'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '86655701'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87724697'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87673489'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87500453'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '86179231'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87688728'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '86956567'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87012067'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87650255'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87652539'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87698547'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87446028'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87459410'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87682205'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87871297'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87925935'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '89283954'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '88437847'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '88869123'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '89534037'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '89765928'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '87942245'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '89066605'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '89157063'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '89536770'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '89738242'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '89655190'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '89206874'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '90080993'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '90291365'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '90044100'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '90162964'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '88527999'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '90843496'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '90662394'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '90661548'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '90084629'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '90645930'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '91133427'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '91529967'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '91708239'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '90655627'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '90948560'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '91504398'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '91500178'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '91487704'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '91875713'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '91490257'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '91933891'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '91646215'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '92080123'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '92199596'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '92285032'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93549773'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93043823'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93464046'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93967929'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93036238'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93867282'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93811637'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93075981'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '92233449'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93005766'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93147595'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93525164'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93309372'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93485003'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93528555'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93535188'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93540685'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93544766'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93921818'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '93991320'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '94404317'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '94245761'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '94405905'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '95223164'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '95589011'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '94729770'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '94724903'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '95246797'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '95180129'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '95471748'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '95587725'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '95986647'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '95985763'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '95999193'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '96000750'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '95972935'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '95982076'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '95986354'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '95985046'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '97600096'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '97268954'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '99776205'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '102353453'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '104528942'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '105275438'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '106648208'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '107801341'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '110520078'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '109998017'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '111620292'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '113247341'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '115597443'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '115954843'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '118250846'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '121198066'
update archive13F set
compid = '160387',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004545'
where entryId = '123989930'
End Function
The Script is complete, exiting....