发表于 2009-1-5 19:48
| 
DB2 閫氱敤鏁版嵁搴撲腑鏈変粈涔堟柊澧炲姛鑳
鍙戝竷: 2008-7-01 13:51 | 浣滆: admin | 鏌ョ湅: 4娆
DB2 閫氱敤鏁版嵁搴撲腑鏈変粈涔堟柊澧炲姛鑳
鐑 鑽
銆愬瓧浣擄細灏 澶с
DB2 閫氱敤鏁版嵁搴撲腑鏈変粈涔堟柊澧炲姛鑳
浣滆咃細锛 鏂囩珷鏉ユ簮锛氾紞 鐐瑰嚮鏁帮細970 鏇存柊鏃堕棿锛2006-4-22 
DB2 UDB 鎶鏈笓瀹, IBM 缃楀交鏂壒
2002 骞 11 鏈 DB2 UDB 鐨 iSeries V5R2 鐗堟湁璁稿寮哄ぇ鐨勬柊鐨勫姛鑳介儴浠讹紝鍖呮嫭璁稿鏂扮殑 SQL銆佸寮虹殑鎬ц兘銆佹敼杩涚殑鍙敤鎬у拰鎭㈠鍔熻兘浠ュ強鏇翠赴瀵岀殑宸ュ叿鏉ヤ娇鎮ㄧ殑宸ヤ綔鏇村鏄撱
缂栬呮寜锛氭湰鏂囩殑涓涓被浼肩増鏈娆″彂琛ㄥ湪 eServer Magazine, iSeries Edition銆
绠浠
SQL 浣滀负涓氬姟鏁版嵁璁块棶璇█鐨勭湡姝ｅ己澶т箣澶勫湪浜庯紝瀹冮氳繃鍏佽鎮ㄧ敤鍗曚竴璇锋眰瀹屾垚鏇村宸ヤ綔锛屽苟鍏佽鎮ㄥ皢閮ㄥ垎涓氬姟澶勭悊杞Щ鍒版暟鎹簱寮曟搸鏈韩锛屼粠鑰岀畝鍖栦簡缂栫爜銆傜敱浜 SQL 鏄暟鎹簱璁块棶鐨勪笟鐣屾爣鍑嗭紝鎵浠ラ氳繃鍦ㄦ暟鎹簱鏈嶅姟鍣ㄤ箣闂寸Щ妞嶅拰閲嶇敤鐜版湁鐨勫熀浜 SQL 鐨勪笟鍔￠昏緫锛屾偍涔熶細浠庝腑鍙楃泭銆俰Series™ V5R2 涓婄殑 DB2® Universal Database™锛圲DB锛夊紩鍏ョ殑鏂板姛鑳界户缁瀯寤哄湪 SQL 鐨勮繖浜涗紭鐐逛箣涓娿
V5R2 鐢ㄤ竴浜涙柊鐗规ф墿鍏呬簡 DB2 UDB for iSeries 鐨 SQL 鑳藉姏锛岃繖浜涚壒鎬ф棬鍦ㄥ悜搴旂敤绋嬪簭寮鍙戜汉鍛樻彁渚涙洿澶氱殑鐏垫椿鎬э紝骞跺府鍔╂秷闄ゅ皢闈 DB2 瑙ｅ喅鏂规鍚堝苟鍜岀Щ妞嶅埌 iSeries 鏃舵墍娑夊強鐨勫父瑙侀殰纰嶃傞氳繃瀵瑰瓧娈靛紩鐢ㄦ枃浠躲佸彲鍒囨崲鐨勬暟鎹簱缇ら泦浠ュ強 iSeries Navigator 鍥惧舰鐣岄潰鐨勬墿灞曟彁渚 SQL 鏀寔锛孷5R2 杩樼畝鍖栦簡 DB2 UDB for iSeries 鐨勭鐞嗐
SQL 澧炲己鍔熻兘
SQL 鏄竴绉嶅姛鑳藉己澶т笖涓嶆柇鏇存柊鐨勭紪绋嬭瑷銆傚叾棰戠箒澧炲己鐨勫姛鑳戒娇寰楄 DB2 瀹屾垚鏇村鐨勫伐浣滄垚涓哄彲鑳姐
鏍囪瘑鍒
褰撴柊鐨勮锛堟垨璁板綍锛夋彃鍏ュ埌琛ㄤ腑鏃讹紝閫氳繃鍛婄煡 DB2 鑷姩閫掑鍒楀硷紝鏍囪瘑鍒楀彲浠ョ敤浜庣敓鎴愪汉宸ユ垨浠ｇ悊閿笺備笉蹇呭垱寤洪掑涓嬩竴涓爣璇嗘垨缂栧彿鍊肩殑浠ｇ爜锛屽彲浠ヨ DB2 UDB 瀹屾垚杩欎釜宸ヤ綔銆傚涓嬫墍绀猴紝閫氳繃瀵圭敤灏忔暟浣嶄负闆剁殑鏁板兼暟鎹被鍨嬶紙numeric銆乨ecimal銆乮nteger銆乻mallint銆乥igint锛夊垱寤虹殑鍒楁寚瀹氭爣璇嗛夐」锛屾偍鍙互鍒涘缓鏍囪瘑鍒椼
CREATE TABLE employee ( empid INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 10 , INCREMENT BY 10) name CHAR(30), dept CHAR(4))
