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: : 166941
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '166941'
The Shares Amount is 9000000
The cusip is 86280R886
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '86280R886'
Number of Rows :14
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '0'
where entryId = '132580592'
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '0'
where entryId = '131565760'
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '73.82'
where entryId = '130120292'
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '4.47'
where entryId = '130627480'
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '193.17'
where entryId = '129958450'
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '13.78'
where entryId = '130332696'
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '1.33'
where entryId = '130657483'
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '0'
where entryId = '103968161'
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '2.67'
where entryId = '131718759'
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '15.23'
where entryId = '131827661'
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '0'
where entryId = '130477526'
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '8.13'
where entryId = '132215757'
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '498.95'
where entryId = '129974313'
update current13Fpositions set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457' ,
percentOut = '46.84'
where entryId = '132448883'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '86280R886'
Number of Rows :165
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '88693402'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '89291943'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '89385218'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '90443515'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '90972145'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '90683379'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '90530641'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '90024821'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '90602036'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '90954913'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '93819080'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '93786162'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '92241358'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '92645519'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '92670092'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '93153121'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '93324211'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '93675903'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '94336875'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '95278798'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '94872093'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '95295983'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '95634580'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '95199135'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '95383423'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '95727687'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '96464432'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '96227684'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '96888241'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '97445223'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '97641727'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '97602179'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '97805793'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '97831211'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '99001401'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '99169894'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '99947299'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '100302752'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '99261024'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '99392482'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '99781972'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '100295212'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '103183510'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '103186082'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '103188645'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '100585843'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '100699091'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '103707440'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '101995680'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '103707562'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '103707499'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '101202020'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '101890134'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '101679629'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '102144143'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '102441303'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '100732191'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '101541504'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '102430796'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '102628619'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '103707628'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '103378200'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '103844424'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '104004893'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '104055962'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '104231949'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '104720632'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '105489121'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '105756834'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '106227992'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '106409471'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '106455163'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '106508811'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '106080227'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '106791604'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '107467887'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '107519234'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '108155057'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '108575074'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '109628435'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '110685525'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '108526099'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '109043419'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '110271114'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '110101966'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '109120228'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '109325383'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '110773869'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '110729278'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '110987067'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '111029410'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '113393460'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '112523260'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '111370000'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '112055836'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '111192202'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '112747194'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '111930674'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '112116662'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '113832906'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '113805299'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '113960571'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '115884182'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '114887322'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '113776865'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '113972596'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '114406788'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '115161049'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '115607544'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '116265706'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '118891355'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '116677747'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '116285899'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '116647758'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '117123986'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '116894474'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '117211459'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '116502425'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '118363963'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '117835240'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '118260299'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '120286553'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '119237042'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '118857197'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '119051143'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '119560647'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '121272025'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '119220378'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '121207911'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '120626350'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '120714216'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '120941940'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '121392490'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '122259213'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '123143812'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '123049663'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '121953942'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '121552221'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '121611233'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '122461936'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '122029496'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '123536141'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '122975706'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '123789212'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '124382856'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '124396340'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '124248946'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '124221574'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '124622257'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '124468412'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '125044008'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '124579668'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '125854837'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '126864877'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '126847036'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '127665699'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '127267482'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '127258278'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '128177480'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '127445543'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '127866658'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '129702081'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '128778661'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '128321780'
update archive13F set
compid = '166941',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006457'
where entryId = '127980581'
End Function
The Script is complete, exiting....