Hi all,
I am using a "DB2 v8.1.1.96" on AIX.

I have select statement to select the below columns.

TABLE ABC.A :

ID VARCHAR(60)
PROBLEM_NO VARCHAR(60)
PROBLEM LONGVARCHAR(32700)

db2 "EXPORT TO data.dat OF del modified by coldel| select ID, PROBLEM_NO, PROBLEM from ABC.A with ur;

cat data.dat | sed "s/\"//g" > data.txt

The issue is I am having multiple lines for the same record in data.txt file as the PROBLEM column have new line characters.
Is there a way to use any REPLACE functions are any other way so that the text file has each record in a single line.

Thanks all...

REPLACE(REPLACE(MyCol,chr(10),' '),chr(13),' ') should get you there.

Andy