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.
Calls to ifx_allow_newline() affect only the user session from which that routine is invoked.