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: : 167139
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167139'
The Shares Amount is 9000000
The cusip is G0120M117
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G0120M117'
Number of Rows :3
update current13Fpositions set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484' ,
percentOut = '144.44'
where entryId = '95876668'
update current13Fpositions set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484' ,
percentOut = '0'
where entryId = '100978044'
update current13Fpositions set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484' ,
percentOut = '0'
where entryId = '113607283'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G0120M117'
Number of Rows :199
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '87245118'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '87266670'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '87493957'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '87232974'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '87412977'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '87426851'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '88724501'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '89510750'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '88737580'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '89058295'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '89307605'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '89353245'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '89361501'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '89485569'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '89641324'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '89641524'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '91444686'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '91173236'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '91449515'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '91554083'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '91549671'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '90777074'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '91557037'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '90744924'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '91258336'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '91250628'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '92707023'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '93027335'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '93337887'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '93577413'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '92945540'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '92914915'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '92998506'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '93145825'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '93335998'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '93500182'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '93542578'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '93327519'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '93328161'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '94665284'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '94665524'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95271382'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95023607'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '94459685'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '94724622'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '94861526'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95454685'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95463944'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95484158'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95488376'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95845747'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95894096'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95386316'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95476882'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95612270'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95722296'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95741059'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '95860272'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '96464899'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '96220065'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '96651749'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '96651639'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97573532'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '96877525'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97180414'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97190471'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97239848'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97321970'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97612942'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97386105'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97836543'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '98247729'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97183318'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '98157160'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97826744'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97830363'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97930586'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97931493'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97967517'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '97996458'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '98203580'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '98579383'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '100658543'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '99818288'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '99252742'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '99381169'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '99476701'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '99663553'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '100093301'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '99739850'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '99814589'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '100304764'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '100311382'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '100394166'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '100395312'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '100437917'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '100467499'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '100422951'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '102335762'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '103055694'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '102383488'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '102135364'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '102316284'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '101816051'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '102430458'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '102225670'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '102650829'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '102734088'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '102735722'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '102777320'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '102798674'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '102874135'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '102642803'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '104046848'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '104819750'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '104441202'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '104444758'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '104505983'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '104560459'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '105001712'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '105079409'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '105085500'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '105161199'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '105172600'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '105247215'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '105294907'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '105530079'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '105159236'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '106842247'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '107131668'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '106445556'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '106616363'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '106656444'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '107136154'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '107867838'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '107572168'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '108086263'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '107549274'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '108090393'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '107785174'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '107694313'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '107698653'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '107764976'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '107822733'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '108259974'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '108734985'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '108821940'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '110022237'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '109717440'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '110438705'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '110538954'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '109110311'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '110858001'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '109614932'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '109660579'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '110112365'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '110869554'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '110428827'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '110497124'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '110348033'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '111422411'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '111593726'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '113260727'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '112345109'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '111920646'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '112243791'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '112375737'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '112418588'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '113126463'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '113141899'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '113207210'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '113216968'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '113509974'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '114526071'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '114877310'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '115621236'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '115655899'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '114565186'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '115534351'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '114553324'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '115557041'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '115416774'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '115419665'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '116040862'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '115421841'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '117388011'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '118534786'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '116736444'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '118562714'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '118613870'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '118571315'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '118202087'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '118560972'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '116746961'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '118590332'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '118532228'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '121366833'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '91296773'
update archive13F set
compid = '167139',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006484'
where entryId = '128359189'
End Function
The Script is complete, exiting....