FILE: C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\110\Cartridges\db2v0801.xsl

--


	

	


	
	
	


	

	
	yes
	"
	"
	'
	'
	
	
	DB2/NT.08.01.0000	
	DB2
  

  
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
		
						
		
		
		
		29
		29
	

	
		
		    System.Data.OleDb
		    Microsoft.DataWarehouse.Design.OleDbSchema, Microsoft.DataWarehouse
		    
			    Microsoft.DataWarehouse.Controls.OleDbQueryDesigner, Microsoft.DataWarehouse
		    
		
		
		    System.Data.Odbc
		    Microsoft.DataWarehouse.Design.OdbcSchema, Microsoft.DataWarehouse
		
	

	
	
	auto
	
	yes

	
	
		
			yes
			nosubsel
			no
		
	
	
	
	
	
	

	
	
		

			
			
				
			

			
			
				
					
						
							
								
									
										
									
								
							
						
						
							
								
									
										
									
								
							
						
					
				
			

			
			
				
					
						
							
						
						
							
						
						
							
						
					
				
			

		
	

	
	
		
			(
		
			
				
			
		
			)
		
	

	
	
		
			(
		
			
				
			
		
			)
		
	

	
	
		
			
				SELECT OBJECTPROPERTY( object_id(''), 'isindexable' )
			
			
				
					(
				
				SELECT 
					
					
					, COUNT_BIG(*) AS [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a] 
					
					
					
					
					
				
					
						 
					
				
					)
				
			
		
	

	
	
		UPDATE 
			
	

	
	
		INSERT INTO 
		
	

	
	
		DELETE FROM 
			
	

	
	
		DROP 
	

	
	
		CREATE 
		
		
			
				VIEW  ( , [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a] ) WITH SCHEMABINDING AS 
			
			
				UNIQUE CLUSTERED INDEX  ON  (  )
			
			
				
				
					 (  )
				
			
		
	

	
		DISTINCT
	

	
		 AS 
	

  FROM 


	
		
	

	
		GROUP BY 
	

	
		ORDER BY 
	

	
		WHERE 
	

	
		HAVING 
	

	
		
	

	
		
	

	
		=
	

	
		
		(
			
				
			
		)
		
			VALUES
			(
				
					
				
			)
		
	

	
		
		SET 
	

	
		
	

	
		
		
	

	
		
		
			
			
		
	

	
		
			
		
		
			
		
		
			
				
			
			
				
			
		
	

	
		DATABASE 
	

	
		
	

	
		TABLE 
	

	
		
	

	
		VIEW 
	

	
		
	

	
		INDEX 
	

	
		
		
	

	
		
	

	
		
		
			    primary key   
		
	

	
		
			(
		
		
		
			)
		
	

	
		
		
		
	

	
		ASC
	

	
		DESC
	

	
	
		
			
				
					
						@
					
					
						?
					
				
			
			
				
					
				
			
		
	

	
	
		 (  )
	

	
	
		
		
			        year        
			     quarter     
			       month       
			   dayofyear   
			         day         
			        week        
			   dayofweek   
			        hour        
			      minute      
			      second      
			 microsecond 
		
	

	
	*

	
	
		
			
				 MIN 
				 MAX 
				 SUM 
			
		
		(  )
	

	
		COUNT_BIG (   )
	

	
	
	
		
			
							=		
							<>	
							>		
				=		]]>
								<	
						<=	
								IN		
								AND		
								OR		
								+		
							-		
							/		
							*		
			
		
		(
			
				
			
		)
	


	
	
	
		
			
							IS NULL		
			
		
		(
			
			
		)
	

	
	
		
		
			    varchar     
			    varchar     
			     char        
			    smallint    
			      smallint    
			      smallint    
			      integer     
			      bigint      
			     smallint    
			     smallint    
			     integer     
			     bigint      
			      real        
			      float       
			    timestamp     
			    timestamp     
			      double       
			 varchar() for bit data    
			    varchar     
			 varchar() for bit data  
			 decimal      
		
		
		
		
	

	
	
	(  )
	
	
	
	
	( 
	

	
	
	,  )
	
	
	
		CAST( AS )
	
	
	
	
	

	
	 
		

		
			
		
		
			
		
		
			
		
		
			
				
			
			
				
			
		
	

	
	 
		

		
		
			
			
		
		
	

	
	 
		

		
		
			
			
		
		
	

	
	 
		
		

		
			
				
				
				
				
					
					
				
			
			
				
			
		
	

	
	
		
		
		
			
			
		
	

	
	
		
		

		
			
			
				
			
		
	

	
	
		

		
		
			
		
	

	
	
		

		
		
		
			
			
			
			CAST(  AS bit)
			
			
			
			
			
			
			
			
			
			
			CAST(  AS timestamp)
			CAST(  AS timestamp)
			CAST(  AS money)
			
            
			
			
		
	


--