请教一个特别的程序问题???? 象Sql Server、Oracle等数据库已经提供了复制的功能 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这位jsjkhanwei朋友你的要求可以用PB中的Data Pipe Line来实现不用编程序,只要在power builder中建好连接就可以了,选择Append--insert row方式。 leechie说的对,用PB中的Data Pipe Line来实现,具体脚本参考如下: transaction itrans_source,itrans_destination itrans_source = CREATE transaction itrans_source.DBMS = "SYC Sybase System 10/11" itrans_source.Database = "sjk_db" itrans_source.LogPass = "******" itrans_source.ServerName = "local_sjk" itrans_source.LogId = "user" itrans_source.AutoCommit = False itrans_source.DBParm = "" connect using itrans_source; itrans_destination = CREATE transaction itrans_destination.DBMS = "SYC Sybase System 10/11" itrans_destination.Database = "sjk_db" itrans_destination.LogPass = "******" itrans_destination.ServerName = "remote_sjk" itrans_destination.LogId = "user" itrans_destination.AutoCommit = False itrans_destination.DBParm = "" connect using itrans_destination;//dp_lssjbf是已经建好的管道对象,dw_1存放管道运行信息,u_pipe是管道类型用户对象 u_pipe i_upipe i_upipe=CREATE u_pipe i_upipe.dataobject="dp_lssjbf" gh = i_upipe.start(itrans_source,itrans_destination,w_lssjbf.dw_1) w_lssjbf.st_1.text=string(gh) destroy i_upipe destroy itrans_source destroy itrans_destination 求一个查询 这个统计的查询语句怎么写? 关于数据备份问题 求教一多条件的查询语句,在线等 一个mysql存储过程的问题? 难度系数 >8 的SQL语句 ! 高手帮忙 删除重复,合并总数 各位帮忙啊! 求一个SQL表取数的写法 再问有关分布式事务问题 请教一下: 请问Oracle webserver与Oracle webdb有什么异同? 如何解决Oracle中触发器产生递归现象?
不用编程序,只要在power builder中建好连接就可以了,选择
Append--insert row方式。
transaction itrans_source,itrans_destination
itrans_source = CREATE transaction
itrans_source.DBMS = "SYC Sybase System 10/11"
itrans_source.Database = "sjk_db"
itrans_source.LogPass = "******"
itrans_source.ServerName = "local_sjk"
itrans_source.LogId = "user"
itrans_source.AutoCommit = False
itrans_source.DBParm = ""
connect using itrans_source;
itrans_destination = CREATE transaction
itrans_destination.DBMS = "SYC Sybase System 10/11"
itrans_destination.Database = "sjk_db"
itrans_destination.LogPass = "******"
itrans_destination.ServerName = "remote_sjk"
itrans_destination.LogId = "user"
itrans_destination.AutoCommit = False
itrans_destination.DBParm = ""
connect using itrans_destination;
//dp_lssjbf是已经建好的管道对象,dw_1存放管道运行信息,u_pipe是管道类型用户对象
u_pipe i_upipe
i_upipe=CREATE u_pipe
i_upipe.dataobject="dp_lssjbf"
gh = i_upipe.start(itrans_source,itrans_destination,w_lssjbf.dw_1)
w_lssjbf.st_1.text=string(gh)
destroy i_upipe
destroy itrans_source
destroy itrans_destination