ALLOW_NEWLINE configuration parameter
Use the ALLOW_NEWLINE configuration parameter to allow or disallow newline characters in quoted strings for all sessions.
To allow all remote sessions in a distributed query to support embedded newline characters, specify ALLOW_NEWLINE in their onconfig files.
- onconfig.std value
- ALLOW_NEWLINE 0
- values
- 0 = Disallow the newline character in quoted
strings for all sessions.
1 = Allow the newline character in quoted strings for all sessions.
- takes effect
- After you edit your onconfig file and restart the database server.
Usage
You can specify that you want the database server to allow the newline character (\n) in a quoted string either for all sessions or for a specific session. A session is the duration of a client connection to the database server.
To
allow or disallow newline characters in quoted strings for the current
session when ALLOW_NEWLINE is not set, you can execute the built-in ifx_allow_newline() routine
with 't' or 'f' as its only argument.
- 't' enables support for newline characters within quoted strings.
- 'f' has the opposite effect.