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: : 166940
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '166940'
The Shares Amount is 9000000
The cusip is 46090A200
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '46090A200'
Number of Rows :5
update current13Fpositions set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456' ,
percentOut = '1.11'
where entryId = '88893920'
update current13Fpositions set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456' ,
percentOut = '1.88'
where entryId = '101081619'
update current13Fpositions set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456' ,
percentOut = '0'
where entryId = '92077776'
update current13Fpositions set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456' ,
percentOut = '0'
where entryId = '116046007'
update current13Fpositions set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456' ,
percentOut = '0.11'
where entryId = '118702366'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '46090A200'
Number of Rows :278
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '76731640'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '78198902'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '78865147'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '79195674'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '79866446'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '80926559'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '81334375'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '81957852'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '82356007'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '83386772'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '83995010'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '85205864'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '84274950'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '85655874'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '86075913'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '86608212'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '86545023'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '86764759'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '86889938'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '87447279'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '87960581'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '89808702'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '89286932'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '89809137'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '88407219'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '87943150'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '89128860'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '89540688'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '90101442'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '90622405'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '90540421'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '90165951'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '90815169'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '91468735'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '90951053'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '91491558'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '91609682'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '90887924'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '92570186'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '92303137'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '93094183'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '93906263'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '92350210'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '92963077'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '92369232'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '93149771'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '93340857'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '93871250'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '93604407'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '95553765'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '94335785'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '94372890'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '95176606'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '95275371'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '94427144'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '94867028'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '95030692'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '95327655'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '95593071'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '95725134'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '95868377'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '95910498'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '94727127'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '96184947'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '96559735'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '96463267'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '96658323'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '96224092'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '96702206'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '97586104'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '97247023'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '98143763'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '98157473'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '98037936'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '98383799'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '98478614'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '98787270'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '98605770'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '99040235'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '99742315'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '99000198'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '99257146'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '99752223'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '99782042'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '99194254'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '100514172'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '103175707'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '103177993'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '103180527'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '103183039'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '103185469'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '103187981'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '100585129'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '100698359'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '100817159'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '100808087'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '100943255'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '101176971'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '101450680'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '101491653'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '101888859'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '102140036'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '102441239'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '100731498'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '101908653'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '102342495'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '102466564'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '102494550'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '102846412'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '103290992'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '103495360'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '103504022'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '103539817'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '103843159'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '103919137'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '104051728'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '104546501'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '104719970'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '103972039'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '104842351'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '105254230'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '105281898'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '105336689'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '104896913'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '106321759'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '105953844'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '106226693'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '106450736'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '107158927'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '107583755'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '106790999'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '107266594'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '107460355'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '107777500'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '107899347'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '108336595'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '106280993'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '106354896'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '105929236'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '109627133'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '110684648'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '110999532'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '108953869'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '110829051'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '110829108'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '110127201'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '110500127'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '109390377'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '110263852'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '109396548'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '109115703'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '109750778'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '108900534'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '108249512'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '109333308'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '109669218'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '110527035'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '110606942'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '111268732'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '110966075'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '110985812'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '113432582'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '111382315'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '112049331'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '111191346'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '111859489'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '111926079'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '112766143'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '112172381'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '112337028'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '112795428'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '112570313'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '113252810'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '113268743'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '113306857'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '110996309'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '111155511'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '113617300'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '114166219'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '115883678'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '114882715'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '114216280'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '113775596'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '114399655'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '115569202'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '115824404'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '113636880'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '116021529'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '115957965'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '115726973'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '114259072'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '116023929'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '115192490'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118758057'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118754434'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118728939'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118727026'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118724369'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118720080'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118716209'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118712625'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118709580'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118705884'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '116332459'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '116113176'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '116449898'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '116654578'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '116677234'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '116470464'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '117122695'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '116790386'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '117874236'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '117444465'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '117368488'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '117239038'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '117118630'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118341435'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '117996308'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '116497959'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '117906301'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118328952'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118284513'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118334970'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118257467'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '120285258'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118798982'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '119065200'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '119066827'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '119507432'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '120615014'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118919178'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '119065822'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '120362834'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '119239480'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '119409364'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '118769436'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '120277726'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '120568476'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '121237407'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '119992725'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '119219884'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '120979952'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '120549767'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '119695059'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '121204719'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '120441196'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '119904030'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '120709750'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '119682658'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '121384507'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '121222690'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '120950780'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '121056431'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '121635622'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '121793933'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '121790403'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '123143398'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '122031728'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '121635247'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '123252602'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '123258004'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '121788596'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '123246775'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '122029384'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '123256740'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '123247864'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '123238763'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '123931874'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '124002343'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '123247469'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '123240766'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '123981030'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '122354363'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '123255842'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '124082188'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '122017387'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '123988347'
update archive13F set
compid = '166940',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006456'
where entryId = '124302575'
End Function
The Script is complete, exiting....