IIUG Deutsche Forum

urgent | | is inserted in text field with /

Posted By: MEHDI BELAJOUZA
Date: Saturday, 29 December 2007, at 4:49 p.m.

the goal is to insert a string containing | | in a column of
text type

when we try to insert a query containing pipe ||in a text field , the result of insertion shows that supplementary junk slash are added to pipe as indicated below for IDS version 9.4

1°/ sample of the begenning of the query that we want to insert in a text field
select trim(substr(lpad(cpp_id,10,"
"),1,5)||"01"||substr(lpad(cpp_id,10,"0"),6,5))1|1|actor|pps2_6_5f||N|

2°/ result of the insertion
select trim(substr(lpad(cpp_id,10,"
"),1,5)\|\|"01"\|\|substr(lpad(cpp_id,10,"0"),6,5)),
"12","","",decode(cpp_etat,3,72,68) ,(((( ca_dt_creat - 2 units hour -
DBINFO("utc_to_datetime",946684800) )::INTERVAL SECOND(9) TO SECOND \|\|
"")::int + 946684800) *1000) ::int8,(((( NVL(cpp_dt_modif,CURRENT) - 2
units hour - DBINFO("utc_to_datetime",946684800) )::INTERVAL SECOND(9)
TO SECOND \|\| "")::int + 946684800) *1000) ::int8 from cust_access,
cust_ppaid_v2 where ca_id = cpp_id and cpp_numtel <> "default" and
cpp_etat <> 0|

3°/ the tablE structure used is indicated below and the field whre the query tex t is inserted is sqlselect

{ TABLE "informix".query row size = 131 number of columns = 7 index size
= 12 }
create table "informix".query
(

formid serial not null ,

projectid integer,

name char(30),

database char(30),

arrayname char(30),

lockflag char(1),

sqlselect text
) extent size 16 next size 16 lock mode page;
revoke all on "informix".query from "public";

4°/ question how could we insert the query text with || without suplementary /

IIUG Deutsche Forum is maintained by Administrator with WebBBS 5.12.