There isn't a way to do that, but it wouldn't make any difference to the performance anyway.

You could try using CSVWRITE to export the data
http://h2database.com/html/functions.html#csvwrite


On 2013-05-07 22:26, Anupama Pullela wrote:
Hi,

I am using 'SCRIPT TABLE tablename' to bacup tables with very large data, and writing the result set into a file, when I see the file, the insert statements are batched as 20 records in an inset statements. how can I increase that number, for example 100 records in an insert statement?

Thanks
--
You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.



--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to