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: : 159691
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159691'
The Shares Amount is 9730000
The cusip is 06740L444
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '06740L444'
Number of Rows :6
update current13Fpositions set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157' ,
percentOut = '3.18'
where entryId = '51208100'
update current13Fpositions set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157' ,
percentOut = '10.07'
where entryId = '52242362'
update current13Fpositions set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157' ,
percentOut = '0'
where entryId = '65231616'
update current13Fpositions set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157' ,
percentOut = '23.88'
where entryId = '69269471'
update current13Fpositions set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157' ,
percentOut = '0.09'
where entryId = '89551555'
update current13Fpositions set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157' ,
percentOut = '79.11'
where entryId = '81881593'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '06740L444'
Number of Rows :179
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '68083912'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '67700032'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '68054106'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '66969782'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '65672443'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '67870644'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '67688522'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '67892306'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '68358601'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '66364211'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '66763076'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '65123693'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '66706031'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '66736171'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '66912105'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '66980298'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '66319943'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '66095118'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '66129575'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '66350132'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '66284271'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '65765030'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '65670910'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '65171812'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '65346682'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '66387653'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '63392447'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '63398372'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '63406428'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '63425086'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '64118439'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '63720352'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '65110001'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '63853976'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '64007137'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '64590864'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '64924610'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '63824319'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '64372839'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '64333666'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '64918410'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '68421189'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '68445543'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '68493937'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '68770001'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '69185839'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '68554838'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '69610614'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '69557169'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '69395059'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '69590685'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '69374719'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '70087814'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '70190322'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '70498810'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '70880899'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '71401990'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '71621666'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '71677396'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '71606867'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '71187426'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '71404877'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '72006149'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '72045675'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '72184561'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '72200054'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '72749140'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '73425640'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '73611062'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '73644217'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '73598973'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '73321992'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '73454965'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '73967142'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '73929021'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '75493684'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '74792732'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '74369215'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '75491450'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '75248004'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '74634071'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '75465991'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '75622848'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '75456004'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '75060018'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '75669575'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '75856280'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '75893433'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '76690318'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '76264639'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '77400735'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '77639364'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '77629070'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '76868474'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '77592508'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '77310334'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '76261463'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '77380261'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '77295872'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '77800151'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '77834320'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '77990602'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '79052562'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '78006478'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '78668377'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '79194414'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '79209487'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '79291558'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '79333069'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '79621409'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '79828134'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '79762244'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '80383339'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '80946313'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '81362664'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '79940815'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '81014933'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '81035781'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '81177164'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '81531566'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '81343945'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '81379955'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '81422502'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '81758356'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '82938038'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '83069373'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '83105359'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '83576452'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '83394634'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '83439198'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '83460736'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '85267432'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '84680489'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '84749761'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '84859940'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '84897086'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '85238480'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '85301862'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '85325286'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '85653998'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '85953520'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '86007688'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '86606806'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '86568754'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '86668160'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '86763274'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '86955474'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '87009309'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '87151499'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '87701827'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '87457495'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '87681501'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '87573226'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '87797820'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '89282356'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '87941817'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '88427600'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '89155887'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '89204226'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '89332311'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '89624714'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '89654726'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '87841688'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '90354047'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '90813360'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '90947282'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '91725324'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '91773432'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '91808161'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '91933769'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '91812967'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '91895731'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '92568279'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '93843850'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '94370882'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '96557632'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '98785027'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '100814842'
update archive13F set
compid = '159691',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004157'
where entryId = '103292097'
End Function
The Script is complete, exiting....