飛舞的幻想
          

          

          

          
	
		

          導航
          

		
          
	
          
		
          <2008年6月>
          
	
          日一二三四五六
          25262728293031
          1234567
          891011121314
          15161718192021
          22232425262728
          293012345
          

          

		
		

          留言簿(8)
          


		
		
          隨筆分類
          
		
				
			
	
		
          文章分類
          
		
				
			
	
		
          收藏夾
          
		
				
			
	
		
          隨筆檔案
          
		
				
			
	
		
          文章檔案
          
		
				
			
	
		
          相冊
          
		
				
			
	

		

          閱讀排行榜
          


		

          評論排行榜
          

		
	

          

          
	
		

          常用鏈接
          

		

          統計
          
	
		
		
		
          Google Adsense
          
		
				
			
	
		
          Zanox  FWHX
          
		
				
			
	
		
          花個明白
          
		
				
			
	

		

          最新評論
	
          

          
	
			
		

          
		
	

          

          
	
					

          
	2008年6月30日		  
	#

          


		
          
			
          DB2 時間轉換
          
			
			create function ts_fmt(TS timestamp, fmt varchar(20)) 
returns varchar(50) 
return 
with tmp (dd,mm,yyyy,hh,mi,ss,nnnnnn) as 
( 
 select 
 substr( digits (day(TS)),9), 
 substr( digits (month(TS)),9) , 
 rtrim(char(year(TS))) , 
 substr( digits (hour(TS)),9), 
 substr( digits (minute(TS)),9), 
 substr( digits (second(TS)),9), 
 rtrim(char(microsecond(TS))) 
 from sysibm.sysdummy1 
 ) 
select 
case fmt 
 when 'yyyymmdd' 
 then yyyy || mm || dd 
 when 'mm/dd/yyyy' 
 then mm || '/' || dd || '/' || yyyy 
 when 'yyyy/dd/mm hh:mi:ss' 
 then yyyy || '/' || mm || '/' || dd || ' ' || 
 hh || ':' || mi || ':' || ss 
 when 'nnnnnn' 
 then nnnnnn 
 else 
 'date format ' || coalesce(fmt,'  ') || 
 ' not recognized.' 
 end 
from tmp 
使用例句：
update t_attachment as a set a.attach_path=(select '/'||rtrim(char(apply_com_id))||'/'||rtrim(char(ts_fmt(apply_date,'yyyymmdd')))||'/' from t_rmbs_claim as c
where a.claim_id=c.claim_id)||rtrim(a.attach_path) where exists (select 1 from t_rmbs_claim as tc where tc.claim_id=a.claim_id);



			
			
          		
				posted @ 2010-03-05 18:18 飛舞的幻想 閱讀(278) | 評論 (0) | 編輯 收藏
			
          
		
          
	
		
          
			
          DB2 restore Redirect
          
			
			(1)db2 restore db EFINANCE incremental from /db2/eFinance091228  taken
at 200912282115 on /db2/eFinanceWJ28 into EFINAN28 logtarget
/db2/eFinanceWJ28 redirect generate script  restore.clp
          
說明：EFINANCE 為備份前的數據庫名稱  EFINAN28 為回復后的數據庫名稱 /db2/eFinance091228備份文件存放的路徑  /db2/eFinanceWJ28為還原后日志存放路徑以及還原后數據庫文件路徑。
          

          
(2)db2 -tvf  restore.clp
          
如果需要重新指定表空間的路徑請修改該文件
          
該文件內容如下：
          
-- *****************************************************************************
          
-- ** automatically created redirect restore script
          
-- *****************************************************************************
          
UPDATE COMMAND OPTIONS USING S ON Z ON EFINANCE_NODE0000.out V ON;
          
SET CLIENT ATTACH_DBPARTITIONNUM  0;
          
SET CLIENT CONNECT_DBPARTITIONNUM 0;
          
-- *****************************************************************************
          
-- ** automatically created redirect restore script
          
-- *****************************************************************************
          
RESTORE DATABASE EFINANCE
          
