It could be a workaround but NOT good to reduce the rows per commit which had side effect on performance. The max allowed length should be enlarged as today's powerful hardware.
It's nice to be an ODBC configure option to configure the size.
Let me know your concerns.
The maximum allowed length limit is not coming from Teradata ODBC Driver itself, but it is the maximum size of a SQL request(including data for parameters) Teradata database can accept. ODBC Driver might be able to emulate(by sending multiple 1MB sized SQL requests to Teradata database) as if there is no limit but that is not much different compared to what application can do as on today.