Informix

Hi.
I'm on 14.10.FC4W1.
I have ALLOW_NEWLINE set to 1 in my onconfig file.
But after I execute
execute procedure ifx_allow_newline('f');
I still can insert strings with new line chars. Is this the expected behaviour?
This runs without an error:


drop procedure if exists check_nl();
create procedure check_nl() returns varchar(255);
define s varchar(255);
let s = "String with "||chr(10)|| " a newline";
create temp table tt (a varchar(255));
insert into tt values(s);
execute procedure ifx_allow_newline('f');
insert into tt values(s);
return s;
end procedure;

Thanks in advance,
-Snorri

------------------------------
Snorri Bergmann
------------------------------

#Informix

This parameter is only for the syntax check of the parser.

Example:

execute procedure ifx_allow_newline('t');

select "This is a test for
       NEWLINE"

from systables where tabid = 1;

(constant)
This is a test for
      NEWLINE
1 row(s) retrieved.

execute procedure ifx_allow_newline('f');

select "This is a test for
       NEWLINE"

from systables where tabid = 1;

  282: Found a quote for which there is no matching quote.

Error in line 4

Newr character position 8

------------------------------
Gerd Kaluzinski
------------------------------

Original Message:
Sent: Mon November 23, 2020 10:00 AM
From: Snorri Bergmann
Subject: ALLOW_NEWLINE

Hi.
I'm on 14.10.FC4W1.
I have ALLOW_NEWLINE set to 1 in my onconfig file.
But after I execute
execute procedure ifx_allow_newline('f');
I still can insert strings with new line chars. Is this the expected behaviour?
This runs without an error:


drop procedure if exists check_nl();
create procedure check_nl() returns varchar(255);
define s varchar(255);
let s = "String with "||chr(10)|| " a newline";
create temp table tt (a varchar(255));
insert into tt values(s);
execute procedure ifx_allow_newline('f');
insert into tt values(s);
return s;
end procedure;

Thanks in advance,
-Snorri

------------------------------
Snorri Bergmann
------------------------------

#Informix

Thanks Gerd.
The manual was not too clear on this IMO.

Regs,
-Snorri

------------------------------
Snorri Bergmann
------------------------------

Original Message:
Sent: Tue November 24, 2020 02:35 AM
From: Gerd Kaluzinski
Subject: ALLOW_NEWLINE

This parameter is only for the syntax check of the parser.

Example:

execute procedure ifx_allow_newline('t');

select "This is a test for
       NEWLINE"

from systables where tabid = 1;

(constant)
This is a test for
      NEWLINE
1 row(s) retrieved.

execute procedure ifx_allow_newline('f');

select "This is a test for
       NEWLINE"

from systables where tabid = 1;

  282: Found a quote for which there is no matching quote.

Error in line 4

Newr character position 8

------------------------------
Gerd Kaluzinski

Original Message:
Sent: Mon November 23, 2020 10:00 AM
From: Snorri Bergmann
Subject: ALLOW_NEWLINE

Hi.
I'm on 14.10.FC4W1.
I have ALLOW_NEWLINE set to 1 in my onconfig file.
But after I execute
execute procedure ifx_allow_newline('f');
I still can insert strings with new line chars. Is this the expected behaviour?
This runs without an error:


drop procedure if exists check_nl();
create procedure check_nl() returns varchar(255);
define s varchar(255);
let s = "String with "||chr(10)|| " a newline";
create temp table tt (a varchar(255));
insert into tt values(s);
execute procedure ifx_allow_newline('f');
insert into tt values(s);
return s;
end procedure;

Thanks in advance,
-Snorri

------------------------------
Snorri Bergmann
------------------------------

#Informix