-- USER  <username>
          
-- USING '<password>'
          
FROM '/db2/eFinance091228'
          
TAKEN AT 20091228211504
          
ON '/db2/eFinanceWJ28'
          
DBPATH ON '/db2/eFinanceWJ28'
          
INTO EFINAN28
          
LOGTARGET '/db2/eFinanceWJ28/'
          
-- NEWLOGPATH '/ef/appinst/appinst/NODE0000/SQL00002/SQLOGDIR/'
          
-- WITH <num-buff> BUFFERS
          
-- BUFFER <buffer-size>
          
-- REPLACE HISTORY FILE
          
-- REPLACE EXISTING
          
REDIRECT
          
-- PARALLELISM <n>
          
-- WITHOUT ROLLING FORWARD
          
-- WITHOUT PROMPTING
          
;
          
-- *****************************************************************************
          
-- ** table space definition
          
-- *****************************************************************************
          
-- *****************************************************************************
          
-- ** Tablespace name                            = SYSCATSPACE
          
-- **   Tablespace ID                            = 0
          
-- **   Tablespace Type                          = Database managed space                      
          
-- **   Tablespace Content Type                  = All permanent data. Regular table space.    
          
-- **   Tablespace Page size (bytes)             = 4096
          
-- **   Tablespace Extent size (pages)           = 4
          
-- **   Using automatic storage                  = Yes     
          
-- **   Auto-resize enabled                      = Yes     
          
-- **   Total number of pages                    = 24576
          
-- **   Number of usable pages                   = 24572
          
-- **   High water mark (pages)                  = 21080
          
-- *****************************************************************************
          
-- *****************************************************************************
          
-- ** Tablespace name                            = TEMPSPACE1
          
-- **   Tablespace ID                            = 1
          
-- **   Tablespace Type                          = System managed space                        
          
-- **   Tablespace Content Type                  = System Temporary data                       
          
-- **   Tablespace Page size (bytes)             = 4096
          
-- **   Tablespace Extent size (pages)           = 32
          
-- **   Using automatic storage                  = Yes     
          
-- **   Total number of pages                    = 1
          
-- *****************************************************************************
          
-- *****************************************************************************
          
-- ** Tablespace name                            = USERSPACE1
          
-- **   Tablespace ID                            = 2
          
-- **   Tablespace Type                          = Database managed space                      
          
-- **   Tablespace Content Type                  = All permanent data. Large table space.      
          
-- **   Tablespace Page size (bytes)             = 16384
          
-- **   Tablespace Extent size (pages)           = 32
          
-- **   Using automatic storage                  = No      
          
-- **   Auto-resize enabled                      = No      
          
-- **   Total number of pages                    = 1310720
          
-- **   Number of usable pages                   = 1310688
          
-- **   High water mark (pages)                  = 886976
          
-- *****************************************************************************
          
SET TABLESPACE CONTAINERS FOR 2
          
-- IGNORE ROLLFORWARD CONTAINER OPERATIONS
          
USING (
          
FILE   '/db2/eFinanTS28/eFinance/USERSPACE1'                                 1310720
          
);
          
-- *****************************************************************************
          
-- ** Tablespace name                            = TBS_DATA32K
          
-- **   Tablespace ID                            = 3
          
-- **   Tablespace Type                          = Database managed space                      
          
-- **   Tablespace Content Type                  = All permanent data. Large table space.      
          
-- **   Tablespace Page size (bytes)             = 32768
          
-- **   Tablespace Extent size (pages)           = 32
          
-- **   Using automatic storage                  = No      
          
-- **   Auto-resize enabled                      = No      
          
-- **   Total number of pages                    = 327680
          
-- **   Number of usable pages                   = 327648
          
-- **   High water mark (pages)                  = 9856
          
-- *****************************************************************************
          
SET TABLESPACE CONTAINERS FOR 3
          
-- IGNORE ROLLFORWARD CONTAINER OPERATIONS
          
USING (
          
FILE   '/db2/eFinanTS28/eFinance/TBS_DATA32K'                                 327680
          
);
          
