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: : 145323
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '145323'
The Shares Amount is 0
The cusip is 456837400
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '456837400'
Number of Rows :2
update current13Fpositions set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0'
where entryId = '1128860'
update current13Fpositions set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '' ,
percentOut = '0'
where entryId = '8616585'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '456837400'
Number of Rows :27
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '67754322'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '62487599'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '68334094'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '67393938'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '66404697'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '67601643'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '65811023'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '66694412'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '66242428'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '65230579'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '65243065'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '63367465'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '63601445'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '63880981'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '64494227'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '68398425'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '69042347'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '69345090'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '70012660'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '70061430'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '70083644'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '71115746'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '70819804'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '71776557'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '72466263'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '72807901'
update archive13F set
compid = '145323',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = ''
where entryId = '73115863'
End Function
The Script is complete, exiting....