
COMPUTER ENGINEERING
1999 25 8 Vol.25 No.8 1999



칹ݿݼ
޾ ־䣬˸
ժҪԲͬݿ֮ĲƷPowerbuilder벻ͬݿ֮ӷ̬ݹܵݴڣʵ칹ݿ֮ݼɡ
ؼʣݿ⣻ݼɣݹܵ
Data's Integration Between Hetero-structure Database
Wang Yanjun,Du Zhidian,Wang Yunge
(Department of Statistic,Hebei Economy Commerce University,Shijiazhuang 050016)
AbstractFor different products of Database,the author gives methods of how to connect different databases with PowerBuider,dynamically generate Data pipelines and Datawindow to integrate data between hetero-structure Databases.
Key wordsDatabase;Data-integration;Pipeline
ͨԼַۺϱȽϣΪ PowerBuilder ӦóкܸߵĻԣṩ˶Կͻ / ṹֶ֧֣֧绷Դʵ칹ݿ⼯ɣϵͳά¾ܲ PowerBuilder пʵ칹ݿݼɡ 
1 ݹܵ
ݹܵ (PipeLine)  PowerBuilder ṩһתݵĶṩݸƹܣûһ RDBMS һ RDBMS ݡݹܵܿͬĿǰ PowerBuilder ֵ֧ݿһͨݹܵΪ󱣴棬ӦʹǣԿȫµķֲʽݹܵǿͲ Oracle  Sybase ݸƹܡ 
ݹܵǸ RDBMS ԱȫԿЩӦӦĿеݶΣԼʹЩֶĿ SQL Select ǸݵĻӲĶԴͨݹܵûڸݿ֮תʵʿиù߷ǳã 
 PowerBuilder У PipeLine ʴݹܵ󡣵ַݹܵԴǹ̶ġҪԶвҪΪÿһݹܵȻַȡΪһϵͳһҪʮǧԼϵͳݽת乤ǿ֪ġ⣬Ƿɶ̬ݹܵÿѡһһݹܵȷʡʹתڶ̬ɣǿͨԡ 
2 
ȥһ㶼ʹһЩСݿݽб͹ dBASE  Foxbase ݿȣûΪõعѿʼʹһЩݿ⣬ Oracle  Sybase ݿȡϵͳĿĿѡ Windows ݿ Client ˵Ŀ PowerBuilder Ϊǰ˿ Server ѡ Oracle ݿ⣬ֲ֧ TCP/IP Э Unix ϵͳϵͳṹͼ 1 ʾ 

ͼ1 ϵͳṹͼ
3 ʵ 
3.1 PowerBuilder ݿ 
ͨһӦֻһݿϵͳȻ PowerBuilder ʵ칹ݿת벻ͬݿϵͳܹ PowerBuilder ݿͨõ PowerBuilder ݿ֮ͨŵһõȱʡ SQLCA(SQL Communication Area) Դÿһݿͨš 
涨 s_trans  d_trans ʵ PowerBuilder Դݿ⡢Ŀݿӣ 
// ԴĶ 
s_trans = create transaction 
s_trans.DBMS=ProfileString("Foxpro.ini","database","dbms", "") 
 
s_trans.dbparm=ProfileString("Foxpro.ini","database","dbparm", "") 
connect using s_trans; 
// ĿĵĶ 
d_trans = create transaction 
...... 
connect using d_trans; 
3.2 ѡת 
ԴݴʾԴݺûɸҪһҪѡݿ¼תаֶϵֵûɽѡֶ͵ĲͬҲҪд 
3.3 Դȡ 
ʱ Open ¼Ϊ֤ڵУ Open ¼öڸôڵһЩʵڶĳʼ״̬ 
ԴӺڽת֮ǰȴԴȡݡ˴ԴݿļΪ .dbf ļ ,  Select DBF File ԻûɴѡȡҪתݿ⡣
ڶȡʱΪֶεͲͬҪֱдݹܵ䣺 
ls_PIPELINE="PIPELINE(source_connect=Foxpro,destination_connect=Oracle,type=replace,& commit=100,errors=100)  r  n" 
ls_SOURCE ="SOURCE(name=  ""+ls_named+"  "," 
ls_RETRIEVE ="RETRIEVE(statement=  "PBSELECT( VERSION(400) & TABLE(NAME=  ""+ls_named+"  " )" 
 
// ֶεĲͬͷ 
CHOOSE CASE String(BlobMid(lb_DBF_Head,44+(li_n - 1)*32,1)) 
CASE "C" 
ls_create_table=ls_create_table+"character(" 
lb_width_high=BlobMid(lb_DBF_Head,48+(li_n -1)*32,1) 

END CHOOSE 
// ܽ 
ls_pipe_syntax=ls_PIPELINE+ls_SOURCE+ls_RETRIEVE+ls_DESTINATION 
Դȡݺ󣬸ȡӦݴڣʾԴݡ 
3.4 ת 
굥 [ ת ] ťʱ clicked ¼£ 
uo_pipe iuo_pipe 
iuo_pipe=CREATE uo_pipe 
iuo_pipe.syntax=ls_pipe_syntax 
li_start_result = iuo_pipe.Start(i_src,i_dst,dw_pipe_err) 
Ӧؼ¼ҪǶ̬һݹܵݴ͹תʱʹ PowerBuilder ṩݹܵϵͳΪҪһûû̳ͨ PowerBuilder õݹܵϵͳ󴴽ġ 
ͨܵݴʾݹûʱݱΪ Oracle ݿļʽûɶԱеݽЧĹ 
3.5 ת 
ͨݴڣʹ ODBC ݴедĿݿУݿݵļɡ 
4 
 PowerBuilder ṩݹܵⷽʵݸʽ תɰѿʹõ Foxpro ݿϵͳɵ Oracle  Sybase ȴݿϵͳϣӶЧԭеݿԴ PowerBuilder ṩݹܵƵĳĿǰø÷̽תϺá 
עͣڿ " ¹칹ݿݼ " Ļɵġ 
ߵλ޾˸񡡺ӱʦѧϵʯׯ 050016
־䡡ӱóѧͳϵʯׯ 050061
ο 
1 Yourdon E. Javathe Web and Software Development. Compu- ter, 1996-08 
2 Marsh K, Braunstein B. PowerBuilder 4 Ӧó򿪷ָ.  廪ѧ磬 1996 
3 ոܣףΰ. ʵ Oracle ϵͳ.  ӹҵ磬 1995 
4 棬.PowerBuilder Ӧ. 廪ѧ 磬1995 
