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: : 163982
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '163982'
The Shares Amount is 17460000
The cusip is 172967341
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '172967341'
Number of Rows :1
update current13Fpositions set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327' ,
percentOut = '56.37'
where entryId = '56974593'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '172967341'
Number of Rows :220
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '66860494'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '67502232'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '67393783'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '65585784'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '67019699'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '66723470'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '67065774'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '66625108'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '66404543'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '65370383'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '65991035'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '65023675'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '65385776'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '65257487'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '65129796'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '63361343'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '63669083'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '63742902'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '63539818'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '64075221'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '64867510'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '68803998'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '68735729'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '68641479'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '68498500'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '68611608'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '68891142'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '69938817'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '70012449'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '70080126'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '70180530'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '70143564'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '70261330'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '70063065'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '70083371'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '70427445'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '71718711'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '71154410'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '72085558'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '72061187'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '72133071'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '72109091'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '72259808'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '72446529'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '72317643'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '73130102'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '73004816'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '73309526'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '73989938'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '73832502'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '73998628'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '73928098'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '73924625'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '73936256'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '74049630'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '73959192'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '75217976'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '75045029'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '75813350'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '76612407'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '75900291'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '76141028'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '76167065'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '75954434'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '77363350'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '75949149'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '77627988'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '77654716'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '79911649'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '77961391'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '77828581'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '78570514'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '77923181'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '78128060'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '79477017'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '78927912'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '79816674'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '79841870'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '80150112'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '80184741'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '80046274'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '80335901'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '79896932'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '80624278'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '81721832'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '81729510'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '81788131'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '81795728'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '82036406'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '82153939'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '83023329'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '82620143'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '82758686'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '83100254'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '83917812'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '83765604'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '84200006'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '83787249'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '84007377'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '83906240'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '84923216'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '84654342'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '85516164'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '84950079'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '85762587'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '85879868'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '85965555'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '84563732'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '86052926'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '86087991'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '86154793'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '86383863'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '86681883'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '86922650'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '87762509'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '88077743'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '87890453'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '88009246'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '88014193'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '88119072'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '88692649'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '88573524'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '89863355'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '90340548'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '90076641'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '90610711'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '90178604'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '90094764'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '90853146'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '90265777'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '91830798'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '92084870'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '92531548'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '93931460'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '93892866'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '93510382'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '93063133'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '93864995'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '94333071'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '94201732'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '94287783'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '94404365'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '94912251'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '94955938'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '95161591'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '96172993'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '96070573'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '96284498'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '96992508'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '97588706'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '98104927'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '98917099'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '98415241'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '99465814'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '100676401'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '98732331'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '100755014'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '101673749'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '103118816'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '103534878'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '102399186'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '103588041'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '104231020'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '104785388'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '104813098'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '105799506'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '106506758'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '106999539'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '108056024'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '108352869'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '109695443'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '109267206'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '109988479'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '109512495'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '109906098'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '111637704'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '111076381'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '112750722'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '112777150'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '112660517'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '113783086'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '111339442'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '114718030'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '115926868'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '116092589'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '113886150'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '116305817'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '117380579'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '118478948'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '116913875'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '118831191'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '118925396'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '120558732'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '120871772'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '121560153'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '121657716'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '122991976'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '123324787'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '122624704'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '123183959'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '124293586'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '124720881'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '126623210'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '125738108'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '129647912'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '129649050'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '129650361'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '129651549'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '129652663'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '129653770'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '129670045'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '125231713'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '125521846'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '126587328'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '127774616'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '127790485'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '129681283'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '129868864'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '129685267'
update archive13F set
compid = '163982',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000005327'
where entryId = '129759602'
End Function
The Script is complete, exiting....