IDS Forum

RE: urgent is inserted in text field with /

Posted By: Gaurav Saxena3
Date: Monday, 31 December 2007, at 4:42 a.m.

In Response To: RE: urgent is inserted in text field with / (Marcus Haarmann)

Your data "|" will be inserted just fine.

I would like to know that how are you retrieving the data to find out there
are these extra '\'. Note that the unload from dbaccess and dbexport will
do some formatting for example:
will add "\ " while unloading the data like "" and the case like you have
mentioned (have not checked it but looks like it does for "|" too).

even if the data is not having "\" in database table.

This is done to ensure that when you load from same unloaded file, these
utilities exactly know that what is to be sent to the server to create "as
is image" of the data. In the case, you mentioned, this formatting might be
required for differentiating between data "|" and delimiter "|".

There are other ways to retrieve the data, for example, If you use plain
ESQL/C program for selecting the data, you will not see these '\' unless
you want it to.

Thanks and Regards,
Gaurav

"Marcus Haarmann"

<marcus.haarmann@

midoco.de> To

Sent by: ids@iiug.org

ids-bounces@iiug. cc

org

Subject

RE: urgent is inserted in text

30/12/2007 17:22 field with / [10812]

Please respond to

ids@iiug.org

Hi,
The question is how do you try to insert the value ? With a dbaccess
script ? Or a program ? Which programming language is used and how do
you fill the insert statement ?

Marcus

-----Original Message-----
From: MEHDI BELAJOUZA [mailto:belajouza@hotmail.com]
Sent: Saturday, December 29, 2007 10:31 PM
To: ids@iiug.org
Subject: urgent | | is inserted in text field with / [10811]

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 / ?

************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.

*******************************************************************************

Forum Note: Use "Reply" to post a response in the discussion forum.

See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!

Messages In This Thread

• urgent | | is inserted in text field with /
  MEHDI BELAJOUZA -- Saturday, 29 December 2007, at 4:30 p.m.
  • RE: urgent is inserted in text field with /
    Marcus Haarmann -- Sunday, 30 December 2007, at 6:52 a.m.
    • Re: RE: urgent is inserted in text field with /
      MEHDI BELAJOUZA -- Monday, 31 December 2007, at 3:51 a.m.
    • RE: urgent is inserted in text field with /
      Gaurav Saxena3 -- Monday, 31 December 2007, at 4:42 a.m.
      • Re: RE: urgent is inserted in text field with /
        MEHDI BELAJOUZA -- Monday, 31 December 2007, at 5:26 a.m.
        • Re: RE: urgent is inserted in text field with /
          Gaurav Saxena3 -- Monday, 31 December 2007, at 5:44 a.m.
        • Re: urgent is inserted in text field with /
          Art S. Kagel (Oninit LLC) -- Monday, 31 December 2007, at 7:57 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.