Requirement is to schedule a SQL query to run and save output as excel file from DB2 database.
Exported columns have CLOB data as well sometimes having multiple lines and comma separated information. When CSV file is opened, some rows split data across multiple rows because of this CLOB data.
Can we preserve its data?
I have tried to export data into CSV by applying some DB2 character conversion functions. But still facing problems.