-- *****************************************************************************
          
-- ** Tablespace name                            = TBS_DATA4K
          
-- **   Tablespace ID                            = 4
          
-- **   Tablespace Type                          = Database managed space                      
          
-- **   Tablespace Content Type                  = All permanent data. Large table space.      
          
-- **   Tablespace Page size (bytes)             = 4096
          
-- **   Tablespace Extent size (pages)           = 32
          
-- **   Using automatic storage                  = No      
          
-- **   Auto-resize enabled                      = No      
          
-- **   Total number of pages                    = 2621440
          
-- **   Number of usable pages                   = 2621408
          
-- **   High water mark (pages)                  = 25440
          
-- *****************************************************************************
          
SET TABLESPACE CONTAINERS FOR 4
          
-- IGNORE ROLLFORWARD CONTAINER OPERATIONS
          
USING (
          
FILE   '/db2/eFinanTS28/eFinance/TBS_DATA4K'                                 2621440
          
);
          
-- *****************************************************************************
          
-- ** Tablespace name                            = TBS_IDX4K
          
-- **   Tablespace ID                            = 5
          
-- **   Tablespace Type                          = Database managed space                      
          
-- **   Tablespace Content Type                  = All permanent data. Large table space.      
          
-- **   Tablespace Page size (bytes)             = 4096
          
-- **   Tablespace Extent size (pages)           = 32
          
-- **   Using automatic storage                  = No      
          
-- **   Auto-resize enabled                      = No      
          
-- **   Total number of pages                    = 2621440
          
-- **   Number of usable pages                   = 2621408
          
-- **   High water mark (pages)                  = 96
          
-- *****************************************************************************
          
SET TABLESPACE CONTAINERS FOR 5
          
-- IGNORE ROLLFORWARD CONTAINER OPERATIONS
          
USING (
          
FILE   '/db2/eFinanTS28/eFinance/TBS_IDX4K'                                  2621440
          
);
          
-- *****************************************************************************
          
-- ** Tablespace name                            = CMCC_DATA
          
-- **   Tablespace ID                            = 6
          
-- **   Tablespace Type                          = Database managed space                      
          
-- **   Tablespace Content Type                  = All permanent data. Large table space.      
          
-- **   Tablespace Page size (bytes)             = 16384
          
-- **   Tablespace Extent size (pages)           = 32
          
-- **   Using automatic storage                  = No      
          
-- **   Auto-resize enabled                      = No      
          
-- **   Total number of pages                    = 655360
          
-- **   Number of usable pages                   = 655328
          
-- **   High water mark (pages)                  = 32736
          
-- *****************************************************************************
          
SET TABLESPACE CONTAINERS FOR 6
          
-- IGNORE ROLLFORWARD CONTAINER OPERATIONS
          
USING (
          
FILE   '/db2/eFinanTS28/eFinance/CMCC_DATA'                                   655360
          
);
          
-- *****************************************************************************
          
-- ** Tablespace name                            = CMCC_DATA32
          
-- **   Tablespace ID                            = 7
          
-- **   Tablespace Type                          = Database managed space                      
          
-- **   Tablespace Content Type                  = All permanent data. Large table space.      
          
-- **   Tablespace Page size (bytes)             = 32768
          
-- **   Tablespace Extent size (pages)           = 32
          
-- **   Using automatic storage                  = No      
          
-- **   Auto-resize enabled                      = No      
          
-- **   Total number of pages                    = 327680
          
-- **   Number of usable pages                   = 327648
          
-- **   High water mark (pages)                  = 22496
          
-- *****************************************************************************
          
SET TABLESPACE CONTAINERS FOR 7
          
-- IGNORE ROLLFORWARD CONTAINER OPERATIONS
          
USING (
          
FILE   '/db2/eFinanTS28/eFinance/CMCC_DATA32'                                 327680
          
);
          
-- *****************************************************************************
          
-- ** Tablespace name                            = TBS_IDX01
          
-- **   Tablespace ID                            = 8
          
