Quote:
select e.id_investor,e.nama_pemohon_investor,e.status_inv estasi,a.id_permohonan,h.sektor,f.cetak_lokasi,c.i d_mata_uang,
c.modal_tanah,c.modal_bangunan,c.modal_mesin,c.mod al_kerja,c.modal_total
from xspipise.sp_r_model_1_2_3 a,xspipise.sp_r_cetak f,xspipise.sp_r_identifier_rencana b,xspipise.bidang_t_kbli_data g,xspipise.bidang_t_sektor_kbli h
,xspipise.pemohon_t_master_investor e,xspipise.sp_r_renc_investasi c
where e.id_investor=a.id_investor
and a.id_permohonan=b.id_permohonan
and a.id_permohonan=f.id_permohonan
and b.id_rencana_proyek=c.id_rencana_proyek
and b.kode_kbli=g.kode_kbli
and g.kode_sektor=h.kode_sektor
and e.nama_pemohon_investor is not null
and length(e.nama_pemohon_investor)>0
and (c.id_mata_uang>0 and c.id_mata_uang0
and (c.id_mata_uang>0 and c.id_mata_uang0 and c.modal_total is not null)
and c.id_mata_uang=1
create view modal_2(id_investor,nama_pemohon_investor,status_i nvestasi,id_permohonan,sektor,cetak_lokasi,id_mata _uang,
modal_tanah,modal_bangunan,modal_mesin,modal_kerja ,modal) as
select e.id_investor,e.nama_pemohon_investor,e.status_inv estasi,a.id_permohonan,h.sektor,f.cetak_lokasi,c.i d_mata_uang,
(c.modal_tanah*9500),(c.modal_bangunan*9500),(c.mo dal_mesin*9500),(c.modal_kerja*9500),(c.modal_tota l*9500)
from xspipise.sp_r_model_1_2_3 a,xspipise.sp_r_cetak f,xspipise.sp_r_identifier_rencana b,xspipise.bidang_t_kbli_data g,xspipise.bidang_t_sektor_kbli h
,xspipise.pemohon_t_master_investor e,xspipise.sp_r_renc_investasi c
where e.id_investor=a.id_investor
and a.id_permohonan=b.id_permohonan
and a.id_permohonan=f.id_permohonan
and b.id_rencana_proyek=c.id_rencana_proyek
and b.kode_kbli=g.kode_kbli
and g.kode_sektor=h.kode_sektor
and e.nama_pemohon_investor is not null
and length(e.nama_pemohon_investor)>0
and (c.id_mata_uang>0 and c.id_mata_uang0 and c.modal_total is not null)
and c.id_mata_uang=2
create view modal_3(id_investor,nama_pemohon_investor,status_i nvestasi,id_permohonan,sektor,cetak_lokasi,id_mata _uang,
modal_tanah,modal_bangunan,modal_mesin,modal_kerja ,modal) as
select e.id_investor,e.nama_pemohon_investor,e.status_inv estasi,a.id_permohonan,h.sektor,f.cetak_lokasi,c.i d_mata_uang,
c.modal_tanah,c.modal_bangunan,c.modal_mesin,c.mod al_kerja,c.modal_total
from xspipise.sp_r_model_1_2_3 a,xspipise.sp_r_cetak f,xspipise.sp_r_identifier_rencana b,xspipise.bidang_t_kbli_data g,xspipise.bidang_t_sektor_kbli h
,xspipise.pemohon_t_master_investor e,xspipise.sp_r_renc_investasi c
where e.id_investor=a.id_investor
and a.id_permohonan=b.id_permohonan
and a.id_permohonan=f.id_permohonan
and b.id_rencana_proyek=c.id_rencana_proyek
and b.kode_kbli=g.kode_kbli
and g.kode_sektor=h.kode_sektor
and e.nama_pemohon_investor is not null
and length(e.nama_pemohon_investor)>0
and (c.id_mata_uang>0 and c.id_mata_uang0
and (c.id_mata_uang>0 and c.id_mata_uang
[HELP] DB2 klo gw union kok row nya malah menyusut y?
