KFAA31218-E


      
         The total data length of dynamic parameters exceeds 32,000,000 bytes. <SQLSTATE: 56034>

         
            
               S:

               
                  Ignores this SQL statement. Alternatively, the system invalidates this transaction.

               

            
            
               Action:

               
                  Correct the SQL statement.

                  If you are specifying a dynamic parameter that is assumed to be of STRING type, use the scalar functions CAST or CONVERT to convert the assumed data type of the dynamic parameter to VARCHAR with the minimum required data length. The following shows an example of converting the assumed data type of a dynamic parameter to VARCHAR(100) by using the scalar functions CAST and CONVERT.

                  
                     
                        Example using the scalar function CAST

                        CAST(? AS VARCHAR(100))

                     

                     
                        Example using the scalar function CONVERT

                        CONVERT(?, VARCHAR(100))