-- **   Tablespace Type                          = Database managed space                      
          
-- **   Tablespace Content Type                  = All permanent data. Large table space.      
          
-- **   Tablespace Page size (bytes)             = 4096
          
-- **   Tablespace Extent size (pages)           = 32
          
-- **   Using automatic storage                  = No      
          
-- **   Auto-resize enabled                      = No      
          
-- **   Total number of pages                    = 2621440
          
-- **   Number of usable pages                   = 2621408
          
-- **   High water mark (pages)                  = 274176
          
-- *****************************************************************************
          
SET TABLESPACE CONTAINERS FOR 8
          
-- IGNORE ROLLFORWARD CONTAINER OPERATIONS
          
USING (
          
FILE   '/db2/eFinanTS28/eFinance/TBS_IDX01'                                  2621440
          
);
          
-- *****************************************************************************
          
-- ** Tablespace name                            = DMS_TMP_32K
          
-- **   Tablespace ID                            = 9
          
-- **   Tablespace Type                          = Database managed space                      
          
-- **   Tablespace Content Type                  = System Temporary data                       
          
-- **   Tablespace Page size (bytes)             = 32768
          
-- **   Tablespace Extent size (pages)           = 32
          
-- **   Using automatic storage                  = No      
          
-- **   Auto-resize enabled                      = No      
          
-- **   Total number of pages                    = 327680
          
-- **   Number of usable pages                   = 327648
          
-- **   High water mark (pages)                  = 64
          
-- *****************************************************************************
          
SET TABLESPACE CONTAINERS FOR 9
          
-- IGNORE ROLLFORWARD CONTAINER OPERATIONS
          
USING (
          
FILE   '/db2/eFinanTS28/eFinance/DMS_TMP_32K'                                 327680
          
);
          
-- *****************************************************************************
          
-- ** Tablespace name                            = SYSTOOLSPACE
          
-- **   Tablespace ID                            = 10
          
-- **   Tablespace Type                          = Database managed space                      
          
-- **   Tablespace Content Type                  = All permanent data. Large table space.      
          
-- **   Tablespace Page size (bytes)             = 4096
          
-- **   Tablespace Extent size (pages)           = 4
          
-- **   Using automatic storage                  = Yes     
          
-- **   Auto-resize enabled                      = Yes     
          
-- **   Total number of pages                    = 8192
          
-- **   Number of usable pages                   = 8188
          
-- **   High water mark (pages)                  = 1512
          
-- *****************************************************************************
          
-- *****************************************************************************
          
-- ** Tablespace name                            = SYSTOOLSTMPSPACE
          
-- **   Tablespace ID                            = 11
          
-- **   Tablespace Type                          = System managed space                        
          
-- **   Tablespace Content Type                  = User Temporary data                         
          
-- **   Tablespace Page size (bytes)             = 4096
          
-- **   Tablespace Extent size (pages)           = 4
          
-- **   Using automatic storage                  = Yes     
          
-- **   Total number of pages                    = 1
          
-- *****************************************************************************
          
-- *****************************************************************************
          
-- ** Tablespace name                            = EF_ENGINE_16K
          
-- **   Tablespace ID                            = 12
          
-- **   Tablespace Type                          = Database managed space                      
          
-- **   Tablespace Content Type                  = All permanent data. Large table space.      
          
-- **   Tablespace Page size (bytes)             = 16384
          
-- **   Tablespace Extent size (pages)           = 32
          
-- **   Using automatic storage                  = No      
          
-- **   Auto-resize enabled                      = No      
          
-- **   Total number of pages                    = 655360
          
-- **   Number of usable pages                   = 655328
          
-- **   High water mark (pages)                  = 96
          
-- *****************************************************************************
          
SET TABLESPACE CONTAINERS FOR 12
          
-- IGNORE ROLLFORWARD CONTAINER OPERATIONS
          
USING (
          
FILE   '/db2/eFinanTS28/eFinance/EF_ENGINE_16K'                               655360
          
);
          
-- *****************************************************************************
          
