KFAA72004-E


      
         An error occurred in data type conversion processing performed by the ODBC driver. <SQLSTATE: 07006, 22003, 22007, 22018, 5C002, 5C037, 5C038, HY001, HY003, HY004, HY009, HY013, HY090, HY104, HYC00>

         
            
               aaaa: 

               
                  Number of the column in which the error occurred

               

            
            
               bb....bb: 

               
                  Value of SQLSTATE

               

            
            
               cc....cc: 

               
                  ODBC SQL data type whose conversion failed

               

            
            
               dd....dd: 

               
                  C data type whose conversion failed

               

            
            
               ee....ee: 

               
                  Cause of the error

               

            
            
               S: 

               
                  Terminates processing.

               

            
            
               Action:

               
                  Check the following and take corrective action, as necessary:

                  
                     
                        SQLSTATE value displayed in place of bb....bb

                     

                     
                        Data type conversion combination

                     

                     
                        Cause of the error displayed in place of ee....ee

                        The following table lists the possible causes of the error that are displayed in place of ee....ee and the corrective action to take.

                        

                              
                              
                              
                              
                                 
                                    
                                       Item No.

                                    

                                    
                                       Content displayed for ee....ee

                                    

                                    
                                       Cause of the error and corrective action to take

                                    

                                 

                              

                              
                                 
                                    
                                       1

                                    

                                    
                                       conversions are not supported

                                    

                                    
                                       The combination of data types that was specified cannot be converted. Change the combination of data types specified to a combination of data types that can be converted. For details about the combinations of data types that can be converted, see Combinations of data types that can be retrieved (conversion from ODBC's SQL data types to C data types), under Correspondence between ODBC's SQL data types and C data types, in the HADB Application Development Guide.

                                    

                                 

                                 
                                    
                                       2

                                    

                                    
                                       value outside the scope of the conversion destination data type

                                    

                                    
                                       The value is outside the range for the data type into which the value will be converted. Change the data type into which the value will be converted to something larger.

                                    

                                 

                                 
                                    
                                       3

                                    

                                    
                                       data type cannot be converted

                                    

                                    
                                       The data format cannot be converted. Specify a different data type, or re-enter the data in the correct data format.

                                    

                                 

                                 
                                    
                                       4

                                    

                                    
                                       multiple reasons

                                    

                                    
                                       One of the following errors has occurred:

                                       
                                          
                                             The value is outside the range for the data type into which the value will be converted.

                                          

                                          
                                             The data format cannot be converted.

                                          

                                       

                                       Take the corrective action for item 2 or item 3, or check the value of SQLSTATE.

Item No.	Content displayed for ee....ee	Cause of the error and corrective action to take
1	`conversions` `are` `not` `supported`	The combination of data types that was specified cannot be converted. Change the combination of data types specified to a combination of data types that can be converted. For details about the combinations of data types that can be converted, see Combinations of data types that can be retrieved (conversion from ODBC's SQL data types to C data types), under Correspondence between ODBC's SQL data types and C data types, in the HADB Application Development Guide.
2	`value` `outside` `the` `scope` `of` `the` `conversion` `destination` `data` `type`	The value is outside the range for the data type into which the value will be converted. Change the data type into which the value will be converted to something larger.
3	`data` `type` `cannot` `be` `converted`	The data format cannot be converted. Specify a different data type, or re-enter the data in the correct data format.
4	`multiple` `reasons`	One of the following errors has occurred: The value is outside the range for the data type into which the value will be converted. The data format cannot be converted. Take the corrective action for item 2 or item 3, or check the value of `SQLSTATE`.