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: : 159734
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159734'
The Shares Amount is 7250000
The cusip is 00768Y834
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '00768Y834'
Number of Rows :5
update current13Fpositions set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200' ,
percentOut = '15.48'
where entryId = '86592574'
update current13Fpositions set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200' ,
percentOut = '18.39'
where entryId = '42497399'
update current13Fpositions set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200' ,
percentOut = '0.65'
where entryId = '107790036'
update current13Fpositions set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200' ,
percentOut = '19.06'
where entryId = '69269240'
update current13Fpositions set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200' ,
percentOut = '0.35'
where entryId = '88887292'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '00768Y834'
Number of Rows :200
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '66363193'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '68007830'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '66319838'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '66349912'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '68083680'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '67699042'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '68053994'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '67869894'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '66094339'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '68116439'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '67688282'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '65319956'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '67137566'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '66978728'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '65764767'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '65859549'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '65727754'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '65345127'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '65508272'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '65952788'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '64047015'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '63718900'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '64626802'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '64202074'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '64174780'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '64590771'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '64631376'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '64332930'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '64918113'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '69282834'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '69124742'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '69583464'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '69941182'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '69557071'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '69590453'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '69510271'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '69940481'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '70713958'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '71652502'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '70834288'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '71401877'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '70677527'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '71677172'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '71606703'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '71589453'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '72474019'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '73638378'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '72751836'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '73425382'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '73674647'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '73643994'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '73598634'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '73590247'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '74124874'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '75493607'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '74751855'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '75247858'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '75542676'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '75511062'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '75630138'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '75438554'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '76048218'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '76651756'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '77516646'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '77002479'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '77479968'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '76206526'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '77380147'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '77282254'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '79530025'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '79173939'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '78014090'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '79420383'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '78502435'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '78667760'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '78859590'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '79291434'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '79371277'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '81444869'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '80223388'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '80896723'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '80462876'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '81126347'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '81014314'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '81332583'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '81379812'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '81596534'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '80783400'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '83846106'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '81819365'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '82418283'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '82459238'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '82605458'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '82733629'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '83068734'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '83203466'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '83439072'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '83613764'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '83385287'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '83769840'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '83967960'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '84200613'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '84679798'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '84858907'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '84896438'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '85301750'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '85404540'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '85653551'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '85882000'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '86592632'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '86797581'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '86667096'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '86762973'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '86954753'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '87150851'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '87445006'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '87682289'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '87892946'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '88458060'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '89704414'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '89155134'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '89722985'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '89538635'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '89654348'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '90267646'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '90289442'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '90331015'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '90160430'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '90946506'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '91856178'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '91489283'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '91902958'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '91645373'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '92198643'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '92157368'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '92356900'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '93683830'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '92230877'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '93145795'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '93187209'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '93329156'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '93871299'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '93920649'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '94188709'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '95271349'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '94405408'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '94861484'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '95126379'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '95318674'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '95613341'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '95627735'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '95866027'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '96466886'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '96220023'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '96877472'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '97245493'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '97461323'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '98143728'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '97827962'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '98061610'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '98384103'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '98463429'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '100110530'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '99252687'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '99381113'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '99750588'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '100306327'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '100544382'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '100794513'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '102135305'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '101905733'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '102431100'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '102439504'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '102620937'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '102984421'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '103013024'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '104046785'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '104755237'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '103352935'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '105001641'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '105489671'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '105278983'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '105598785'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '106445489'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '106819288'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '107955776'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '107451706'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '108336631'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '110255541'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '109110238'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '109895151'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '110092317'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '112042405'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '111920571'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '112639879'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '113347059'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '115986610'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '115958575'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '114773316'
update archive13F set
compid = '159734',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004200'
where entryId = '116030856'
End Function
The Script is complete, exiting....