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: : 159773
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159773'
The Shares Amount is 300000
The cusip is 45409B842
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '45409B842'
Number of Rows :2
update current13Fpositions set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239' ,
percentOut = '23.6'
where entryId = '51212050'
update current13Fpositions set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239' ,
percentOut = '453.87'
where entryId = '69270432'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '45409B842'
Number of Rows :75
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '68054720'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '68356750'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '67856192'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '66133502'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '67874034'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '65489085'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '65324936'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '68121716'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '66461952'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '67825490'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '68374270'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '67896390'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '68169844'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '66368522'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '66043021'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '66320518'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '66351168'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '67657119'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '66098565'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '68084967'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '65952600'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '64051936'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '64112754'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '64964619'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '64980809'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '64275834'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '64591432'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '64632607'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '64376707'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '64336985'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '64735276'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '64653130'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '69288283'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '69241201'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '69807798'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '69613320'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '69557697'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '69399209'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '69591701'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '69378011'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '69681774'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '70771049'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '71402556'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '70692993'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '71626319'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '71802311'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '71590550'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '71191655'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '71413192'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '71002139'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '71392372'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '73760693'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '73426872'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '73680383'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '73616018'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '73645290'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '73600452'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '73591404'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '73326360'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '73199359'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '73499424'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '72556091'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '73458327'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '75614114'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '75620295'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '75622237'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '75623140'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '75630595'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '75631637'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '75637122'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '75704433'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '75638642'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '75639226'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '75640222'
update archive13F set
compid = '159773',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004239'
where entryId = '75582891'
End Function
The Script is complete, exiting....