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: : 130843
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '130843'
The Shares Amount is 4280000
The cusip is 98873Q100
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '98873Q100'
Number of Rows :12
update current13Fpositions set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187' ,
percentOut = '0'
where entryId = '132604211'
update current13Fpositions set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187' ,
percentOut = '0.04'
where entryId = '130779214'
update current13Fpositions set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187' ,
percentOut = '140.19'
where entryId = '131672275'
update current13Fpositions set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187' ,
percentOut = '0.12'
where entryId = '131721206'
update current13Fpositions set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187' ,
percentOut = '8.73'
where entryId = '132244215'
update current13Fpositions set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187' ,
percentOut = '47.23'
where entryId = '130986819'
update current13Fpositions set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187' ,
percentOut = '324.28'
where entryId = '131086103'
update current13Fpositions set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187' ,
percentOut = '322.86'
where entryId = '131804431'
update current13Fpositions set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187' ,
percentOut = '0.14'
where entryId = '130808319'
update current13Fpositions set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187' ,
percentOut = '0'
where entryId = '130479109'
update current13Fpositions set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187' ,
percentOut = '124.05'
where entryId = '132109613'
update current13Fpositions set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187' ,
percentOut = '0.01'
where entryId = '132396201'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '98873Q100'
Number of Rows :166
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '90172741'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '91229358'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '90956282'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '90898631'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '91923720'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '90235726'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '93105006'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '93415416'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '92243148'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '92768523'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '93154265'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '93207719'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '92526938'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '94632012'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '95279969'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '94438076'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '95246384'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '95066476'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '95375126'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '95510797'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '95589433'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '95880129'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '96021776'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '96370493'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '96228903'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '96713350'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '96890059'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '96974669'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '97095082'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '97612921'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '97596004'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '97806804'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '98175520'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '98203567'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '100658363'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '99131134'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '99262348'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '99394404'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '99453062'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '99581341'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '99205057'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '100296443'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '99885205'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '102145567'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '102221662'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '102296422'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '101773081'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '102268146'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '102430720'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '102477455'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '102496772'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '102629873'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '103231905'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '104057439'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '104216999'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '104334152'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '104831476'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '104367697'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '104853801'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '104951467'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '105018469'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '105489651'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '105302523'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '104547763'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '104899134'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '106456719'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '106896330'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '107015397'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '107398493'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '107644607'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '107842234'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '108248384'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '107186071'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '107277537'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '108086075'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '109452508'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '109300618'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '110137705'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '110719867'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '109972202'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '110273683'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '109121818'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '108250252'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '109177091'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '110040793'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '112388097'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '113358050'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '112058132'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '111870123'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '111932261'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '112106157'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '112217915'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '112731757'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '113431056'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '114888916'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '114409299'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '114575354'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '115345205'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '115025548'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '114847666'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '115321745'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '114764946'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '115145476'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '117825558'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '117159900'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '117454337'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '116897170'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '117693085'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '116503983'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '117045491'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '118261283'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '117704463'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '119927578'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '121142291'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '121128722'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '120076507'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '121402850'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '119913127'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '120715774'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '119692768'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '119759340'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '120327645'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '121408431'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '121531003'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '120918382'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '122463531'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '123256942'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '122714297'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '122658898'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '122982139'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '123302954'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '122922815'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '123617658'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '122846827'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '122864060'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '123932463'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '123503765'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '123812705'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '124469992'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '125474768'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '125107009'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '125046260'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '126776413'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '125419745'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '126846230'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '125821090'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '126128257'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '126144966'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '126207748'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '126340082'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '126523067'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '126964826'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '127868237'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '127836424'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '129725394'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '128051075'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '129834891'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '128428960'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '128796599'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '129321514'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '127926036'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '129724149'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '128455014'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '129200801'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '128382283'
update archive13F set
compid = '130843',
sectorNum = '102009',
sectorDes = 'Toys & Games',
issuerCik = '0001042187'
where entryId = '129529453'
End Function
The Script is complete, exiting....