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: : 168917
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '168917'
The Shares Amount is 0
The cusip is G6580S122
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'G6580S122'
Number of Rows :2
update current13Fpositions set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344' ,
percentOut = '0'
where entryId = '130475270'
update current13Fpositions set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344' ,
percentOut = '0'
where entryId = '132545216'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'G6580S122'
Number of Rows :136
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '98669797'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '99796388'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '99820079'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '100755917'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '98982165'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '99259029'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '99425233'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '99636304'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '99684126'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '99739996'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '99783663'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '99814837'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '99891696'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '99893289'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '100587472'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '99717448'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '100311875'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '100394896'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '100396244'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '100420558'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '100438216'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '100525716'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '100530754'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '101172550'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '101375321'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102437432'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102335939'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102441481'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102384237'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102383813'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102092076'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102077651'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102142031'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102438872'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102195133'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102383013'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '101817848'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102416712'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102984632'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102735081'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102736511'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102758932'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102777653'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102855166'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '103009190'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '103009907'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102427107'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '102968286'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '103860609'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '104053755'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '104819844'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '104441649'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '104786037'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '104607645'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '104609708'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '104809489'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '104560781'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '105012551'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '105162219'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '105216470'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '105507117'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '105353609'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '105482364'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '105133344'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '105160173'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '105861473'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '107132134'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '106452836'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '107868200'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '107193980'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '107195047'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '108190958'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '107464018'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '107699870'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '108105287'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '107918491'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '108261182'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '108521309'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '108822526'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '110042098'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '110439894'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '110088154'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '110089846'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '110267418'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '109117853'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '110870954'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '110106423'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '110619109'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '111594390'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '112059013'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '110993998'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '111928267'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '112244971'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '112477719'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '112478487'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '113143294'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '113314982'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '113409654'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '115386984'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '114752807'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '114884921'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '114773457'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '114572658'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '115979302'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '115979192'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '116011310'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '115735600'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '115966703'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '116069584'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '114170954'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '116196822'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '118408332'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '117157240'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '118500731'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '118483995'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '118011590'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '116500113'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '117805501'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '118362264'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '120604125'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '120711904'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '120599540'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '120493091'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '121443966'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '121392965'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '120915479'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '121064983'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '122459607'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '123865598'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '123666077'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '124001549'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '124466101'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '126818332'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '126500304'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '127864383'
update archive13F set
compid = '168917',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001837344'
where entryId = '129307451'
End Function
The Script is complete, exiting....