Shell Programming and Scripting

select 
    b.field_value, 
    b.cust_ac_no, 
    b.net_svc_id, 
    b.inst_seq_no, 
    b.field_id, 
    b.comp_status, 
    b.inst_status, 
    b.inststdt 
        into bash_temp -- is this create a table name bash_temp?
        from 
        ${REO_SWITCH_USERID_LUZON_DB} a,
        ${REO_RECON_USERID_LUZON} b
        where
        a.Username=b.field_value 
    and b.field_id='USERID'

select 
    field_value, 
    max(inststdt)inst_st_dt
    into bash_temp2 
    from bash_temp 
    group by field_value
    
select 
    a.Realm, 
    a.Username, 
    a.Status, 
    a.Service_number, 
    b.inst_st_dt
        into bash_temp3 -- is this create a table name bash temp3?
        from ${REO_SWITCH_USERID_LUZON_DB} a
        left join bash_temp2 b
        on 
        a.Username=b.field_value
        
select * into ${REO_BASH_USERID_LUZON_ICCBS}
    from bash_temp3 where inst_st_dt not in (NULL,null,'',"")
    go
    drop table bash_temp
    drop table bash_temp2
go
EOF

BASH_COUNT=`${SERVER_DATABASE} -b << EOF 2>>/dev/null
SET nocount on
select count(*) from ${REO_BASH_USERID_LUZON_ICCBS}
go
EOF`