I have two questions related to DB2 10.1 LUW. I have a statement like this that is dynamically built in PHP and run against a MYSQL database. We are migrating the MYSQL db to DB2, and I need to figure out the best approach for converting this sql to DB2.
Question1: Is it better to run this statement using bind variables in DB2 or leave as is with string literals?
Question2: If bind vars is better, is there an example out there that shows how to bind in cases like this where there are multiple rows in same INSERT?