ALLOW_NEWLINE

onconfig.std value

0

range of 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

When the database server is shut down and restarted

refer to

The following material:

• Quoted strings in the IBM Informix Guide to SQL: Syntax
• Newline characters in quoted strings in the IBM Informix ESQL/C Programmer's Manual

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 all sessions, set the ALLOW_NEWLINE parameter in the ONCONFIG file. To allow all remote sessions in a distributed query to support embedded newline characters, specify ALLOW_NEWLINE in their ONCONFIG files.

To allow or disallow a newline character in a quoted string for a particular session when ALLOW_NEWLINE is not set, you must execute the ifx_allow_newline(boolean) user-defined routine (UDR).