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: : 168497
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168497'
The Shares Amount is 0
The cusip is 12510W206
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '12510W206'
Number of Rows :1
update current13Fpositions set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352' ,
percentOut = '0'
where entryId = '100539243'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '12510W206'
Number of Rows :133
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '98426324'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99719129'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99562259'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99409246'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99458732'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99796247'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99852992'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100456396'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100755778'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99253922'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99308492'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99424942'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99470867'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99476808'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99636169'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99663622'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99759882'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99814646'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99891058'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99893082'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99893966'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100157389'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100527962'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100587292'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99620670'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99716977'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99913278'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100172113'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100227824'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100266025'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100288845'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100312282'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100318109'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100339715'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100359572'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100379797'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100390066'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100394319'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100395526'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100399512'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100400526'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100418403'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100438005'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100462131'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100463049'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100465761'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100472137'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100483573'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100486710'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100493520'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100528562'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100530576'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100539921'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '99917047'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100422586'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100863257'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102080419'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102290371'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102067541'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '103055270'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102971671'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102439691'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102445825'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102445723'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102383567'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102092140'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102077679'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102136616'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102316364'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102967166'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '103006706'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102431222'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102432498'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102445540'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102158440'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102065984'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102088571'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102180795'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102432595'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102378065'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102416516'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102569988'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102981733'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102622119'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102984982'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102985327'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102990448'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102992347'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102996600'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102995714'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102995181'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102994474'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102744277'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102756530'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '103001265'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '103003322'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102793452'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102796770'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102804732'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '103008360'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102856229'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '103009448'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102875190'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '103009803'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '103011696'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '103080582'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102668469'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '103072585'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102968408'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '101512343'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '102449950'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '100986146'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '103708892'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '104803642'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '104827328'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '104782635'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '104803961'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '104789341'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105502563'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '104795388'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105524268'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105486526'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105475552'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105488799'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105505876'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105509513'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105509683'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105510882'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105513824'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105481755'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105514407'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105482392'
update archive13F set
compid = '168497',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001832352'
where entryId = '105628761'
End Function
The Script is complete, exiting....