3. 鍒楀嚭鎵鏈夊疄渚?db2inst1):db2ilist
4. 鍒楀嚭褰撳墠瀹炰緥:db2 get instance聽
5. 鏇存柊鏁版嵁搴撶鐞嗗櫒鍙傛暟淇℃伅:db2 update dbm cfg using para_name para_value
6. 鍒涘緩鏁版嵁搴?db2 create db test
7. 瀵熺湅鏁版嵁搴撻厤緗弬鏁頒俊鎭痙b2 get db cfg for test|more
8. 鏇存柊鏁版嵁搴撳弬鏁伴厤緗俊鎭痙b2 update db cfg for test using para_name para_value
9. 瀵熺湅紺轟緥閰嶇疆鏂囦歡:db2 get dbm cfg|more
10.鍒犻櫎鏁版嵁搴?db2 drop db test
11.榪炴帴鏁版嵁搴揹b2 connect to test
12.鍒楀嚭鎵鏈夎〃絀洪棿鐨勮緇嗕俊鎭俤b2 list tablespaces show detail
13.鏌ヨ鏁版嵁:db2 select * from tb1
14.鏁版嵁:db2 delete from tb1 where id=1
15.鍒涘緩绱㈠紩:db2 create index idx1 on tb1(id);
16.鍒涘緩瑙嗗浘:db2 create view view1 as select id from tb1
17.鏌ヨ瑙嗗浘:db2 select * from view1
18.鑺傜偣緙栫洰db2 catalog tcpip node node_name remote server_ip server server_port
19.瀵熺湅绔彛鍙穌b2 get dbm cfg|grep SVCENAME
20.嫻嬭瘯鑺傜偣鐨勯檮鎺b2 attach to node_name
21.瀵熺湅鏈湴鑺傜偣db2 list node directory
22.鑺傜偣鍙嶇紪鐩甦b2 uncatalog node node_name
23.鏁版嵁搴撶紪鐩甦b2 catalog db db_name as db_alias at node node_name
24.瀵熺湅鏁版嵁搴撶殑緙栫洰db2 list db directory
25.榪炴帴鏁版嵁搴揹b2 connect to db_alias user user_name using user_password
26.鏁版嵁搴撳弽緙栫洰db2 uncatalog db db_alias
27.瀵煎嚭鏁版嵁db2 export to myfile of ixf messages msg select * from tb1
28.瀵煎叆鏁版嵁(ixf)聽聽import from myfile of ixf messages msg replace into tb1
28.瀵煎叆鏁版嵁(del) import from myfile聽of del insert into tb1
29.瀵煎嚭鏁版嵁搴撶殑鎵鏈夎〃鏁版嵁db2move test export
30.鐢熸垚鏁版嵁搴撶殑瀹氫箟db2look -d db_alias -a -e -m -l -x -f -o db2look.sql
31.鍒涘緩鏁版嵁搴揹b2 create db test1
32.鐢熸垚瀹氫箟db2 -tvf db2look.sql
33.瀵煎叆鏁版嵁搴撴墍鏈夌殑鏁版嵁db2move db_alias import
34.閲嶇粍媯(gè)鏌b2 reorgchk
35.閲嶇粍琛╰b1db2 reorg table tb1
36.鏇存柊緇熻淇℃伅db2 runstats on table tb1
37.澶囦喚鏁版嵁搴搕estdb2 backup db test
38.鎭㈠鏁版嵁搴搕estdb2 restore db test
39.鍒楀嚭瀹瑰櫒鐨勪俊鎭痙b2 list tablespace containers for tbs_id show detail
40.鍒涘緩琛?db2 ceate table tb1(id integer not null,name char(10))
41.鍒楀嚭鎵鏈夎〃db2 list tables
42.鎻掑叆鏁版嵁:db2 insert into tb1 values(1,鈥檚am鈥?;db2 insert into tb2 values(2,鈥檚mitty鈥?;
]]>
瑙ｅ喅鍔炴硶: 涓嶇敤鍛戒護(hù)琛屽鐞嗗櫒(褰撶劧涔熶笉鐢≦uest Contral涔嬬被鐨勭涓夋柟宸ュ叿,涓昏鏄洜涓烘湇鍔″櫒鐨勫師鍥? , 緙栧啓涓涓壒澶勭悊: db2cmd -c db2 -z log.out -td@聽聽 -f mysql.clp .聽鍏朵腑, mysql.clp涓殑sql瑕佸仛閮ㄥ垎鏀瑰姩,涓昏鏄洜涓虹粨鏉熺鐨勯棶棰? 濡?
CREATE FUNCTION F_YEAR_ALL_DAYS
聽(THE_DAY VARCHAR(10)
聽)
聽 RETURNS TABLE
聽聽 (ROWID INTEGER,
聽聽聽 DETAIL_DATE DATE
聽聽 )
聽 SPECIFIC SQL071218171441700
聽 LANGUAGE SQL
聽 NOT DETERMINISTIC
聽 READS SQL DATA
聽 STATIC DISPATCH
聽 CALLED ON NULL INPUT
聽 EXTERNAL ACTION
聽 INHERIT SPECIAL REGISTERS
聽 p1:begin atomic
聽聽聽 DECLARE v_first_day VARCHAR(10);
聽聽聽 SET v_first_day = substr(THE_DAY,1,4)||'-01'||'-01';
聽聽聽 RETURN
聽聽聽聽聽 select T.rowid,T.detail_date
聽聽聽聽聽聽聽 from (
聽聽聽聽聽聽聽聽聽 select a.rowid,a.detail_date
聽聽聽聽聽聽聽聽聽聽聽 from (
聽聽聽聽聽聽聽聽聽聽聽聽聽 select ROW_NUMBER() over() as rowid, (DATE(v_first_day) + (
聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 ROW_NUMBER() over() - 1) day ) as detail_date
聽聽聽聽聽聽聽聽聽聽聽聽聽聽聽 from table_a) a
聽聽聽聽聽聽聽聽聽聽聽 where year(a.detail_date) = year(v_first_day)) as T;
聽 end p1@
榪欓噷,鍑芥暟浣撲腑鐨勫垎鍙風(fēng)粨鏉熺騫舵病鏈夋敼鍔?鍙槸鍦ㄥ嚱鏁頒綋澶栧洿瀹氫箟鐨勫湴鏂瑰姞浜嗕竴涓爣蹇楃p1,騫剁敤@浠ｆ浛鍒嗗彿緇撴潫絎?
]]>
I found that if I remove the project and re-add it again it works (clean all and build all did not work). Strange but at least it works now ;-)
鏈漢姣旇緝鎳?瑙夊緱remove 鍚庡啀re-add澶夯鐑?, 鎴戠殑鍋氭硶鏄洿鎺ュ皢鍑洪敊鐨刾roject, close鎺?鐒跺悗鍐峯pen. 鍙戠幇緙栬瘧绔熺劧涔熷ソ浜?
]]>
]]>
]]>
聽聽聽聽聽聽榪囦簡鍑犲ぉ錛岃繖涓漢鎵懼埌浜嗙編鍥介瀵屻佺煶娌瑰ぇ鐜嬫礇鍏嬭彶鍕掞紝瀵逛粬璇達(dá)細(xì)鈥滃皧鏁殑媧涘厠鑿插嫆鍏堢敓錛屾垜鎯崇粰浣犵殑濂沖効鎵句釜瀵硅薄銆傗濇礇鍏嬭彶鍕掕錛氣滃揩婊氬嚭鍘誨惂錛佲濊繖涓漢鍙堣錛氣滃鏋滄垜緇欎綘濂沖効鎵劇殑瀵硅薄錛屼篃灝辨槸浣犳湭鏉ョ殑濂沖┛鏄笘鐣岄摱琛岀殑鍓昏錛屽彲浠ュ悧錛熲濅簬鏄礇鍏嬭彶鍕掑氨鍚屾剰浜嗐?
聽聽聽聽聽聽鍙堣繃浜嗗嚑澶╋紝榪欎釜浜烘壘鍒頒簡涓栫晫閾惰鎬昏錛屽浠栬錛氣滃皧鏁殑鎬昏鍏堢敓錛屼綘搴旇椹笂浠誨懡涓涓壇鎬昏錛佲濇昏鍏堢敓鎽囩潃澶磋錛氫笉鍙兘錛岃繖閲岃繖涔堝鍓昏錛屾垜涓轟粈涔堣繕瑕佷換鍛戒竴涓壇鎬昏鍛紝鑰屼笖蹇呴』椹笂錛熲滆繖涓漢璇達(dá)細(xì)鈥濆鏋滀綘浠誨懡鐨勮繖涓壇鎬昏鏄礇鍏嬭彶鍕掔殑濂沖┛錛屽彲浠ュ悧錛熲滄昏鍏堢敓褰撶劧鍚屾剰銆?/p>
]]>