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: : 159959
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159959'
The Shares Amount is 2340000000
The cusip is G42089113
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G42089113'
Number of Rows :9
update current13Fpositions set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425' ,
percentOut = '0'
where entryId = '42165642'
update current13Fpositions set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425' ,
percentOut = '0'
where entryId = '132556786'
update current13Fpositions set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425' ,
percentOut = '29.07'
where entryId = '131305237'
update current13Fpositions set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425' ,
percentOut = '0.11'
where entryId = '68942305'
update current13Fpositions set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425' ,
percentOut = '0.04'
where entryId = '119399524'
update current13Fpositions set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425' ,
percentOut = '0.04'
where entryId = '131502403'
update current13Fpositions set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425' ,
percentOut = '0.02'
where entryId = '132064693'
update current13Fpositions set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425' ,
percentOut = '0.01'
where entryId = '130160962'
update current13Fpositions set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425' ,
percentOut = '0.43'
where entryId = '131528829'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G42089113'
Number of Rows :196
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '67183853'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '66840086'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '67515161'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '67063556'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '66721228'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '67474963'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '65289668'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '67125947'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '66933323'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '65718104'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '66521222'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '65203463'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '66399068'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '65301899'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '66027567'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '65272452'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '63500577'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '63621715'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '63687168'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '64483547'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '63957582'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '64791264'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '68453795'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '69872561'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '69123330'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '68635202'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '69761814'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '70291559'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '70194560'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '70595170'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '70308134'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '70603733'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '70968499'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '72146803'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '72323365'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '72452393'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '72902444'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '73179768'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '73309769'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '73659298'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '74053158'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '73938699'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '74293609'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '74832114'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '74423670'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '75045277'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '75739751'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '76145566'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '77647447'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '75994892'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '76203759'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '76846545'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '76973402'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '78131223'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '77840777'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '78474579'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '78700145'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '78836245'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '77987008'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '80271893'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '80204196'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '81502527'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '81646691'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '80806699'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '80049945'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '80537377'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '81913967'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '82567393'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '82038812'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '82233279'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '82767865'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '83092902'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '82404936'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '81734034'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '84118473'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '84495918'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '84955905'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '84719510'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '84849157'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '85496255'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '85635649'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '85659206'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '86610605'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '86038218'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '86216962'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '86649659'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '86391363'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '86776291'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '86977843'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '87522964'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '87179816'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '88049836'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '88691557'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '88873745'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '88151251'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '88582503'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '89084578'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '87981345'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '88598058'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '89273427'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '90179064'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '90257920'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '90556398'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '90312637'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '90976498'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '90568118'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '91145123'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '93638378'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '92104982'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '92508609'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '93664663'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '93162101'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '92523438'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '93276790'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '94562911'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '94680186'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '94785284'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '94893906'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '95049183'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '94499272'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '95084917'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '97581226'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '96434273'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '96800650'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '97287116'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '97287349'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '97822931'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '98141090'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '96891827'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '98715954'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '99539780'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '99288191'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '99468811'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '99795575'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '99795323'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '99621520'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '100267799'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '101068244'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '101511812'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '101923690'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '101676410'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '102363556'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '101588497'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '102742604'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '103198071'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '103633855'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '104224756'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '104899480'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '104535230'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '104535470'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '105157943'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '106503122'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '106213602'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '106897462'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '108074297'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '107828945'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '107696466'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '108827508'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '109141613'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '110039948'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '108354152'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '110433615'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '110930117'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '111467053'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '112116969'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '111130338'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '113131687'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '114534192'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '113941318'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '114436034'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '114339751'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '115427323'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '116475938'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '116239365'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '117535591'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '117835057'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '118062588'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '119776765'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '119241911'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '121357678'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '121087023'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '123207657'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '123619557'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '122484920'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '123350095'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '123680668'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '124623028'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '125554502'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '125578639'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '125972418'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '126073606'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '127720178'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '128983903'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '128530920'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '128558471'
update archive13F set
compid = '159959',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004425'
where entryId = '129107630'
End Function
The Script is complete, exiting....