[計算機]經(jīng)營分析報表接口配置維護表說明-wenkub
2023-04-07 13:21:12 本頁面
【正文】 103102:JJBSC1:42九江市九江市9975631010103102:JJBSC3:45九江市九江市使用說明：不需要進行維護nrmdb:GEO_VIEW表：create view informix.geo_view (geo_id,geo_name,region_id) as select , , from informix .region_city_local x0 union select , , from informix.objects_manu x1 where (( = 40000 ) AND ( NOT IN (2 ,5 )) ) 。經(jīng)營分析報表接口配置維護表說明region_code表：create table informix.region_code ( region_id integer, region_name varchar(20), code integer )。Geo_idGeo_nameRegion_id132351308蓮花縣108944173390178031萬年縣52045620115421361新干縣12776288041南昌昌北區(qū)10015155743南昌城中區(qū)10015155744南昌高新區(qū)1001515574使用說明：此表不用維護nrmdb:site_geo_map表create table informix.site_geo_map ( int_id integer, geo_name varchar(32), geo_id integer )。Informix:: 20 17 * * * /opt/ /tmp/ 2amp。 tpa_msc_mss_sum_view表聯(lián)通報表中用到的表view_a_traff_msc表create view informix.view_a_traff_msc (a_interface_traf_bh,a_interface_traf_d,ne_id,press_date) as select , , , from informix.tpa_unic_msc_sum x0 ,informix.tpa_unic_msc_sum x1 where ((((((((( = 19 ) AND ( = ) ) AND ( = 10003 ) ) AND (
教學課件相關推薦
鄂ICP備17016276號-1