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: : 160345
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '160345'
The Shares Amount is 54443000
The cusip is N07831105
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = 'N07831105'
Number of Rows :30
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '4.59'
where entryId = '38866052'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '2.39'
where entryId = '40159581'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '430.97'
where entryId = '40849025'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '5.44'
where entryId = '41007274'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '4.69'
where entryId = '42075767'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '7.66'
where entryId = '42105087'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '81.69'
where entryId = '42120565'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '137.96'
where entryId = '42150797'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '33.34'
where entryId = '42155053'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '35.62'
where entryId = '42174492'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '38.11'
where entryId = '42192163'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '0.01'
where entryId = '42199058'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '0.02'
where entryId = '42204754'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '3.63'
where entryId = '42226387'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '2303.65'
where entryId = '42253933'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '0'
where entryId = '42463033'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '3.74'
where entryId = '46540254'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '42.85'
where entryId = '50671654'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '1.58'
where entryId = '51207947'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '0.35'
where entryId = '51751916'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '0.05'
where entryId = '52242918'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '18.86'
where entryId = '56367787'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '35.38'
where entryId = '56468360'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '0'
where entryId = '56937756'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '4.56'
where entryId = '62204015'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '0'
where entryId = '65857219'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '0'
where entryId = '65858071'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '0'
where entryId = '65860156'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '0'
where entryId = '65860384'
update current13Fpositions set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903' ,
percentOut = '0'
where entryId = '70520720'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = 'N07831105'
Number of Rows :271
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66560853'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '47662970'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66588886'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66077955'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65860890'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65860542'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66590899'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65671095'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66656617'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '67155144'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66588370'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65632527'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '68344081'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '67543273'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66656453'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65672562'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66076618'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65851610'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64451991'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65984838'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66080582'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66074273'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66589624'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66071998'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66580587'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66079858'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66080472'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65857796'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65235910'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66587438'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66584948'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66565814'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66079712'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66584185'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66079969'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66859801'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66578720'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66582535'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65670406'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66578158'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66070016'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66313748'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66588407'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66583986'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '68327906'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65272485'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66589017'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66653143'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66581110'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66588809'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66079139'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '67780378'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66589924'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66591315'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66656005'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65859906'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66586817'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66075953'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66548396'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66656197'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65671379'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65382394'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65857943'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65669750'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66079897'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66582399'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66653384'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66556132'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65245960'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65236145'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65670996'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66675392'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66548607'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65855261'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66078463'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65853805'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65638991'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66262223'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65858193'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65638803'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66571674'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66080185'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66381552'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65672873'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65858599'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66587013'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65243723'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65860236'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65233569'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66079072'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66550321'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65105716'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65376451'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66583051'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66552432'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65670772'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66068172'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65849464'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65382731'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65671190'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65858147'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65244262'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65230888'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '66080661'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '65230168'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63446775'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63378874'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63450683'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63395842'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63450058'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63406685'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63449764'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63463683'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63468300'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63526976'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63527911'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63528233'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63649314'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63633553'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63755433'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63664084'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63948475'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64118011'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64310884'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63639866'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63820574'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64107318'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64118354'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63755719'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63651687'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63847628'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63720122'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64108942'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63928838'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63753059'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64942500'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63952447'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63672627'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64116494'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64318794'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64317728'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63774734'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64925952'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63757615'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63968423'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64223855'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63853352'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64875116'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63511193'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64080841'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64006355'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63832247'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64440096'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64880721'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64014581'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64310426'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64197299'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64113105'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64935577'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63935404'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64129435'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64925058'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64709224'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63900290'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64061445'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64096618'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64116691'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64202274'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64172542'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63651973'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63937976'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63973562'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64089696'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64109478'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63868457'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64107516'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64251767'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64584729'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64024066'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64957611'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64162824'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64959271'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64962406'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64660631'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63526699'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64451639'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64171139'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64347002'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64941099'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64995613'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64164653'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64933046'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64150151'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64460057'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64388028'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64606875'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64070378'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64135778'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64803773'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64134144'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64265145'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64248260'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63783885'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64973723'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64626735'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64515263'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64600246'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64613679'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64560104'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64960843'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64100301'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64425732'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64951730'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64950485'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63651368'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64943024'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64948453'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64554206'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64942846'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64944347'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64583031'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64936300'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64936092'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64938666'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64933405'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64109771'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64516995'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64426488'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64930922'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64519043'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64642783'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64928721'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64929008'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64752557'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64592740'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64927051'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64457759'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64318284'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64452727'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64571228'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64925823'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64351048'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64925069'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64473918'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63930518'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64466823'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64922899'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63370904'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64765039'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64689905'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64152033'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64358924'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64550496'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64808291'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64919206'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64918887'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64741039'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64648878'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64880580'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64866444'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64932315'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64856188'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64867096'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64900716'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64847093'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '63805585'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '64951448'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '69276222'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '62920746'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '51036443'
update archive13F set
compid = '160345',
sectorNum = '999999',
sectorDes = 'N/A',
issuerCik = '0001528903'
where entryId = '96631999'
End Function
The Script is complete, exiting....