I'm having an problem using parameter mapping in SQL Insert component to write to a database. I am trying to insert a := '1234567' and b := '12345678' with this statement...
INSERT into mmdsbx.plpwritetest (a, b) VALUES (?, ?)
...I get an error message Property "b" too long for column; 8 vs. maximum of 7.
I believe this is on the PP mapping end, because when I hardcode the values into the statement...
INSERT into mmdsbx.plpwritetest (a, b) VALUES ('1234567','12345678')
...it writes successfully. Am I missing some subtlety about how PP maps the parameters? SQL Insert settings are below (if it pastes correctly). Both a and b are String types in PP. Appreciate any help.
