发表于 2009-1-5 19:48
| 
鑱旈偊 锛 鏁版嵁搴撲簰鎿嶄綔鎬э紙绗 1 閮ㄥ垎锛
鍙戝竷: 2008-7-01 13:53 | 浣滆: admin | 鏌ョ湅: 13娆
鑱旈偊 锛 鏁版嵁搴撲簰鎿嶄綔鎬э紙绗 1 閮ㄥ垎锛
鐑 鑽
銆愬瓧浣擄細灏 澶с
鑱旈偊 锛 鏁版嵁搴撲簰鎿嶄綔鎬э紙绗 1 閮ㄥ垎锛
浣滆咃細锛 鏂囩珷鏉ユ簮锛氾紞 鐐瑰嚮鏁帮細1141 鏇存柊鏃堕棿锛2006-4-22 
Marty Lurie
IBM 绯荤粺宸ョ▼甯, 椹惃璇稿宸烇紝娌冨皵鐟熷锛圵altham锛
2003 骞 8 鏈 娴佽浣滃鍜屾帹鑽愯 Marty Lurie 瑙ｅ喅浜嗚仈閭﹂棶棰 锛 涔熷氨鏄暟鎹仈閭︺侻arty 璇存槑浜 IBM 鑱旈偊鏁版嵁搴撴妧鏈殑宸ヤ綔鍘熺悊銆佸叧閿殑鎶鏈垚鍔熷洜绱犱互鍙婂湪閽堝杩欎簺鍥犵礌杩涜娴嬭瘯鏃跺浣曡瘉鏄 IBM 瀹炵幇鏈夋晥銆
绠浠
濡傛灉鎮ㄦ湁澶氱鏁版嵁搴擄紝閭ｄ箞鎮ㄥ簲璇ヤ細鍙戠幇璁╁畠浠浉浜掗氫俊鏄竴浠堕夯鐑︿簨銆傛湰鏂囧皢閫氳繃瑙ｅ喅鏁版嵁搴撲箣闂寸殑浜掓搷浣滄ф潵甯姪鎮ㄦ洿鏂逛究鍦板鐞嗚繖涓闂銆傛垜浠皢浣跨敤 IBM 鎴樼暐鎬ц仈閭︽暟鎹簱鎶鏈 锛 IBM® DB2® 淇℃伅闆嗘垚鍣紙DB2® Information Integrator锛夌殑鏍稿績銆傛垜浠皢鐮旂┒璇ユ妧鏈殑宸ヤ綔鍘熺悊銆佸叧閿殑鎶鏈垚鍔熷洜绱犱互鍙婂湪閽堝杩欎簺鍥犵礌杩涜娴嬭瘯鏃跺浣曡瘉鏄 IBM 瀹炵幇鏈夋晥銆傚湪鏈枃鐨勭 2 閮ㄥ垎涓垜浠繕灏嗙爺绌舵彃鍏ユц兘浠ュ強濡備綍鑱旈偊鏈嶅姟鍣紝浠ヤ究浠庡瓨鍌ㄥ湪澶氫釜鏁版嵁婧愮殑鏁版嵁涓敓鎴 XML銆
涓轰綍鎴戦渶瑕佹暟鎹簱鑱旈偊锛屽彟澶栦粈涔堟槸鏁版嵁搴撹仈閭︼紵
浣滀负涓浣 DBA锛屾偍鎴栬涓嶆効绠＄悊璁稿涓嶅悓鍝佺墝鐨勬暟鎹簱 锛 鎴戣繕娌＄鍒拌繃鏈 DBA 杩欎箞璇达細“鏄殑锛屼笉閿欙紝鎴戞兂瑕佸悇绉嶄笉鍚岀殑鏁版嵁搴擄紝鎴戣繕涓嶅蹇欍”濡傛灉鎮ㄥ彲浠ヤ娇鐢ㄦ墍鏈変笉鍚岀殑鏁版嵁搴擄紝鍖呮嫭閫夋嫨銆佹彃鍏ャ佹洿鏂板拰鍒犻櫎锛屽氨璞℃墍鏈夌殑琛ㄩ兘浣嶄簬鍗曚釜鏁版嵁搴撲腑閭ｆ牱锛岄偅涔堝皢鑾峰緱闈炲父楂樼殑宸ヤ綔鏁堢巼銆傛暟鎹簱鑱旈偊灏辨槸瑕佸仛鍒拌繖涓鐐癸細浣挎墍鏈夎〃鐪嬭捣鏉ヨ薄鏄湪鍚屼竴涓暟鎹簱涓備笅闈㈢殑鏍锋湰 SQL 姝ｆ槸璇存槑浜嗚繖椤规妧鏈槸澶氫箞鐨勫己澶э細
db2 => insert into remote_informix select a.customer, b.balance, c.limit from remote_db2 a, remote_oracle b, remote_sybase c where c.limit > 10000 and a.c_key = b.c_key and a.c_key = c.c_key;
