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: : 147484
SELECT companies.* , sectors.level3des
FROM companies, sectors
WHERE companies.sector = sectors.level3num and compid = '147484'
The Shares Amount is 295090000
The cusip is 928662303
NOT OLD
Retrive Rows from Table:
select * from current13Fpositions where cusip = '928662303'
Number of Rows :27
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0.41'
where entryId = '8616571'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0.08'
where entryId = '9757834'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '1.67'
where entryId = '11195208'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0.01'
where entryId = '12479780'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '1.55'
where entryId = '13451512'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0.01'
where entryId = '13749506'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0.19'
where entryId = '13900517'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0'
where entryId = '16109618'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0'
where entryId = '17135579'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0'
where entryId = '17953979'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0'
where entryId = '42084552'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0.21'
where entryId = '42102155'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0.01'
where entryId = '42148402'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0.24'
where entryId = '42150414'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '1.73'
where entryId = '42159499'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0.02'
where entryId = '42193205'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '13.35'
where entryId = '42222610'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0.19'
where entryId = '42230384'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '3.39'
where entryId = '42244962'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0'
where entryId = '42266864'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0'
where entryId = '42269435'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0'
where entryId = '42269686'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0'
where entryId = '42461338'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0.24'
where entryId = '47725986'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0'
where entryId = '52019177'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '2.73'
where entryId = '53884405'
update current13Fpositions set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862' ,
percentOut = '0.18'
where entryId = '69546565'
End Function
Retrive Rows from Table:
select * from archive13F where cusip = '928662303'
Number of Rows :203
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65009200'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '66563094'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '67977806'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '67505042'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '67323032'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '66678134'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '67543851'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '68382398'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '67117300'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '68333876'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '67176827'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '68073662'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '66754156'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '34123314'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '68377659'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '62488724'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65168120'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '67271655'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65446662'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65775749'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '67519082'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '66836152'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '66238770'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '66699673'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '66885942'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '67481038'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '66783675'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '67112929'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '66627942'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65590971'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65521589'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65286427'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '66535703'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '66055614'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65314080'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65062218'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65079936'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65093423'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65272217'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65460544'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65176648'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '66307269'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '65385702'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '63393743'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '63377673'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '63393642'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '63497550'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '63615999'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '63553774'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '63603991'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '64976058'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '63966307'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '63805087'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '63760343'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '64212219'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '64080236'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '64668379'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '63743898'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '64575773'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '64101176'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '64816837'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '64670974'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '64929012'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '64870344'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '64993421'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '68415543'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70006144'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '68520101'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '68694193'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '67250985'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '68550780'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '67532502'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '67371744'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '68406194'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '68948484'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '68970145'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '69176369'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70850667'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '69346342'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '69866767'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '69618195'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '69634275'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '69247807'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '69961040'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '69943091'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70052189'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70094450'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70161801'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70207699'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70857035'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70460168'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70118152'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '71704064'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70191916'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '71777198'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70231945'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70540092'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70572692'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70823200'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '71750407'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '71824958'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70606137'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70817644'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '71604498'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70870695'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '70437906'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '71570359'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '71157301'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '71994590'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '71995136'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '72105506'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '72329190'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '73031784'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '72073011'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '72372160'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '72392397'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '72731631'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '73113583'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '72358664'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '72232258'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '72690210'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '73085104'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '73356873'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '72198550'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '73053268'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '72362549'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '73419405'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '73576048'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '73808532'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '73312425'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '73824601'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '73835603'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '73948279'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '74547637'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '73957596'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '74054172'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '75728514'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '74285590'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '74440305'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '74683428'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '74164404'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '75306104'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '74832530'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '75453040'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '75559116'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '75602284'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '74786393'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '75622090'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '75047959'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '75112212'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '75747578'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '75855766'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '75879338'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '75998746'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '76328945'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '75997966'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '76611688'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '77536109'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '76559569'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '76348059'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '76534980'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '76173468'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '76976061'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '77650505'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '77378923'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '77494535'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '77570001'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '77704746'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '77820672'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '77867270'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '78278787'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '78061349'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '78221526'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '78548285'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '78579491'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '78553898'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '78560123'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '77942885'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '78551982'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '79513383'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '78838945'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '79515643'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '80778213'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '79794602'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '79714070'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '80201317'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '81173642'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '79725089'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '81764470'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '82163867'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '81969691'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '82458933'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '82235963'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '83161361'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '85519013'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '85482344'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '90817875'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '92573004'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '94375856'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '96562817'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '98790511'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '100820533'
update archive13F set
compid = '147484',
sectorNum = '101002',
sectorDes = 'Auto Manufacturers',
issuerCik = '0000103862'
where entryId = '103291963'
End Function
The Script is complete, exiting....