[no subject]

[guru prasad <guruprasadv@xxxxxxxxx>]

hai everybody
                     
                      
                      
                                            
                      
                      
                      I should produce the same xml
ffile  but with some modifications which are:
                      
                      
                     problem 1]when i encounter <Value
DataType="STRING">VARCHAR2</Value>in my original xml
file,i should change that tag into 
                                <Value
DataType="STRING">VARCHAR</Value> 
                                
                                
                                
                    
problem2]<PermanentName>S_LDD_DBMS_DATA_TYPE</PermanentName>
		       <Value DataType="STRING">NUMBER</Value>
		       </Property>
		       <Property>
		       <Label>Dbms Data Type Length</Label>
		       <PermanentName>S_LDD_LEN</PermanentName>
		       <Value DataType="INTEGER">4</Value>
		       </Property>
		       <Property>
		       <Label>Data Storage Precision</Label>
		      
<PermanentName>S_LDD_PRECISION</PermanentName>
                       <Value
DataType="INTEGER">0</Value>
                      
                      
                      whenever the integer value is
greater than 4 and precion is 0,i want that
                      
                      <Value
DataType="STRING">NUMBER</Value> to be replaced with
<Value DataType="STRING">integer</Value>
                      
                      
                      
                      whenever the integer value is
greater than 15 and precion is 0,i want that
                      
                      
                      <Value
DataType="STRING">NUMBER</Value> to be replaced with
<Value DataType="STRING">bigint</Value>
                      
                      
                       whenever the integer value is
not equal to 0 and precion is 1,i want that
		                            
		                            
		                            <Value
DataType="STRING">NUMBER</Value> to be replaced with
<Value DataType="STRING">decimal</Value>
		                            
		                            
                                                  
what iam trying to do is to convert oracle specific
datatypes into db2 specific datatypes
                                                   
                 help if possible                     
           
                                                   
                                                   
                                                  
                                                   
                                                   
                                                   
                                                   bye
guru
 
                      
                      
                     

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list