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: : 167149
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167149'
The Shares Amount is 9000000
The cusip is 60879E119
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '60879E119'
Number of Rows :16
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '34.94'
where entryId = '131714743'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '55.01'
where entryId = '130084593'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '47.62'
where entryId = '130700266'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '555.56'
where entryId = '115401532'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '0.47'
where entryId = '132234795'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '1818.25'
where entryId = '131672797'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '599.39'
where entryId = '130653808'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '0'
where entryId = '132651463'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '38.32'
where entryId = '131177491'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '0'
where entryId = '130474908'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '733.93'
where entryId = '132272889'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '17.35'
where entryId = '131672956'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '150.61'
where entryId = '132215496'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '2472.22'
where entryId = '131473411'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '0'
where entryId = '132580718'
update current13Fpositions set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494' ,
percentOut = '663.31'
where entryId = '130544099'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '60879E119'
Number of Rows :165
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '104428611'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105011993'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105018932'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105054611'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105116611'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105267777'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105293915'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105295735'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105297815'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105384303'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105399769'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105430943'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105441405'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105442180'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105611573'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105160114'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '105282965'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '106452510'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '106515123'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '106562454'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '106788690'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '107102321'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '107828252'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '107797146'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '108086089'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '108086596'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '107510582'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '107600167'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '107821858'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '107825578'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '107919784'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '107945695'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '107992606'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '107998536'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '108007219'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '108129480'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '108258304'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '108316212'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110061130'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '108261165'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '109856698'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110021572'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '109500897'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110538125'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110769147'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '109117524'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '109409208'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '109660520'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110873836'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110728251'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110386613'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110402777'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110528180'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110541655'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110624162'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110652696'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110768926'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '110687547'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '112052145'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '112808136'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '111927929'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '112252748'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '112261955'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '112775923'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '112579011'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '112829289'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '113065950'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '113087207'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '113143229'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '113253931'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '113260890'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '113262227'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '113316766'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '113335267'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '113387862'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '111398618'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '114277591'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '115941477'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '114884578'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '114402642'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '115627552'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '115864636'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '115347135'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '115701278'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '115234250'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '115626378'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '115605803'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '115420987'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '115389601'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '115587685'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '115752985'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '115437531'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '116659183'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '116673584'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '118614523'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '116890110'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '118418388'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '117910603'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '117389367'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '118536133'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '117707736'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '118340991'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '117507661'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '116499777'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '117982049'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '118057670'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '118565134'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '118258673'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '119152537'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '119468076'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '119594291'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '121292953'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '120702334'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '121206031'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '119906704'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '120711568'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '120832230'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '120982242'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '121241439'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '121384825'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '121075033'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '120915214'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '122024101'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '122323063'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '122459254'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '122640306'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '121954537'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '122693168'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '123133011'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '123582959'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '122361546'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '123434794'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '123500720'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '122973840'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '123828262'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '123992415'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '123788966'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '124465746'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '124629247'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '125377079'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '125117062'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '125277506'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '125519873'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '125618140'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '125697417'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '125796301'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '126795546'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '126301536'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '126369990'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '126786996'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '126514948'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '124355418'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '129804820'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '128372589'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '127864019'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '128849551'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '129286639'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '129290874'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '128672735'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '128672282'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '129344385'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '128776819'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '129686862'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '128398514'
update archive13F set
compid = '167149',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006494'
where entryId = '129802882'
End Function
The Script is complete, exiting....