Re: [GENERAL] ECPG: inserting NULL values when using prepared statements

2007-04-03 Thread Michael Meskes
On Mon, Apr 02, 2007 at 11:53:50AM -0500, Anders Nilsson wrote: > The situation: >A loop that inserts thousands of values into a table. >In hopes of optimizing the bunches of inserts, I prepared Sorry, but that won't work. ECPG only simulates statement preparation. >a statement like t

[GENERAL] ECPG: inserting NULL values when using prepared statements

2007-04-02 Thread Anders Nilsson
The situation: A loop that inserts thousands of values into a table. In hopes of optimizing the bunches of inserts, I prepared a statement like the follows: "insert into some_table_name ( value, id, date ) values ( ?, ?, ? )" then executing the prepared statement identifier numero