[HELP] DB2 klo gw union kok row nya malah menyusut y?

[Braincode]

gini gan..

gw bkin bbrpa view untuk 1 syntax



syntax asli nya :

<div style="margin:20px; margin-top:5px">
Spoiler for syntax1:


<div class="alt2" style="margin: 0px; padding: 6px; border: 1px inset;">
<div style="display: none;">


<div style="margin:20px; margin-top:5px; ">
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