BMS-HOSxP Community
HOSxP => HOSxP PCU => ข้อความที่เริ่มโดย: suput ที่ มิถุนายน 30, 2009, 21:40:09 PM
-
1%ตลอดเลยครับตามภาพ รบกวนอาจารย์ช่วยด้วยครับ
select data_type from information_schema.columns where table_schema='hosxp_pcu' and table_name = 'house' and column_key = 'PRI'
select count(*) as cc from pcu_dw_track where table_name = 'house'
select * from pcu_dw_track where table_name = 'house'
select concat(sum(CONV(SUBSTRING(md5(house_id), 1,8),16,10)) , sum(CONV(SUBSTRING(md5(house_id), 9,8),16,10)), sum(CONV(SUBSTRING(md5(house_id), 17,8),16,10)), sum(CONV(SUBSTRING(md5(house_id), 25,8),16,10))) as sig from house
select column_name from information_schema.columns where table_schema='hosxp_pcu' and table_name = 'person' and column_key = 'PRI'
select data_type from information_schema.columns where table_schema='hosxp_pcu' and table_name = 'person' and column_key = 'PRI'
select count(*) as cc from pcu_dw_track where table_name = 'person'
select * from pcu_dw_track where table_name = 'person'
DELETE FROM pcu_dw_track
WHERE
pcu_dw_track_id = ?
:Old_pcu_dw_track_id(Integer,IN)=222105
DELETE FROM pcu_dw_track
WHERE
pcu_dw_track_id = ?
:Old_pcu_dw_track_id(Integer,IN)=222448
select hos_guid from person where person_id in (8870,7356)
select column_name from information_schema.columns where table_schema='hosxp_pcu' and table_name = 'person' and column_key = 'PRI'
select data_type from information_schema.columns where table_schema='hosxp_pcu' and table_name = 'person' and column_key = 'PRI'
select count(*) as cc from pcu_dw_track where table_name = 'person'
select * from pcu_dw_track where table_name = 'person'
select concat(sum(CONV(SUBSTRING(md5(person_id), 1,8),16,10)) , sum(CONV(SUBSTRING(md5(person_id), 9,8),16,10)), sum(CONV(SUBSTRING(md5(person_id), 17,8),16,10)), sum(CONV(SUBSTRING(md5(person_id), 25,8),16,10))) as sig from person
select concat(sum(CONV(SUBSTRING(md5(person_id), 1,8),16,10)) , sum(CONV(SUBSTRING(md5(person_id), 9,8),16,10)), sum(CONV(SUBSTRING(md5(person_id), 17,8),16,10)), sum(CONV(SUBSTRING(md5(person_id), 25,8),16,10))) as sig from person
select column_name from information_schema.columns where table_schema='hosxp_pcu' and table_name = 'sex' and column_key = 'PRI'
select data_type from information_schema.columns where table_schema='hosxp_pcu' and table_name = 'sex' and column_key = 'PRI'
select count(*) as cc from pcu_dw_track where table_name = 'sex'
select * from pcu_dw_track where table_name = 'sex'
select concat(sum(CONV(SUBSTRING(md5(code), 1,8),16,10)) , sum(CONV(SUBSTRING(md5(code), 9,8),16,10)), sum(CONV(SUBSTRING(md5(code), 17,8),16,10)), sum(CONV(SUBSTRING(md5(code), 25,8),16,10))) as sig from sex
-
เป็นเหมือนกันครับ 52.6.19 , 52.6.25e
สุดท้ายต้องถอยกลับไปเป็น 52.4.20 ส่งถึงจะมี error น้อยลง ส่งต่อได้
-
ตอนนี้กำลังปรับปรุงระบบ ETL Agent / Server ใหม่ครับ ต้อง ติดตั้งตัว Datacenter Manager รุ่น 3.52.7.x ขึนไปก่อนครับ (กำลัง Upload)