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: : 167140
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '167140'
The Shares Amount is 9000000
The cusip is 09075F115
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '09075F115'
Number of Rows :0
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '09075F115'
Number of Rows :94
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '78090907'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '79092689'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '79621706'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '80040017'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '80656911'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '81127540'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '79094411'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '81036043'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '82785529'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '82032598'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '82734751'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '83105620'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '83512762'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '84408217'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '84750015'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '84860120'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '84934290'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '85456824'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '87201635'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '86684519'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '87009560'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '89282543'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '88280787'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '88725064'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '89539081'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '89204474'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '90161613'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '90730798'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '91264159'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '91378336'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '91489779'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '91905032'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '92621856'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '92232082'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '92801306'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '93146602'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '93189262'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '93449704'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '93528072'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '95272177'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '94862671'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '95387216'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '95320693'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '95978121'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '95866556'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '96220879'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '96878695'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '97029583'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '97685988'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '97975646'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '98384390'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '99920824'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '100083141'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '99253619'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '100077912'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '100644174'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '100527487'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '100171398'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '101179235'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '102136295'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '102856674'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '103079641'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '104047835'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '104924628'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '105513948'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '106446606'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '106788597'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '107371313'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '107453722'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '109856599'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '110257453'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '109111426'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '109151034'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '112043921'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '111921755'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '112854507'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '111398521'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '116050444'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '114878420'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '114393473'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '114948373'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '116880456'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '116493791'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '117579227'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '119898086'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '120705582'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '120767018'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '122453185'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '123257956'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '123361241'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '123827935'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '124642201'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '126824687'
update archive13F set
compid = '167140',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000006485'
where entryId = '126853329'
End Function
The Script is complete, exiting....