Ӧо
APPLICATION RESEARCH OF COMPUTERS
2000 Vol.17 No.3 P.45-47




PowerBuilder/Sybaseϵͳеݿת
°ż
ժҪڴMISϵͳоһݿԭʼתƵݿеĴ⣬شϵFoxbaseݿתƵSybase 11ݿΪ˼ЧķԸַȱһһ˵ͱȽϡ
ؼʣͻ/ ODBC Pipeline ϵͳ
ڴ͵MISϵͳдǲÿͻ/(C/S)ϵṹڸϵͳݼд洢ڷݿСµMISϵͳʱݵĲɼ¼һҪĲ֡ԵżƷϵͳΪҪ¼棺1)ԭʼݵķּĶҪǴ̡Ŵ߹̵Ķݡ2)ϵͳеĵݺͲݵתƴԼûΪ˹Ĵ󣬴ĶҪFoxbaseAccessݿļ3)Ϣ̨FoxbaseAccessļ洢ķļ168Ϣ̨ķݵȡ
нPowerBuilder/Sybaseϵͳʵص2)3)Ĵ(ɱݿļݿеת)ȡļַʽԼַʽľƷ˵ÿַձԺԣȱ˱Ƚϡ
1importfile ( )ʵת
PowerBuilderһֽC/Sϵͳǰ˹ߣṩ˴ĹܺͺDataWindowݴҪɲ֣ǿĹܣimportfile( )ܹݵתơ
ʵֵĹڷϴһͬϵݿṹͬıһݴڶ(dw_fox)ȡԴݴڣݴڶimportfile( )תƵݴУupdate( )ݱ浽ıУ
dw_fox. importfi1e (cipan_file_name)
dw_fox. Update ( )
cipan_file_nameΪϵļ·ơô򵥣ȱԣڷݿнıĽṹбȽϸߵҪ󣬱֤ϸһԣӦĴЧݴתƵԼıС
2ODBCʵת
ODBCһֱ׼Ӧóӿ(API)Microsoft Windowsϵͳʵ֣һӦóͬʱӶԴʹñ׼SQLΪݲѯ䡣ڴͨODBC徲̬ؽһODBCӴϵFoxbaseݿ⣬дһصӱصݿ⣬ͨ󣬽Ч͵ƵһFoxbaseݿƵıУЧݾͿˡʵʴĹУطĴļǲͬģӵݿļĿ¼Ǳ仯ģôƵʱͲܹʵֽODBCĽӿڹ̶ƳڴʱһַʽǰһĴϵͳҪĿ¼ļƽпΪʹӦóиõӦԣûвȡַʽһַʽȡ̬ODBCӵķʽ
PowerBuilderODBCҪҪĲODBCȽһFoxBASEݿ(Foxbase)鿴pb.iniļʱµļ¼
PROFILE Foxtran
DBMS=ODBC
.......
DbParm=Connectstring='DSN=FoxBASE'
Prompt=0
AutoCommit=0
ͬעHKEY_CURRENT_USER Software\ODBC\ODBC.INI½ᷢѾעFoxBASEЩǶ̬ؽODBCṩҪϡ
ھPowerBuilderṩĺעһODBCӣȻ󴴽һӱ()ݿ⣬ӦĴҪ͵ϣĲ£
RegistrySet("HKEY_CURRENT_USER\Software\ODBC\ODBC.INI 
\FoxBASE", "Default Dir", regstring!, file_path) 
//FoxBASE
Transaction Foxtran
Foxtran=create Transaction //ǳʼ
Foxtran.DBMS="ODBC"
Foxtran.DBParm="Connectstring='DSN=FoxBASE'"
connect using Foxtran
FoxBASEעODBCƣFoxtranдFoxbaseݿȻгʼfile_pathǴݿڵ·(ɸûļ·ļȡ)ö̬ODBCͬͬʱıݿAccessSybase SQL anywhereȣһԡ
3ݹܵʵת
PowerBuilderݹܵڿ(Data Pipeline)(̬)дݺݽṹһЧķЩݿͬDBMSͬDBMSݴǲһݱ߱һּݣҲǸбݡתʱҪѡǣԴݿ⣬Ŀݿ⣬ƶݳԴݽƵĿıҪɵĹܵȡʹΪ˵䴦Ĺ̡
(1)ܵ(Pipe_copy_convert)Ȼһܵ͵ı׼ûu_pipelineһݴdw_pipe_errorsеĹдûʵԽиֵiu_pipeline=create u_pipelineiu_pipeline.DataObject="pipe_copy_convert"
(2)ԴݿĿݿ󣬳ʼ(ͬ)
Transaction Tran_sourse, Tran_dest
Tran_sourse=create Transaction
Tran_dest=create Transaction
...... //ʼ
(3)ݹܵ
start( )ɺ󣬲׽ӦĴcancel( )ֹݹִܵС
iu_pipeline.start (tran_sourse, tran_dest, dw_pipe_errors)
...... //
iu_pipeline.cancel( )
ݹܹܵȽϿٵġֱӵĽݿ(ṹ߲Լ)תƵݿⲢһУתûԭʼϵʱȡַ
4ؿϵͳʵת
ڽתĹУڸݵıĽṹǲһģԵżƷѵϢΪͬĵϢ̨ʹõֶͬμǲһģʵʵĴҲÿһֶεݶ壬߶ҪתݿУûҪԼҪѡֶΡ㷽ʽԼÿеԼ(ЩĿֵƵ)ϵķЩѡʵʵĴУǿǷݿϵͳõݿĽṹݿеĸֶγûǰûѡ󣬼һٽдö̬SQLһıҪûܹͨϵͳ˽ݿݣؿϵͳ󽫵õΪĽ
ODBCӵؿ󣬷ֲ˼ϵͳ(System table)һPbcatcolм¼ûݿĽṹеһ1ʾ(ΪADDRESS (ID, Name, Address, Phone))
 1

pbc_tnampbc tidpbc ownrpbc cnam
ADDRESSPublicID
ADDRESSPublicName
ADDRESSPublicAddress
ADDRESSPublicPhone

Уpbc_tnam¼ûݿı(Table name) (Foxbaseһһݿ)pbc_cnam¼ûݿ(Column name)
ûļƣȡ׺ɵõݿıһ꼴ȡûݿݿչʾûǰûҪѡ
DECLARE My_Cursor CURSOR FOR
SELECT pbcatcol.pbc_cnam
FROM pbcatcol
......
÷ϵͳõûݿĽṹһȽЧķܹδ֪ݿṹһʶҪ֪ĽṹȻһ⣬ͨϵͳܵõûݿеͣתݿʱҪûܹȷṩûѡĿȷĳһֶεܹ͡ȽϺõݵת൱ԣ򲢲ҪûݿͣԹ㷺ʹڸ͵ݿ(FoxbaseAccess) 
5ϵͳʵת
ҪȷһݿĽṹֻҪȷûݿֶ;Ϳˡ÷ؿϵͳķʽԵõݿֶûݿֶεȻ޷áͨSybaseݿϵͳԵõݿеıֶ͡Ƶʱǲȡַϵİ취(ݹܵ)PipelineûصݿתݿеһȻͨϵϵͳPbcatcolSyscolumnsSystypesPbcatcolͬǰһ¼ûıֶȣSyscolumnsм¼ݿбֶ(Name)ֶε(Type)ֶεĳ(Length);ȷ(PrecScale)ȡɴȡôӴתϵıĽṹ(ֱͨݴڵķʽɾ)
SELECT syscolumns.name, systypes.name
FROM pbcatcol, syscolumns, systypes, length
WHERE (syscolumns.type=systypes.type)
and (pbcatcol.pbc_cnam=syscolumns.name)
and ((pbcatcol.pbc_tnam= 'Address'))
6ݿļʵת
ݹܵͷϵͳϵķܹȽĽݵת⣬ȻҪصݿתϣ˷ĸռһĴ洢ռ䡣һַͨݿⱾĽṹϣջVisual C++ԶƵķʽݿļ(ַֻFoxbaseļ˷)ͼ1ʾĽṹļ洢ķʽǱͷ֣ͷʮƵ0DβͷĹǣһ32ֽļͷӵڶ32ֽںǵһֶͣ32ֽڿʼǵڶֶ͡Դƣֱ0Dṹ2ʾĲʮƵ00ǼдC-CharD-DateL-LogicalN-NumericM-MemoG-Genera1

2

ֶ111
1232
11ֽ
ࣩһֽ

PowerBuilderṩļFileOpen( )FileSeek( )FileRead( )FileClose( )ȣԷFoxbaseݿļõݿֶκ͡Ըֶεĳȿû趨ϵͳϵͳҪ趨ڷݿӦıö̬ݴ(Datawindow)ʾؿݺʹĽ 
7
ݵתкֵܶķʵʵĴУҪûϵͳƵȸǡĿҪƹ̼򵥣ҪûҪҪнϸߵӦԺԣԼٺڵά6ַϵͳƹеʵ֣ȡ˽ϺõЧ
°(ʵѧԺ  400065)
ż(ʵѧԺ  400065)
ο
1 Тȱ. Sybaseݿϵͳָ. :йˮ, 1997
2 [] Gallagher, S, Herbert, S.,  . Powerbuilder 5.0ƴȫ. : еҵ, 1997. 9
3 Powerbuilder Handbook, Sybase˾
ոڣ1999820