-- ** Tablespace name                            = TEMPSPACE16k
          
-- **   Tablespace ID                            = 13
          
-- **   Tablespace Type                          = System managed space                        
          
-- **   Tablespace Content Type                  = System Temporary data                       
          
-- **   Tablespace Page size (bytes)             = 16384
          
-- **   Tablespace Extent size (pages)           = 32
          
-- **   Using automatic storage                  = No      
          
-- **   Total number of pages                    = 1
          
-- *****************************************************************************
          
SET TABLESPACE CONTAINERS FOR 13
          
-- IGNORE ROLLFORWARD CONTAINER OPERATIONS
          
USING (
          
PATH   '/db2/eFinanTS28/eFinance/C0000016k.TMP'
          
);
          
-- *****************************************************************************
          
-- ** start redirected restore
          
-- *****************************************************************************
          
RESTORE DATABASE EFINANCE CONTINUE;
          
-- *****************************************************************************
          
-- ** end of file
          
-- *****************************************************************************
          

          

          

          
(3)db2 rollforward database EFINAN28 to end of logs and complete  overflow log path '(/db2/eFinanceWJ28)'
          
說明：EFINAN28 為還原的數據庫名稱 /db2/eFinanceWJ28為日志存放路徑 注意 日志一定要全 即要包括回復的當天的全部log文件。

			
			
          		
				posted @ 2010-01-29 14:05 飛舞的幻想 閱讀(1686) | 評論 (0) | 編輯 收藏
			
          
		
          
	
		
          
			
          DB2學習的好地方 推薦
          
			
			http://www.db2china.net/club/?fromuid=328

			
			
          		
				posted @ 2009-05-13 00:21 飛舞的幻想 閱讀(176) | 評論 (0) | 編輯 收藏
			
          
		
          
	
		
          
			
          xp系統局域網在運行里訪問不了的問題(轉)
          
			
			這個問題一直沒弄明白，今天終于調出來了，其實調一下安全就可以了，如下：
          
依次打開
          
控制面板--管理工具--本地安全策略--本地策略--安全選項　　在里面找到一個叫：本地帳戶的共享和安全模式的選項，把它改成經典-本地用戶以自己的身份驗證　就可以了          

			
			
          		
				posted @ 2009-03-27 14:29 飛舞的幻想 閱讀(169) | 評論 (0) | 編輯 收藏
			
          
		
          
	
		
          
			
          通過Iframe實現帶橫向滾動條的多選下拉框并且帶提示框
          
			
			主要思路：

          
通過Iframe添加滾動條，在調用頁面使用Iframe實現滾動條，在iframe頁面里面實現多選select。通過主頁面將動態option傳遞給iframe的select實現下拉框。通過popup窗口的方式實現提示框。

          
說明：調用頁面代碼里面還加了一個隱藏多選下拉框的目的是為了將值方便的傳遞以及保持相對較少的代碼改動（主要是修改實現）。

          
調用頁面代碼：

          


          

            
    
          1. <select name=TMPFIELD size=9  style='width:160px;display:none;' multiple>  
            2. 
    
          2. <%  
            3. 
    
          3.    for(int opt5 =0;opt5<cols.size();opt5++){  
            4. 
    
          4.      RepColsVo colVo =(RepColsVo) cols.get(opt5);  
            5. 
    
          5. %>  
            6. 
    
          6. <option title="<%=colVo.getRepColdis()%>" value="<%=colVo.getReportColid()%>"><%=colVo.getRepColdis()%></option>  
            7. 
    
          7. <%}%>  
            8. 
    
          8. </select>  
            9. 
    
          9. <iframe name="iframeShowFields" src="<%=request.getContextPath()%>/jsp/include/iframeSelectReports.jsp"  id="iframeshow" allowTransparency="true"    style="z-index:0;height:150px;width:140px;" scrolling="auto">  
            10. 
    
          10. </iframe>  
            11. 

          

          


          
