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: : 159719
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159719'
The Shares Amount is 1000000
The cusip is 33737J166
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '33737J166'
Number of Rows :5
update current13Fpositions set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185' ,
percentOut = '0.4'
where entryId = '42167858'
update current13Fpositions set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185' ,
percentOut = '528.2'
where entryId = '42189970'
update current13Fpositions set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185' ,
percentOut = '0'
where entryId = '51354567'
update current13Fpositions set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185' ,
percentOut = '0'
where entryId = '98135099'
update current13Fpositions set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185' ,
percentOut = '0.4'
where entryId = '65086747'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '33737J166'
Number of Rows :183
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '66675726'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '66097600'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '67702890'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '66984822'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '68054547'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '66589996'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '68120331'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '68084628'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '68024653'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '67873070'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '65491014'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '67782531'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '67823193'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '68374082'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '68031220'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '66367242'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '67181932'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '66350866'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '66040745'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '65765825'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '66320359'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '66285360'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '67656581'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '65323628'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '65745503'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '65981262'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '65351178'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '66587961'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '65233881'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '65230669'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '66689412'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '63374344'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '63391314'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '63408435'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '64050641'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '63724558'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '64006636'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '63597666'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '64273484'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '64591283'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '64632290'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '64527780'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '64810436'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '64336051'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '64651928'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '64747099'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '64599063'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '69286870'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '69185936'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '69240644'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '69805364'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '69608492'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '69971734'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '69980693'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '69557550'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '69591372'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '69967860'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '69377089'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '69680954'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '70770479'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '71788643'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '71614368'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '71402386'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '70681621'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '71802223'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '71607659'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '71190352'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '71410900'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '70999797'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '71391573'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '72727229'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '72744363'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '73722597'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '73426506'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '73678854'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '73599962'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '73793156'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '73325121'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '73196898'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '73498535'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '72803454'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '73457332'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '74843634'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '74845079'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '75248479'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '75546729'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '75511993'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '75456863'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '75285840'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '75062957'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '75671932'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '74929096'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '75235306'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '76035408'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '77629496'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '77441892'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '77626519'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '76874232'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '77520562'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '77006431'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '77480934'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '77380612'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '77296773'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '78007999'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '78199222'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '79424693'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '78670357'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '78863601'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '79195225'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '79291988'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '79302046'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '79627496'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '79372335'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '80949775'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '80453802'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '80983357'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '80850677'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '81130456'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '81016885'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '81040836'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '81333788'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '81380421'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '81393557'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '81597627'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '82201097'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '82737454'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '82972591'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '83071394'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '83110322'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '83422982'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '83439666'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '83615064'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '83386269'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '84622900'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '84682590'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '84754622'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '84862860'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '85302268'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '85344408'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '85510335'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '85405882'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '85655192'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '86301230'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '87516172'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '86671030'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '86764192'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '86957643'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '87014397'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '87446592'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '87681669'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '87542241'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '89285387'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '88161223'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '89081600'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '89158173'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '89540060'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '89595497'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '89655699'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '89209143'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '90164322'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '91721395'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '91543885'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '90949704'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '91490817'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '91933931'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '91575548'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '91812917'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '92234783'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '93811931'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '93148544'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '93620609'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '93871502'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '93922473'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '95274087'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '94650097'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '94865386'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '66279354'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '95599611'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '95629454'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '97580129'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '96659034'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '97585920'
update archive13F set
compid = '159719',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004185'
where entryId = '98152507'
End Function
The Script is complete, exiting....