I have a temp table ca_retainco_entities and i am trying to insert into it by using the below sql

Insert into ca_retainco_entities(ent_id)
select First 100000 e.entity_id
from entity e
where substr(e.hier_name,5,2) in ('CA')
and e.hier_name not in ('BGRVCAXFRLO','BGRVCAXFRS1','BLYTCABARL0','BLYTCA XF92K','BLYTCAXGRS1','BLYTCAXHRL1','CEVLCAXFRS6',
'HVSUCAXFRS1','PYVLCAAARL0','WDFRCAAARL0','WDFRCAX FRS1','PLVRCAXFRS1');

and i get the following error
944: Cannot use "first" in this context.

Help is really appreciated