[計(jì)算機(jī)]經(jīng)營分析報(bào)表接口配置維護(hù)表說明(編輯修改稿)
2025-04-19 13:21 本頁面
【文章內(nèi)容簡介】 VIEW_REGION_GEO_CODE表create view informix.view_region_geo_code (region_id,region_code,geo_name,geo_id,geo_code) as select , , , , from informix.geo_code x0 ,informix.geo_view x1 ,npmdb: informix.region_code x2 where (( = ) AND ( = ) ) 。Region_idRegion_codeGeo_nameGeo_idGeo_code1951565403752龍南縣208588348811951565403752于都縣167839253421951565403752全南縣157972734131951565403752瑞金市153141017141951565403752寧都縣131861893151951565403752上猶縣9111087966使用說明：此表不用維護(hù)view_a_traff表原來create view informix.view_a_traff (region_code,type,a_interface_traf_bh,a_interface_traf_d,first_result) as select (select from informix.region_code x3 where ( = ) ) ,11 ,NVL ((NVL ( ,0 )+ NVL ( ,0 )) ,0 ),NVL ((NVL ( ,0 )+ NVL ( ,0 )) ,0 ), from npmuser.tpa_msc_mss_sum_view x0 ,outer(informix.view_a_traff_msc x1 ) ,outer(informix.view_a_traff_sw x2 ) where (((((((( = 1 ) AND ( = 1 ) ) AND ( = 1 ) ) AND ( = ) ) AND ( = ) ) AND ( = ) ) AND (= ) ) AND ( = 10003 ) ) 。修改后：create view view_a_traff (region_code,type,a_interface_traf_bh,a_in
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號-1