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: : 159751
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159751'
The Shares Amount is 9000000
The cusip is 36863N208
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '36863N208'
Number of Rows :2
update current13Fpositions set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217' ,
percentOut = '0'
where entryId = '35982233'
update current13Fpositions set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217' ,
percentOut = '0.11'
where entryId = '42084412'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '36863N208'
Number of Rows :73
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '68150975'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '67502859'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '67754209'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '67055597'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '68072971'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '67543845'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '66752704'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '65168284'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '67182127'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '67086219'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '66431813'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '66625744'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '65586948'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '65286253'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '65294564'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '65810906'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '65853491'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '66679502'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '65981331'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '63447806'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '63609115'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '64110439'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '63575682'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '64975883'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '64076347'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '63965616'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '63880862'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '63597761'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '64701362'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '64868153'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '63369451'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '69173390'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '70007485'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '68619993'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '67250814'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '69176446'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '69664872'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '69540314'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '69360895'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '69864612'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '70326591'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '70981260'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '70109598'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '70437749'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '70907618'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '71155042'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '72074267'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '72194001'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '72223693'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '73731998'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '73154658'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '73310161'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '74055505'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '74430689'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '74879875'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '75045679'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '75929158'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '76319105'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '76973793'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '76812341'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '78215214'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '78836646'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '79592067'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '81171352'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '81001342'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '82233678'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '82617149'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '84651351'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '85482313'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '86598657'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '86919702'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '88521484'
update archive13F set
compid = '159751',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004217'
where entryId = '88952587'
End Function
The Script is complete, exiting....