I have select statement to select the below columns.
TABLE ABC.A :
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.