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: : 159711
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '159711'
The Shares Amount is 9000000
The cusip is 78355W585
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '78355W585'
Number of Rows :5
update current13Fpositions set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177' ,
percentOut = '10.51'
where entryId = '51215960'
update current13Fpositions set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177' ,
percentOut = '1.76'
where entryId = '54885285'
update current13Fpositions set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177' ,
percentOut = '25.56'
where entryId = '57153474'
update current13Fpositions set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177' ,
percentOut = '0.79'
where entryId = '65084601'
update current13Fpositions set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177' ,
percentOut = '15.34'
where entryId = '70671033'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '78355W585'
Number of Rows :154
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66568434'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '68356543'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '68055477'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '67784644'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '67707998'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '67918953'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '68007294'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66101984'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '68390620'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66464436'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '65671746'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '68304016'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '67877523'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '68360794'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '65754944'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '65329353'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '68172311'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '67979949'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '67348570'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '68126277'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66993145'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '68026352'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '67900694'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '67832914'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '65503602'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66947392'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66686439'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '67370188'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66321239'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66287525'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '65276121'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66352197'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66050384'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66532801'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66137607'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '67398718'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66813090'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '65747625'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '65954832'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66714361'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '65359474'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '65244606'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66372533'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '65238493'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '66386422'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '65316682'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '65952638'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '63389123'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '63478250'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '63495333'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '63691756'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64056313'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '63569846'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '63732297'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '63704509'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64199679'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64007676'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64561577'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64174050'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64980848'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64283453'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64511680'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64592166'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64924155'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64552833'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64919488'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64340235'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64738038'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '64656913'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '65101790'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '68528392'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '67653718'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69224940'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69292925'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '68443363'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69140171'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69815639'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69605628'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69424684'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69102949'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69934204'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69115937'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69558382'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69403590'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69969698'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69512356'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69381381'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '69684529'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '70825348'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '70168565'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '71730716'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '70729639'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '71267613'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '71403260'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '70694601'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '71631321'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '71679443'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '71609265'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '71591584'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '71760116'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '71195616'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '71420614'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '71009613'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '71394956'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '70685982'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '72078612'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '72489974'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '72363404'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '72775542'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '72809183'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '73511878'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '73428178'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '73685328'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '73621278'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '73738346'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '72839039'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '73742518'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '73592511'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '73330545'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '73207121'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '73502347'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '72106782'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '73461767'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '74140289'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '74876483'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '75308355'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '74813750'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '73965610'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '74844585'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '75249495'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '75553046'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '75476518'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '75458575'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '75440942'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '75068372'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '75676187'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '74939437'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '75239254'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '77571078'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '76253987'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '76260346'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '77629311'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '77631118'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '77630418'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '76545060'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '76739674'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '77610626'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '77629096'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '77320862'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '77603258'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '77621543'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '77622593'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '79499618'
update archive13F set
compid = '159711',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '9000004177'
where entryId = '79528888'
End Function
The Script is complete, exiting....