Iframe頁面內容：

          

          

            
    
          1. <html>  
            2. 
    
          2. <head>  
            3. 
    
          3. <script language="javascript">  
            4. 
    
          4.   var oP=window.createPopup();  
            5. 
    
          5.   var globalobject;  
            6. 
    
          6.   var oPopBody;  
            7. 
    
          7.   function   showTip(_obj){  
            8. 
    
          8.   globalobject=_obj;  
            9. 
    
          9.   oPopBody= oP.document.body;  
            10. 
    
          10.   line=parseInt(event.offsetY/15);  
            11. 
    
          11.   if(globalobject.options.length>0){  
            12. 
    
          12.   if(line>globalobject.options.length-1)  
            13. 
    
          13.   {    
            14. 
    
          14.       line=globalobject.options.length-1;   
            15. 
    
          15.   }   
            16. 
    
          16.   oPopBody.style.background="#fdfce9";   
            17. 
    
          17.   oPopBody.style.border="solid black 1px";  
            18. 
    
          18.   oPopBody.innerHTML="";  
            19. 
    
          19.   var sText =globalobject.options[line].text;      
            20. 
    
          20.   oPopBody.innerHTML='<div style="font-family:Arial;font-size:12px;">'+sText+'</div>';   
            21. 
    
          21.   len=globalobject.options[line].text.length*10;  
            22. 
    
          22.   oP.show(event.clientX+10,event.clientY+10,len, 20,document.body);  
            23. 
    
          23.   }   
            24. 
    
          24.  }  
            25. 
    
          25.  function   hideTip(_obj){    
            26. 
    
          26.   if(oP.isOpen){   
            27. 
    
          27.     oP.hide();    
            28. 
    
          28.    }  
            29. 
    
          29.  }  
            30. 
    
          30. function   addOption(){   
            31. 
    
          31.     var   s=parent.document.frmdefine.TMPFIELD;  
            32. 
    
          32.     var len=s.length;  
            33. 
    
          33.     for(var i=0;i<len;i++)  
            34. 
    
          34.     {  
            35. 
    
          35.         var opt=document.createElement("OPTION");        
            36. 
    
          36.         opt.text=s.options[i].text;    
            37. 
    
          37.         opt.value=s.options[i].value;  
            38. 
    
          38.         TMPFIELD.add(opt);  
            39. 
    
          39.     }  
            40. 
    
          40.        
            41. 
    
          41.    
            42. 
    
          42.  }  
            43. 
    
          43.  </script>  
            44. 
    
          44. </head>  
            45. 
    
          45. <body bgcolor="#efefef" onload="addOption()">  
            46. 
    
          46. <select  id="idtmpfield" onclick="showTip(this);" onmouseout="hideTip(this);" name="TMPFIELD" size=9   style="background-color:#efefef;width:auto;height:auto;border-width:0px;border-style:none;position:absolute;z-index:0;line-height:14px;border:none;clip:rect(0 95% 97% 0);margin-left:-13;margin-right:-50;margin-top:-19;margin-bottom:-40" multiple >  
            47. 
    
          47. </select>  
            48. 
    
          48. </body>  
            49. 
    
          49. </html>  
            50. 

          
效果圖如下：
          

          

          

          

          

			
			
          		
				posted @ 2008-06-30 09:39 飛舞的幻想 閱讀(1843) | 評論 (0) | 編輯 收藏
			
          
		
          
	


				

          




    
          
        
	




主站蜘蛛池模板：
桐城市|
河津市|
安陆市|
耒阳市|
霞浦县|
南昌县|
杭锦后旗|
平凉市|
朝阳县|
左权县|
江都市|
雅安市|
乐山市|
喀喇沁旗|
永年县|
高淳县|
汾西县|
阳曲县|
道真|
武宣县|
鱼台县|
泸州市|
江都市|
织金县|
封丘县|
榆社县|
临澧县|
遂昌县|
紫阳县|
界首市|
佛坪县|
望都县|
醴陵市|
库车县|
石家庄市|
禹州市|
剑阁县|
江安县|
湟源县|
尖扎县|
民乐县|