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: : 142483
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '142483'
The Shares Amount is 825270000
The cusip is 606769305
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '606769305'
Number of Rows :28
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0.02'
where entryId = '9756001'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '11032177'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '12192396'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '6.96'
where entryId = '13242879'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '13671422'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '9.73'
where entryId = '14310245'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '15132353'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0.16'
where entryId = '15503311'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '15577519'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '15803558'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '9.81'
where entryId = '16353284'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '9.81'
where entryId = '16354538'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '16727382'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '17144530'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '17254176'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0.08'
where entryId = '17383540'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0.01'
where entryId = '17521054'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '17532710'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '10.65'
where entryId = '17728092'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '18567655'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0.01'
where entryId = '19104384'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '22313287'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0.51'
where entryId = '30181154'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0.22'
where entryId = '42138577'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0.75'
where entryId = '42149443'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '42456918'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0'
where entryId = '53985308'
update current13Fpositions set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800' ,
percentOut = '0.09'
where entryId = '92308806'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '606769305'
Number of Rows :124
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '67503711'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '66810253'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '67236923'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '66752772'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '34087565'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '65170492'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '65079659'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '66626605'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '63386739'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '63609179'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '64869012'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '68413273'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '70036817'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '68434315'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '70005567'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '69208841'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '69865464'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '70082235'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '70093723'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '70112838'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '70559961'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '70908726'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '71155933'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '72171533'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '72000580'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '72122134'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '73783432'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '73412140'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '72226927'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '73155763'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '73311053'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '73956198'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '74012190'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '73832000'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '74328471'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '74434313'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '74230937'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '74880981'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '75046567'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '75795974'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '76042464'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '76237485'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '75936741'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '76322794'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '76724207'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '77162467'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '76974680'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '76813324'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '77749746'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '77877459'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '78055605'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '79053632'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '77856333'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '78202883'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '78837548'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '79549852'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '79805097'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '80361057'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '79707617'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '79715226'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '80379229'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '80351406'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '81172257'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '81002525'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '81720100'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '82108079'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '81995589'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '82438969'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '81959739'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '82234577'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '82618281'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '84221749'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '83758781'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '83889041'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '83775496'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '84652477'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '84850459'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '85278974'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '85466173'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '85843157'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '87678004'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '86608986'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '86560918'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '85943151'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '85988847'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '86920830'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '86836949'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '87181097'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '87796847'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '88065702'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '88469676'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '89688905'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '87943896'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '89274724'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '89846132'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '88571726'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '90646632'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '90071192'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '90816080'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '91006273'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '90616832'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '91829000'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '91146387'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '92571134'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '96188063'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '88493885'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '92397886'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '93731564'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '93278054'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '93833229'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '93865161'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '93955019'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '96188483'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '94373878'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '94715748'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '95222629'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '95245958'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '96188924'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '96013742'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '96560755'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '98184749'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '98788331'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '100818259'
update archive13F set
compid = '142483',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0000926800'
where entryId = '103293402'
End Function
The Script is complete, exiting....