Non-printable sign

From: DeMi <michal.demyda@xxxxxxxxx>
Date: Mon, 26 May 2008 02:23:17 -0700 (PDT)

Hello,

I have problem with replacing non-printable 'new line' sign (^J) to
null. Actually, I don't know if Informix provides function like
Oracle's ord() or ascii() which would be helpful.
My task is to unload rows from sql query into file with default
delimiter '|'. It is very important that each record is written in one
separate line. However, it happens that one field can contain the 'new
line' sign. In this case my row is split into two lines which is not
allowed. The interested field is varchar type.

Does anybody solved this kind of problem and how?

Best regards
Michal Demyda
.

Follow-Ups:
- Re: Non-printable sign
  - From: Doug Lawry
- Re: Non-printable sign
  - From: Claus Samuelsen
- Re: Non-printable sign
  - From: Jonathan Leffler
- Re: Non-printable sign
  - From: Michael Krzepkowski

Prev by Date: How many sql queries?
Next by Date: Re: Non-printable sign
Previous by thread: How many sql queries?
Next by thread: Re: Non-printable sign
Index(es):
- Date
- Thread

Relevant Pages

Re: Non-printable sign
... I don't know if Informix provides function like ... Oracle's ord() or ascii() which would be helpful. ... My task is to unload rows from sql query into file with default ...
(comp.databases.informix)
Re: Non-printable sign
... I don't know if Informix provides function like ... Oracle's ord() or ascii() which would be helpful. ... My task is to unload rows from sql query into file with default ...
(comp.databases.informix)
Re: Non-printable sign
... Oracle's ord() or ascii() which would be helpful. ... My task is to unload rows from sql query into file with default ... the REPLACE function search string. ...
(comp.databases.informix)
Re: Non-printable sign
... EXECUTE PROCEDURE IFX_ALLOW_NEWLINE; ... Doug Lawry ... I don't know if Informix provides function like ... My task is to unload rows from sql query into file with default ...
(comp.databases.informix)