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: : 160388
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '160388'
The Shares Amount is 90000000
The cusip is 902973833
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '902973833'
Number of Rows :6
update current13Fpositions set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546' ,
percentOut = '2.93'
where entryId = '42088360'
update current13Fpositions set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546' ,
percentOut = '1.11'
where entryId = '42099262'
update current13Fpositions set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546' ,
percentOut = '0.87'
where entryId = '42150403'
update current13Fpositions set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546' ,
percentOut = '1.33'
where entryId = '42193201'
update current13Fpositions set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546' ,
percentOut = '1.02'
where entryId = '47725976'
update current13Fpositions set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546' ,
percentOut = '0'
where entryId = '78504725'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '902973833'
Number of Rows :213
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '67504944'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '67183916'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '67977910'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '67543876'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '67930062'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '67755389'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '67226660'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '67394254'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '66180354'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '65812112'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '66723378'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '66238886'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '66857160'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '67547587'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '66728986'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '66627844'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '65590611'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '66405032'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '66065300'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '66520639'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '65062206'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '65023580'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '65392102'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '65302326'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '63361254'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '63377660'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '63481781'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '64110328'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '64960300'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '64304107'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '64079912'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '63882048'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '64118071'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '64432629'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '64490046'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '64870251'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '68404595'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '68635622'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '68498410'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '69017738'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '69346197'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '69938841'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '70012976'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '69912889'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '69032060'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '69961142'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '70074279'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '70143475'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '70084184'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '70170280'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '70450512'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '70776236'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '71116817'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '71719247'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '71570465'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '71185750'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '71157198'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '71358107'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '72064068'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '72728376'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '72109081'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '72446831'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '72799963'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '72568864'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '73766034'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '73743107'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '72550874'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '73130158'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '73576153'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '73312317'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '73826256'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '73957497'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '74705688'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '73959487'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '74534467'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '74633412'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '74494230'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '75622082'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '75047848'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '76039477'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '75748849'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '76613260'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '76421626'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '76525019'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '76395550'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '76173442'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '77628090'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '77743220'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '77828882'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '78595097'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '78203639'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '78328134'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '78312771'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '77683840'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '78396004'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '78404615'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '79908230'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '79781832'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '79816989'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '80684037'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '80566159'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '80397541'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '79804748'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '80037772'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '80030574'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '79897316'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '80953825'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '81673775'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '81722163'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '81771634'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '81710024'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '83298916'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '83669355'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '83528101'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '82456349'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '82524585'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '83100848'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '83629271'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '82164469'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '83679422'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '83918009'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '83765962'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '84589483'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '84113540'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '83703537'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '84357129'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '84654421'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '85516096'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '84591913'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '85765519'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '85958070'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '85880223'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '86117818'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '84565152'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '86292433'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '86366789'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '86922723'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '87767766'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '88369312'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '87820370'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '87890818'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '88144244'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '88255819'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '88573595'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '89812963'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '89922358'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '90146408'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '90123218'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '90266161'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '91830870'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '90410739'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '92039700'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '92211961'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '93510807'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '92914327'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '93979356'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '93865261'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '94004299'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '94333461'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '94263642'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '94721674'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '94476638'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '95573005'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '96059550'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '96246921'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '96070950'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '96151233'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '96152294'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '96426642'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '96936409'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '97561520'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '98414195'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '98387386'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '98720856'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '98721294'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '98714623'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '98902800'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '100055370'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '98732695'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '100747633'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '100900649'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '101253484'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '101330717'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '103534854'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '102400190'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '101492752'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '103262524'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '103565700'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '103634674'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '103780219'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '103834673'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '104813073'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '104748068'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '100901087'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '105714015'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '108204266'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '106062415'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '107210061'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '106813791'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '107001031'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '105780353'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '106214669'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '108428663'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '108586401'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '110829209'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '110904443'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '91932478'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '112736197'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '110016441'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '110010688'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '108420621'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '38278637'
update archive13F set
compid = '160388',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004546'
where entryId = '125369492'
End Function
The Script is complete, exiting....