StripNewlines
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
Purpose
Specifies whether newline characters in a SQL statement are sent to the DB2 server. If you know that SQL statements in your application do not contain newline characters, the driver can skip the removal of newline characters, improving performance by eliminating the parsing required by the DB2 server to remove them.
Valid Values
true | false
Behavior
If
set to true, the driver removes all newline characters from
SQL statements.
If set to false, the driver
does not remove any newline characters from SQL statements.
Default
false
Data Type
boolean