This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a workflow in designer on a Windows Server 2012 R2. Within the workflow, I am trying to pass a parameter via user input from a text box tool to a Dynamic Select Tool that has a SQL statement querying DB2. As an example, a typical entry would be the number 1.
When the user types a 1, that value is used in the query. However, I keep getting an error "Error: Dynamic Input (7): Error SQLExecute: [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL0302 - Conversion error on variable or parameter *N."
I noticed that the data type for the field in the query is a decimal. I tried using a Select tool to make the parameter value from my text input a fixed decimal, but I am still getting the error. I'm not sure what else to try.
On your Update WHERE Clause - you are saying that the field is an integer but your select tool has it configured to be a Float - the conversion error is likely arising from that.
If the field is FLOAT in your underlying DB, then change the WHERE Clause update to reflect the data element to be Float. If it is integer in your underlying DB, modify the select tool to cast it to an Int64.